Posts

Showing posts from March, 2023

read csv file to array in php

 $abcfile = ABSPATH.'wp-content/themes/xpendy/subscriptions17.csv';         // print( $abcfile.'<br>' );         $count = 0; if (($open = fopen($abcfile, "r")) !== FALSE)    {      echo "123<pre>";        while (($data = fgetcsv($open, 1000, ",")) !== FALSE)      {     // if ($data[27] != '4.95' && $data[31] != 'Subscription') {        // print_r($data);        $inscou = $wpdb->insert('table2',         array(           'orderid' => $data[0],           'emailid' => $data[12]                    ));         // if ($inscou) {         //    $count = $count + 1;         //  }        // }    ...

Xpendy Pending

 1) Experiment Xpendy | E-mail domain suggestion Done 2) Xpendy Experiment | Change red error color to orange Done 3) My Xpendy | Implementation of credit card payments in ChargeBee 4) My Xpendy | Briefing split audience Mailchimp 5) Xpendy | Customers can only do one conversion from oneclick email Done 6) Xpendy | Send letters by e-mail Done 7)My Xpendy | Optimization of IT and ES Done 8)Experiment Xpendy | XPE-0110 - Form field bigger than letter  pending 9)Xpendy | Implement experiment 100% on live website NL Done 10)Xpendy | Implement XPE-0112 experiment for AT website Done 11)Xpendy | Third mail - proof of arrival implementation Pending 12)Xpendy | Adding code for experimentation tool in progress 13)Xpendy | Automating SEO content + Add Button for changes & category error - feedback  in progress 14)Xpendy | Split testing collection mail NL via Mandrill Pending https://docs.google.com/spreadsheets/d/1C2NsDA72aeaIYDE7KNyTopcUernHWAvVGCocEzksKhQ/edit?usp=sharing 15)...

ITR

 with rent 46540 58708 rent 15000 atc lic ppf turion fees sunkya     150000 atd heth 25k  60 761000

Angular

 services what reactive form kaise validation  save data http calls kaise karte hai hai services me api send karne 

MYSQL Group By

 SELECT YEAR(suscribed_at), MONTH(suscribed_at), count(id) FROM `xp_myxpendy_subscription` WHERE `subscription_id` IS NOT NULL GROUP BY YEAR(suscribed_at), MONTH(suscribed_at)

Sql long text bolb issue

 SET GLOBAL innodb_strict_mode = 0;

SME QUEstions

 merchant create from where? brand creation? brand customers?(how we create) pwa site                                                                                                                     300 new orders popup how it works? merchant rules for dashbords? once we swith brand to merchant can see all orders of brand. how cuppons work how commision work(how can see in fron end) orders payout? Dispute Orders? Refund suttelment? in db categories 11 table which are working? barnd cat stroe brand cat categories categpries_live 629 630 632 633 634 635 642

woocommerce awalaible payment gateways

 $available_payment_methods = WC()->payment_gateways()->get_available_payment_gateways();  foreach($available_payment_methods as $gateway){  //  echo "<pre>";  // print_r($gateway->id);  if ( $gateway->id == 'mollie_wc_gateway_creditcard') {   $gateway->settings['mollie_components_enabled'] = 'no';  }  // print_r($gateway->settings);  // print_r($gateway->form_fields);  }                         

Git Few commands

 git checkout -b feature/ChargeBack   for create new branch git pull origin development git add . git commit -m "Resolve the merge conflict" git push

Mysql Date format query from datetime

 Select * From xp_failed_order_mail where mail1 ='1' and mail2 ='0' and mail3 ='0' and mail4 ='0' and DATE_FORMAT(created_at,'%Y-%m-%d') <= '2023-02-01' and DATE_FORMAT(created_at,'%Y-%m-%d') > '2023-01-01' and status = 'wc-pending'

Mysql Subquery

 SELECT * FROM `xp_postmeta` WHERE `meta_key` = 'old_order_id' and post_id IN (SELECT order_id FROM `xp_failed_order_mail` WHERE `mail4` = '1' AND `order_total` < '40')