File manager

File manager - Edit - /home/autoph/public_html/connectv1/notes.txt

Back
//get id of inserted data public function sql_query_id($query) { $connection = $this -> connect(); $result = $connection -> query($query) ; return $connection -> insert_id; } xampp mysql access user accounts -> edit prev. -> login info change host name to any host access phpmyadmin -> httpd-xampp.conf Require all granted //reset DELETE FROM `customer_business` WHERE 1; DELETE FROM `customer_contact` WHERE 1; DELETE FROM `customer` WHERE 1; DELETE FROM `customer_interest_list` WHERE 1; DELETE FROM `customer_dms` WHERE 1; DELETE FROM `source_of_inquiry` WHERE id != 0; DELETE FROM `vehicle_color` WHERE id != 0; DELETE FROM `vehicle_purchase_car_as` WHERE id != 0; DELETE FROM `source_brand` WHERE id != 0; DELETE FROM `source_car_model` WHERE `id` != 0; DELETE FROM `vehicle_notes` WHERE 1; DELETE FROM `vehicle` WHERE 1; DELETE FROM `source_finance_company` WHERE id != 0; DELETE FROM `source_insurance_company` WHERE id != 0; DELETE FROM `source_insurance_type` WHERE id != 0; DELETE FROM `service` WHERE 1; DELETE FROM `service_notes` WHERE 1; DELETE FROM `service_history` WHERE 1; DELETE FROM `sales` WHERE 1; DELETE FROM `report` WHERE 1; DELETE FROM `report_status` WHERE 1; DELETE FROM `notification_list` WHERE 1; DELETE FROM `source_company_dealer` WHERE `id` not in (0) AND type NOT IN (0); DELETE FROM `employee` WHERE `employee_id` not in ('1','60418'); DELETE FROM `employee_account` WHERE `employee_id` not in ('1','60418'); DELETE FROM `employee_contact` WHERE `employee_id` not in ('1','60418'); DELETE FROM `employee_account_key` WHERE 1; //DELETE WITH SPECIFIC COMPANY_DEALLER_ID (WARNING) DELETE aa FROM customer_contact aa INNER JOIN customer ON aa.customer_id = customer.id INNER JOIN customer_dms ON customer.id = customer_dms.customer_record_id WHERE customer_dms.company_dealer_id = 5; DELETE aa FROM customer_business aa INNER JOIN customer ON aa.customer_id = customer.id INNER JOIN customer_dms ON customer.id = customer_dms.customer_record_id WHERE customer_dms.company_dealer_id = 5; DELETE aa FROM customer_interest_list aa INNER JOIN customer ON aa.customer_id = customer.id INNER JOIN customer_dms ON customer.id = customer_dms.customer_record_id WHERE customer_dms.company_dealer_id = 5; DELETE c FROM customer c INNER JOIN customer_dms ON c.id = customer_dms.customer_record_id WHERE customer_dms.company_dealer_id = 5; DELETE WITH SPECIFIC COMPANY_ID (WARNING) DELETE aa FROM customer_contact aa INNER JOIN customer ON aa.customer_id = customer.id INNER JOIN customer_dms ON customer.id = customer_dms.customer_record_id INNER JOIN source_company_dealer scd ON customer_dms.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE sc.id = 7; DELETE aa FROM customer_business aa INNER JOIN customer ON aa.customer_id = customer.id INNER JOIN customer_dms ON customer.id = customer_dms.customer_record_id INNER JOIN source_company_dealer scd ON customer_dms.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE sc.id = 7 DELETE aa FROM customer_interest_list aa INNER JOIN customer ON aa.customer_id = customer.id INNER JOIN customer_dms ON customer.id = customer_dms.customer_record_id INNER JOIN source_company_dealer scd ON customer_dms.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE sc.id = 7 DELETE c FROM customer c INNER JOIN customer_dms ON c.id = customer_dms.customer_record_id INNER JOIN source_company_dealer scd ON customer_dms.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE sc.id = 7 DELETE c FROM customer_dms c INNER JOIN source_company_dealer scd ON c.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE sc.id = 7 //DELETE BRAND NOT CONNECTED TO ANY SOURCE DELETE sb from source_brand sb LEFT OUTER JOIN vehicle v ON sb.id = v.brand_id LEFT OUTER JOIN service se ON sb.id = se.brand_id LEFT OUTER JOIN sales s ON sb.id = s.brand_id WHERE v.brand_id is NULL AND se.brand_id is NULL AND s.brand_id is NULL //DELETE MODEL NOT CONNECTED TO ANY SOURCE SELECT * from source_car_model sb LEFT OUTER JOIN vehicle v ON sb.id = v.model_id LEFT OUTER JOIN service se ON sb.id = se.model_id LEFT OUTER JOIN sales s ON sb.id = s.model_id WHERE v.model_id is NULL AND se.model_id is NULL AND s.model_id is NULL -------------------------------NEW CLEAR DB QUERY----------------------------------------------------- DELETE FROM `customer` WHERE 1; DELETE FROM `customer_contact` WHERE 1; DELETE FROM `customer_dms` WHERE 1; DELETE FROM `customer_affiliations_content` WHERE 1; DELETE FROM customer_affiliations_list WHERE 1; DELETE FROM customer_interest_list WHERE 1; DELETE FROM customer_contact_person WHERE 1; DELETE FROM `vehicle` WHERE 1; DELETE FROM `service` WHERE 1; DELETE FROM `service_history` WHERE 1; ----------------------------------------------------------------------------------------------- MYSQL Server Config SHOW SESSION VARIABLES LIKE "%wait_timeout%"; or SHOW SESSION VARIABLES LIKE "wait_timeout"; SET session wait_timeout=300; and (select count() from foo where bar) > 5 or group by baz having count() > 5 SELECT * FROM customer c INNER JOIN customer_dms cd ON c.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id=scd.id INNER JOIN source_dealer sd ON scd.dealer_id=sd.id WHERE sd.id = 89 AND c.status = 1 //COUNT DATA SPECIFIC DEALERS SELECT COUNT(1) FROM (SELECT COUNT(1) FROM customer c INNER JOIN customer_dms cd ON c.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id=scd.id INNER JOIN source_dealer sd ON scd.dealer_id=sd.id WHERE sd.id = 59 GROUP BY c.id) as pusa //SELECT ALL DEALERS AND THEIR COUNT SELECT code, (SELECT COUNT(1) FROM (SELECT sd.id FROM customer c INNER JOIN customer_dms cd ON c.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id=scd.id INNER JOIN source_dealer sd ON scd.dealer_id=sd.id GROUP BY c.id) as pusa WHERE pusa.id = source_dealer.id ) FROM source_dealer //SELECT ALL COMPANY AND THEIR COUNT SELECT code, (SELECT COUNT(1) FROM (SELECT sc.id FROM customer c INNER JOIN customer_dms cd ON c.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id=scd.id INNER JOIN source_company sc ON scd.company_id=sc.id GROUP BY c.id) as pusa WHERE pusa.id = source_company.id ) FROM source_company //GET COMPANY DEALER COUNT SELECT sc.id,sc.code,sd.code,sd.id, (SELECT COUNT(1) FROM ( SELECT scd.dealer_id,scd.company_id FROM customer c INNER JOIN customer_dms cd ON c.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id=scd.id ) as pusa WHERE pusa.dealer_id = sd.id AND pusa.company_id = sc.id) FROM source_dealer sd INNER JOIN source_company_dealer scd ON sd.id = scd.dealer_id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE scd.type = 1 ORDER BY sc.code ASC UPDATE FIRST ON DUPS UPDATE customer_contact AS t JOIN ( SELECT MIN(ID) MinID FROM customer_contact GROUP BY mobile_phone_1 HAVING COUNT(*) > 1 ) AS m ON t.ID = m.MinID SET t.mobile_phone_1 = CONCAT( t.mobile_phone_1,'12321') UPDATE customer_contact SET mobile_phone_1 = REPLACE(mobile_phone_1, '112321', '') ================================================================================================================================== FIX ONLY_FULL_GROUP_BY & STRICT_TRANS_TABLES Error pag nag zero (0) yung customer count sa dashboard or walang list ang customer SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); SET sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES','')); SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES','')); SET time_zone = '+08:00'; sudo nano /etc/mysql/my.cnf Add this to the end of the file [mysqld] sql_mode = "NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" default-time-zone='+08:00' sudo service mysql restart to restart MySQL CREDITS: 1. Vehicle Type List: https://stylesatlife.com/articles/types-of-cars/ 2. Vehicle Transmission Type: https://www.motorbiscuit.com/4-types-of-car-transmissions-and-how-they-work/ 3. Top 100 Networking Companies in Philippines: https://www.affordablecebu.com/load/business/top_network_marketing_companies_in_the_philippines_mlm/6-1-0-121 SOURCES/OTHER PLUGINS: 1. Sweet Alert: https://sweetalert2.github.io/#configuration FINALIZE: (Before using the system) 1. Collect overall exact options/choices in Source of inquiry / source of sales (ex: referral, walk-in, repeat sales, etc) 2. Collect overall exact options/choices in Type of Payment (ex: cash, lyka gem, financing, etc) 3. Group Managers (id number, name) 4. Sales Consultant (id number, name) eported error code “128” when it ended: Permission denied (publickey). fatal: Could not read from remote repository. Please make sure you have the correct access rights and the repository exists. https://stackoverflow.com/questions/12940626/github-error-message-permission-denied-publickey -------------------------------------------------------- KHEL -------------------------------------- >> $("#bank-dropdown").select2().select2('val','1'); ------------------------------------------------------------- KHEL ------------------------------------------------------------- // ---------------------------------------checking of time in between 8am to 8pm-------start // $current_time = ""; // $get_current_time = $db->sql_query("SELECT NOW() AS time_now"); // foreach ($get_current_time AS $data){ // $current_time = $data['time_now']; // } //echo substr($current_time, 11, 8); // $current_time = substr($current_time, 11, 8); // // $current_time = "7:59:00"; // $start = "08:00:00"; // 8am // $end = "20:00:00"; // 8pm // $date1 = DateTime::createFromFormat('H:i:s', $current_time); // $date2 = DateTime::createFromFormat('H:i:s', $start); // $date3 = DateTime::createFromFormat('H:i:s', $end); // if ($date1 > $date2 && $date1 < $date3){ // in between 8am and 8pm // //echo "In"; exit; // } // else { // echo "Out"; exit; // } // ---------------------------------------checking of time in between 8am to 8pm-------end //-----------------------------------------BIRTHDAY REPORT QUERY--------------------------------start SELECT tbbr.first_name, tbbr.last_name, tbbr.mobile_number, sc.name AS company, sd.name AS dealer FROM text_blast_birthday_record tbbr INNER JOIN source_company sc ON sc.id = tbbr.company_id INNER JOIN source_dealer sd ON sd.id = tbbr.dealer_id WHERE DATE_FORMAT(date, '%m-%d') = '09-27' AND tbbr.status = 1 //-----------------------------------------BIRTHDAY REPORT QUERY--------------------------------end //-----------------------------------------THANK YOU REPORT QUERY--------------------------------start SELECT tbnir.first_name, tbnir.last_name, tbnir.mobile_number, sc.name AS company, sd.name AS dealer, tbnir.date_uploaded, tbnir.released_date, tbnir.uploaded_by FROM text_blast_new_import_record tbnir INNER JOIN source_company sc ON sc.id = tbnir.company_id INNER JOIN source_dealer sd ON sd.id = tbnir.dealer_id WHERE DATE_FORMAT(tbnir.date_uploaded, '%Y-%m-%d') = '2021-09-17' AND tbnir.status = 1 //-----------------------------------------THANK YOU REPORT QUERY--------------------------------end //-----------------------------------------SITES-------------------------------------------------start Nature of business https://www.sos.la.gov/BusinessServices/PublishedDocuments/Industry%20Business%20Type%20List.pdf https://www.census.gov/programs-surveys/aces/information/iccl.html https://www.marketing91.com/19-types-of-business-industries/ https://corporatefinanceinstitute.com/resources/knowledge/economics/industry/ https://www.ibisworld.com/united-states/list-of-industries/ //-----------------------------------------SITES-------------------------------------------------end

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings