require "lib/mssql_crud.php";
$db = new Database();
$db->connect();
$data = json_decode($_POST['valueHolder']);
$x = 0;
$q = "";
if ($_POST['service'] == 1) {
//STORE VISIT
$q = "delete from feedback_response where clientid=" . $_POST['client'] . " and refid='FB002'";
}
if ($_POST['service'] == 2) {
//CONSULTATION VISIT
$q = "delete from feedback_response where clientid=" . $_POST['client'] . " and refid='FB003'";
}
if ($_POST['service'] == 3) {
//CONSULTATION VISIT
$q = "delete from feedback_response where clientid=" . $_POST['client'] . " and (refid='FB001' or refid='FB004' or refid='FB005')";
}
if ($q != '') {
$db->insertNonQuery($q);
}
for ($x = 0; $x < sizeof($data->data->{feedback}); $x++) {
$q = "insert into feedback_response (clientid, fb_id, refid, reftitle, feedback_desc, fb_value) values (";
$q .= $_POST['client'] . "," . $data->data->{id}[$x] . ",'" . $data->data->{refid}[$x];
$q .= "','" . $data->data->{reftitle}[$x] . "','" . $data->data->{feedback}[$x];
$q .= "'," . $data->data->{value}[$x] . ");";
$db->insertNonQuery($q);
}
$db->disconnect();
//$g = ($_POST['service']=='store'?1:($_POST['service']=='consultation'?2:3));
header('Location: thankyou.php?q=' . $_POST['service'] . "," . $_POST['client']);
