$transaction_query = "INSERT INTO `transaction` (`tr_type`, `tr_desc`, `tr_date`, `tr_user_id`) VALUES ('DELETE', 'vehicle_modification-{$moddi_id}', '{$today}', '{$_SESSION['user_id']}')";
mysql_query("START TRANSACTION");
$delete = mysql_query($delete_query);
$transaction = mysql_query($transaction_query);
if ($delete && $transaction) {
mysql_query('COMMIT');
echo json_encode(array(array("msgType" => 1, "msg" => "Successfully Deleted.")));
} else {
mysql_query('ROLLBACK');
echo json_encode(array(array("msgType" => 2, "msg" => "Cannot Be Deleted.")));
}
MainConfig::closeDB();
} else {
if ($_POST['action'] == 'get_photo_count') {
$vh_id = $_POST['vh_id'];
$system->prepareSelectQueryForJSONSingleData("SELECT COUNT(vehicle_photo.ph_id) AS ph_count\nFROM vehicle INNER JOIN vehicle_photo ON vehicle_photo.vh_id = vehicle.vh_id\nWHERE vehicle_photo.vh_id = '{$vh_id}'");
} else {
if ($_POST['action'] == 'add_temp_entry') {
$data = $_POST['vh_data'];
mysql_query("START TRANSACTION");
// delete
mysql_query("DELETE FROM proforma_inv WHERE proforma_inv.pi_date < CURRENT_DATE () AND proforma_inv.pi_status = '98'");
mysql_query("INSERT INTO `proforma_inv` ( `pi_date`, `cus_id`, `pi_status` ) VALUES (CURRENT_DATE(), 0, '98');");
$ref_id = mysql_insert_id();
// echo $ref_id;
if (!empty($data) && $ref_id > 0) {
foreach ($data as $key => $value) {
$price_res = mysql_query("SELECT IF(vehicle.auc_display_price=0,vehicle.auc_real_price,vehicle.auc_display_price) AS vh_price\n FROM vehicle\n WHERE vehicle.vh_id = '{$value}'");
$vh_price = mysql_fetch_assoc($price_res);
// $ins = mysql_query("INSERT INTO `temp_entries` (`temp_id`, `sel_id`) VALUES ({$ref_id},'{$value}');") or die(mysql_error());
$ins = mysql_query("INSERT INTO `pi_entries` (`pi_id`, `vh_id`) VALUES ({$ref_id},'{$value}');") or die(mysql_error());
