mostrarusuarios();
break;
case "clientes":
mostrarclientes();
break;
case "viewcat":
vercatalogo();
break;
case "editcat":
editarcatalogo();
break;
case "rst":
resetpwd();
break;
case "del":
deleterec();
break;
default:
select();
break;
}
function select()
{
include "conf.php";
include "include/mysql.class.php";
$id = $_SESSION['usr_id'];
?>
<title>Perfil de Usuario</title>
<h1>Perfil de Usuario</h1>
<a href="index.php">Regresar</a>-<a href="usuarios.php?a=perfil">Cambiar Perfil</a>-<a href="usuarios.php?a=pass">Cambiar Contraseña</a>
case "delete":
sql_delete();
break;
}
switch ($a) {
case "add":
addrec();
break;
case "view":
viewrec($recid);
break;
case "edit":
editrec($recid);
break;
case "del":
deleterec($recid);
break;
default:
select();
break;
}
if (isset($order)) {
$_SESSION["order"] = $order;
}
if (isset($ordtype)) {
$_SESSION["type"] = $ordtype;
}
if (isset($filter)) {
$_SESSION["filter"] = $filter;
}
if (isset($filterfield)) {
function convert2Failure()
{
$complaintNumber = $_GET["complaintNumber"];
$fields = "date_time,dealer_code,location_id,emp_code,cust_name,cust_address,cust_email,cust_mobile,model,veh_reg_no,frame_vin_no,engine_no,date_of_sale,km_reading,warranty,paid,photo_url,status";
$table1 = "complaint";
$table2 = "failure";
$rows = singlerec($fields, $table1, "complaint_no=" . $complaintNumber);
$row = mysql_fetch_row($rows);
$value = "'" . $row[0] . "'," . $row[1] . "," . $row[2] . ",'" . $row[3] . "','" . $row[4] . "','" . $row[5] . "','" . $row[6] . "'," . $row[7] . ",'" . $row[8] . "','" . $row[9] . "','" . $row[10] . "','" . $row[11] . "','" . $row[12] . "','" . $row[13] . "'," . $row[14] . "," . $row[15] . ",'" . $row[16] . "'," . $row[17];
if (insertrec($table2, $fields, $value)) {
$failureID = mysql_insert_id();
//Move actions data
//echo $failureID;
$newField = "cat_id,customer_voice_id";
$rows = selectrec($newField, "complaint_details", "complaint_no=" . $complaintNumber);
$newField1 = "cat_id,customer_voice_id,failure_id";
foreach ($rows as $row) {
$value = $row[0] . "," . $row[1] . "," . $failureID;
insertrec("failure_details", $newField1, $value);
}
deleterec("complaint_details", "complaint_no", $complaintNumber, "delete");
//move actions others data
$newField = "cat_id,customer_voice_others";
$rows = selectrec($newField, "complaint_details_others", "complaint_no=" . $complaintNumber);
$newField1 = "cat_id,customer_voice_others,failure_id";
foreach ($rows as $row) {
$value = $row[0] . ",'" . $row[1] . "'," . $failureID;
insertrec("failure_details_others", $newField1, $value);
}
deleterec("complaint_details_others", "complaint_no", $complaintNumber, "delete");
//move actions taken data
$newField = "com_action,com_responsibility";
$rows = selectrec($newField, "complaint_actions_taken", "complaint_no=" . $complaintNumber);
$newField1 = "action,failure_id";
foreach ($rows as $row) {
$value = "'" . $row[0] . "-" . $row[1] . "'," . $failureID;
insertrec("failure_actions_taken", $newField1, $value);
}
deleterec("complaint_actions_taken", "complaint_no", $complaintNumber, "delete");
//move Pictures
$newField = "picture_url";
$rows = selectrec($newField, "complaint_pictures", "complaint_no=" . $complaintNumber);
$newField1 = "picture_url,failure_id";
foreach ($rows as $row) {
$value = "'" . $row[0] . "'," . $failureID;
insertrec("failure_pictures", $newField1, $value);
$fileURL = "http://gladminds.co/bajaj/fcr_mobile/be/";
$fromURL = "pics_upload/complaint/" . $complaintNumber . "/";
$toURL = "pics_upload/failure/" . $failureID . "/";
if (file_exists($fromURL . $row[0])) {
$folderPath = "pics_upload/failure/" . $failureID;
if (!file_exists($folderPath)) {
mkdir($folderPath, 0777, true);
}
$file = $fromURL . $row[0];
$newfile = $toURL . $row[0];
if (!copy($file, $newfile)) {
} else {
//Remove the complaint file after copying
//rmdir($fromURL.$row[0]);
}
}
# if (!file_exists($toURL)) {
# mkdir($toURL, 0777, true);
# }
#
# echo "FailureID -->"."'".$toURL.$row[0]."'";
#
# if(file_exists($fromURL.$row[0])){
# $file = $fromURL.$row[0];
# $newfile = $toURL.$row[0];
# copy($file, $newfile);
# }
}
//Remove the Complaint Folder finally.
if (file_exists($fromURL)) {
rrmdir($fromURL);
}
deleterec("complaint_pictures", "complaint_no", $complaintNumber, "delete");
$arr = array('status' => 1, 'message' => 'Success');
deleterec($table1, "complaint_no", $complaintNumber, "delete");
} else {
$arr = array('status' => 0, 'message' => 'Failure');
}
echo json_encode($arr);
}
