echo "Error getting client details for {$client_name}";
exit;
}
// Insert new Client
if ($client_row[0]['NROWS'] == 0) {
$resp = db_client_insert($client_name, 'no_image.jpg', '', '');
if ($resp['STATUS'] != 'OK') {
echo "Error inserting client for {$client_name}";
exit;
}
$client_id = $resp['INSERT_ID'];
} else {
$client_id = $client_row[0]['client_id'];
}
// Check if the vehicle is already available
$vehicle_row = db_vehicle_select("", $reg_no);
if ($vehicle_row[0]['STATUS'] != 'OK') {
echo "Error getting client details for {$client_name}";
exit;
}
if ($vehicle_row[0]['NROWS'] > 0) {
echo "{$reg_no} already present. Continue... \n";
continue;
exit;
}
// Inert the vehicle details
$resp = db_vehicle_insert($reg_no, 0, $vehicle_model, "PERMANENT", $sticker_no, "DUMMYRCNO-{$reg_no}", "2099-12-31", "", "", "", "", "", "", "", "", "", "", "", "", "", "", $client_id, "", 1);
if ($resp['STATUS'] != 'OK') {
echo "Error inserting vehicle for {$reg_no}";
echo print_arr($resp);
continue;
echo "Error getting client details for {$client_name}";
exit;
}
// Insert new Client
if ($client_row[0]['NROWS'] == 0) {
$resp = db_client_insert($client_name, 'no_image.jpg', '', '');
if ($resp['STATUS'] != 'OK') {
echo "Error inserting client for {$client_name}";
exit;
}
$client_id = $resp['INSERT_ID'];
} else {
$client_id = $client_row[0]['client_id'];
}
// Check whether vehicle already present
$vehicle_row = db_vehicle_select('', $reg_no);
if ($vehicle_row[0]['STATUS'] != 'OK') {
echo "Error selecting client for {$reg_no}";
exit;
}
if ($vehicle_row[0]['NROWS'] > 0) {
db_transaction_end();
continue;
}
// Inert the vehicle details
$resp = db_vehicle_insert($reg_no, 0, $vehicle_model, "CONTRACT", $sticker_no, "DUMMYRCNO-{$reg_no}", "2099-12-31", "", "", "", "", "", "", "", "", "", "", "", "", "", "", $client_id, "", 1);
if ($resp['STATUS'] != 'OK') {
echo "Error inserting vehicle for {$reg_no}";
exit;
}
$upload_count++;
