File manager - Edit - /home/autoph/public_html/connectv1/app/table/customer_individual_service.php
Back
<?php //include('../../cfg/db.php') $id = $_GET['id']; //$esc_id = $db->escape($id); $table = <<<EOT (SELECT s.customer_id, s.plate_number, s.serial_number, s.ro_number, s.mileage, s.recommendation, s.customer_paid_amount, s.insurance_paid_account, s.conduction_sticker, s.start_date_of_service, s.end_date_of_service, s.service_advisor, s.problem_cause, s.correction, s.job_summary, sc.name AS company, sd.name AS dealer, sdms.name AS dms, s.id FROM service s INNER JOIN source_company_dealer scd ON s.company_dealer_id = scd.id INNER JOIN source_company sc ON sc.id=scd.company_id INNER JOIN source_dealer sd ON sd.id=scd.dealer_id INNER JOIN source_dms sdms ON s.dms_id=sdms.id WHERE (s.status=1 AND s.customer_id='$id') ) temp EOT; $primaryKey = 'customer_id'; $columns = array( array( 'db' => 'customer_id', 'dt' => 0 ), array( 'db' => 'plate_number', 'dt' => 1 ), array( 'db' => 'serial_number', 'dt' => 2 ), array( 'db' => 'ro_number', 'dt' => 3 ), array( 'db' => 'mileage', 'dt' => 4 ), array( 'db' => 'recommendation', 'dt' => 5 ), array( 'db' => 'customer_paid_amount', 'dt' => 6 ), array( 'db' => 'insurance_paid_account', 'dt' => 7 ), array( 'db' => 'conduction_sticker', 'dt' => 8 ), array( 'db' => 'start_date_of_service', 'dt' => 9 ), array( 'db' => 'end_date_of_service', 'dt' => 10 ), array( 'db' => 'service_advisor', 'dt' => 11 ), array( 'db' => 'problem_cause', 'dt' => 12 ), array( 'db' => 'correction', 'dt' => 13 ), array( 'db' => 'job_summary', 'dt' => 14 ), array( 'db' => 'company', 'dt' => 15 ), array( 'db' => 'dealer', 'dt' => 16 ), array( 'db' => 'dms', 'dt' => 17 ), array( 'db' => 'id', 'dt' => 18 ), ); // SQL server connection information $config = parse_ini_file('../../cfg/cfg.ini'); $sql_details = array( 'user' => $config['username'], 'pass' => $config['password'], 'db' => $config['database'], 'host' => $config['host'] ); /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * If you just want to use the basic configuration for DataTables with PHP * server-side, there is no need to edit below this line. */ require( 'ssp.class.php' ); echo json_encode( SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns ) );
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings