File manager

File manager - Edit - /home/autoph/public_html/connectv1/src/Models/Lto.php

Back
<?php namespace App\Models; use App\Core\Database; use App\Core\Model; class Lto extends Model { public function checkorcrPlateExisting($array_data) { $query = "SELECT * FROM vehicle_orcr_plate_status WHERE 1 AND vehicle_id = ? AND type= ? AND date_received = ? AND status = 1"; $queryType = "iss"; $queryValue = array( $array_data['vehicle_id'], $array_data['type'], $array_data['date_received'], ); return Database::connect()->runQuery($query, $queryType, $queryValue); } public function updateOrcrPlatePickup($array_data) { $query = "UPDATE `vehicle_orcr_plate_status` SET pickup_date = NOW() WHERE 1 AND id = ?"; $paramType = "i"; return Database::connect()->update($query, $paramType, $array_data); } public function updateOrcrPlateSms($array_data) { $query = "UPDATE `vehicle_orcr_plate_status` SET sms_response = ? ,sms_date = ? WHERE 1 AND id = ?"; $paramType = "ssi"; $paramValue = array( $array_data['sms_response'], $array_data['sms_date'], $array_data['record_id'], ); return Database::connect()->update($query, $paramType, $paramValue); } public function updateOrcrPlate($array_data) { $query = "UPDATE `vehicle_orcr_plate_status` SET vehicle_id = ? , type = ?, status = ? , date_received = ?, notes = ? WHERE 1 AND id = ?"; $paramType = "isissi"; $paramValue = array( $array_data['vehicle_id'], $array_data['type'], $array_data['status'], $array_data['date_received'], $array_data['notes'], $array_data['record_id'], ); return Database::connect()->update($query, $paramType, $paramValue); } public function createOrcrPlate($array_data) { $query = "INSERT INTO `vehicle_orcr_plate_status` ( `vehicle_id`, `type`, `user_id`, `status`, `date_received`, `notes`, `date_added`) VALUES (?,?,?,?,?,?,NOW()); "; $paramType = "isiiss"; $paramValue = array( $array_data['vehicle_id'], $array_data['type'], $array_data['user_id'], $array_data['status'], $array_data['date_received'], $array_data['notes'], ); return Database::connect()->insert($query, $paramType, $paramValue); } public function createOrcrPlateWithSMS($array_data) { $query = "INSERT INTO `vehicle_orcr_plate_status` ( `vehicle_id`, `type`, `user_id`, `status`, `sms_response`, `sms_date`, `date_received`, `notes`, `date_added`) VALUES (?,?,?,?,?,?,?,?,NOW()); "; $paramType = "isiissss"; $paramValue = array( $array_data['vehicle_id'], $array_data['type'], $array_data['user_id'], $array_data['status'], $array_data['sms_response'], $array_data['sms_date'], $array_data['date_received'], $array_data['notes'], ); return Database::connect()->insert($query, $paramType, $paramValue); } public function orcrPlateQuery() { return "SELECT %s FROM vehicle_orcr_plate_status vops LEFT OUTER JOIN vehicle v ON vops.vehicle_id = v.id LEFT OUTER JOIN sales s ON v.id = s.vehicle_id LEFT OUTER JOIN sales_consultant scp ON s.sales_person = scp.id LEFT OUTER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id LEFT OUTER JOIN source_company sc ON scd.company_id = sc.id LEFT OUTER JOIN source_dealer sd ON scd.dealer_id = sd.id LEFT OUTER JOIN source_brand sb ON v.brand_id = sb.id LEFT OUTER JOIN source_car_model scm ON v.model_id = scm.id LEFT OUTER JOIN source_car_model_variant scmv ON v.model_variant_description = scmv.id LEFT OUTER JOIN customer c ON v.customer_record_id = c.id LEFT OUTER JOIN customer_contact cc ON c.id = cc.customer_id LEFT OUTER JOIN source_lto_dealer_contacts sldc ON sldc.id = (SELECT id FROM source_lto_dealer_contacts WHERE 1 AND dealer_id = sd.id AND status = 1 AND active = 1 LIMIT 1) WHERE 1 %s /search/ %s /date_added/ %s /date_received/ %s /sms_sttaus/ %s /company filter/ %s /dealer filter/ AND vops.status = 1 /AND vops.user_id = ?/ %s %s "; } public function orcrPlateQueryWS() { return "SELECT %s FROM vehicle v LEFT OUTER JOIN vehicle_orcr_plate_status vops ON v.id = vops.vehicle_id LEFT OUTER JOIN sales s ON v.id = s.vehicle_id LEFT OUTER JOIN sales_consultant scp ON s.sales_person = scp.id LEFT OUTER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id LEFT OUTER JOIN source_company sc ON scd.company_id = sc.id LEFT OUTER JOIN source_dealer sd ON scd.dealer_id = sd.id LEFT OUTER JOIN source_brand sb ON v.brand_id = sb.id LEFT OUTER JOIN source_car_model scm ON v.model_id = scm.id LEFT OUTER JOIN source_car_model_variant scmv ON v.model_variant_description = scmv.id LEFT OUTER JOIN customer c ON v.customer_record_id = c.id LEFT OUTER JOIN customer_contact cc ON c.id = cc.customer_id WHERE 1 %s /search/ %s /date_added/ %s /date_received/ %s /sms_sttaus/ %s /company filter/ %s /dealer filter/ /AND vops.user_id = ?/ GROUP BY v.id %s %s "; } public function getNoSmsOrcrPlateList($array_data) { $limit = ""; $fields = " c.first_name, c.last_name, c.corporation_name, c.type as customer_type, sc.name as company, sd.name as dealer, sb.name as brand, scm.name as model, scmv.name as model_variant, cc.mobile_phone_1, cc.email_1, v.id as vehicle_id, v.conduction_sticker, v.plate_number, v.mv_file, v.chassis_number, v.engine_number, vops.type as vops_type, vops.id as vops_id, vops.date_added, vops.sms_date, vops.date_received, vops.notes, vops.sms_response, sldc.contact_person, sldc.contact1 as contact_phone, sldc.email as contact_email "; $query = sprintf($this->orcrPlateQuery(), $fields, $array_data['search'], $array_data['date_added'], $array_data['date_received'], $array_data['sms_status'], $array_data['company_access'], $array_data['dealer_access'], $array_data['sort'], $limit); return Database::connect()->runBaseQuery($query); } public function getOrcrPlateList($array_data) { $array_data['company_access'] = " AND sc.id IN (" . $array_data['company_access'] . ")"; if ($array_data['dealer_access']) { $array_data['dealer_access'] = " AND sd.id IN (" . $array_data['dealer_access'] . ")"; } $limit = "LIMIT " . $array_data['offset'] . "," . $array_data['limit'] . ""; $fields = " c.first_name, c.last_name, c.corporation_name, c.type, sc.name as company, sc.code as company_code, sd.name as dealer, sd.code as dealer_code, sb.name as brand, scm.name as model, scmv.name as model_variant, cc.mobile_phone_1, cc.email_1, v.conduction_sticker, v.plate_number, v.mv_file, v.chassis_number, v.engine_number, vops.type as vops_type, vops.id as vops_id, vops.date_added, vops.sms_date, vops.pickup_date, vops.date_received, vops.notes, vops.sms_response"; $query = sprintf( $this->orcrPlateQuery(), $fields, $array_data['search'], $array_data['date_added'], $array_data['date_received'], $array_data['sms_status'], $array_data['company_access'], $array_data['dealer_access'], $array_data['sort'], $limit ); $paramType = "s"; $paramValue = array( $array_data['search_keyword'], ); return Database::connect()->runQuery($query, $paramType, $paramValue); } public function getOrcrPlateStatusList($array_data) { $fields = " c.first_name, c.last_name, c.corporation_name, c.type, sc.name as company, sc.code as company_code, sd.name as dealer, sd.code as dealer_code, sb.name as brand, scm.name as model, scmv.name as model_variant, cc.mobile_phone_1, cc.email_1, v.conduction_sticker, v.id as vehicle_id, v.plate_number, v.mv_file, v.chassis_number, v.engine_number, s.asa_sales_person, CONCAT(scp.first_name,' ',scp.last_name) as sales_person, vops.type as vops_type, vops.id as vops_id, vops.date_added, vops.sms_date, vops.date_received, vops.pickup_date, vops.notes, vops.sms_response"; $query = sprintf( $this->orcrPlateQueryWS(), $fields, $array_data['search'], '', '', '', '', '', '', '' ); // echo $query; // exit; $paramType = "ss"; $paramValue = array( $array_data['search_keyword'][0], $array_data['search_keyword'][1], ); return Database::connect()->runQuery($query, $paramType, $paramValue); } public function getLtoDealerContacts($dealer_id) { $query = "SELECT contact_person,contact1 as contact_phone,email as contact_email FROM source_lto_dealer_contacts WHERE 1 AND dealer_id = ? AND active = 1 AND status = 1 LIMIT 1 "; $queryType = "i"; $queryValue = array( $dealer_id, ); return Database::connect()->runQuery($query, $queryType, $queryValue); } public function getOrcrPlateListCount($array_data) { $array_data['company_access'] = " AND sc.id IN (" . $array_data['company_access'] . ")"; if ($array_data['dealer_access']) { $array_data['dealer_access'] = " AND sd.id IN (" . $array_data['dealer_access'] . ")"; } $limit = ""; $fields = " COUNT(1) "; $query = $this->orcrPlateQuery($fields); $query = sprintf($this->orcrPlateQuery(), $fields, $array_data['search'], $array_data['date_added'], $array_data['date_received'], $array_data['sms_status'], $array_data['company_access'], $array_data['dealer_access'], $array_data['sort'], $limit); $paramType = "s"; $paramValue = array( $array_data['search_keyword'], // $array_data['user_id'], ); return Database::connect()->select($query, $paramType, $paramValue); } public function getAllError() { $query = "SELECT s.*,scd.dealer_id,v.conduction_sticker FROM `vehicle_orcr_plate_status` s INNER JOIN vehicle v ON s.`vehicle_id` = v.id INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id where s.`sms_date` is null AND s.`sms_response` != '' "; return Database::connect()->runBaseQuery($query); } public function getPlateStatus($array_data) { $query = "SELECT COUNT(1) FROM vehicle_orcr_plate_status WHERE (type='orcr_plate' OR type='plate') AND vehicle_id = ?"; $paramType = "i"; return Database::connect()->select($query, $paramType, $array_data); } public function getORCRStatus($array_data) { $query = "SELECT COUNT(1) FROM vehicle_orcr_plate_status WHERE (type='orcr_plate' OR type='orcr') AND vehicle_id = ?"; $paramType = "i"; return Database::connect()->select($query, $paramType, $array_data); } }

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