" . $_POST['new_contact_address_1'] . ", " . $_POST['new_contact_address_2'] . ", " . $_POST['new_contact_city'] . ", " . $zone . ", " . $_POST['new_contact_zipcode'] . "";
} else {
$options = "";
}
$contact_name = $_POST['new_contact_firstname'] . " " . $_POST['new_contact_lastname'];
$contact_phone = $_POST['new_contact_phone'];
$contact_fax = $_POST['new_contact_fax'];
$contact_email = $_POST['new_contact_email'];
} else {
$options = "";
$contact_name = "";
$contact_phone = "";
$contact_fax = "";
$contact_email = "";
}
$json = array(
'error' => 0,
'customer_id' => $customer_id,
'contact_information' => "Contact Information for " . $firstname . "
",
'address' => $options,
'contact_name' => $contact_name,
'contact_phone' => $contact_phone,
'contact_fax' => $contact_fax,
'contact_email' => $contact_email
);
echo json_encode($json);
} elseif ($_GET['type'] == "contact") {
if (isset($_GET['address_id']) && $_GET['address_id'] != "") {
$sql = "UPDATE address SET firstname = '" . addslashes($_POST['new_contact_firstname']) . "', lastname = '" . addslashes($_POST['new_contact_lastname']) . "', email = '" . addslashes($_POST['new_contact_email']) . "', telephone = '" . addslashes($_POST['new_contact_phone']) . "', fax = '" . addslashes($_POST['new_contact_fax']) . "', address_1 = '" . addslashes($_POST['new_contact_address_1']) . "', address_2 = '" . addslashes($_POST['new_contact_address_2']) . "', city = '" . addslashes($_POST['new_contact_city']) . "', postcode = '" . addslashes($_POST['new_contact_zipcode']) . "', zone_id = '" . (int)$_POST['new_contact_state'] . "', country_id = '" . (int)$_POST['new_contact_country'] . "' WHERE customer_id = '" . $_GET['dealer_id'] . "' AND address_id = '" . (int)$_GET['address_id'] . "'";
} else {
$check_sql = "SELECT * FROM address WHERE LCASE(firstname) = '" . strtolower($_POST['new_contact_firstname']) . "' AND LCASE(lastname) = '" . strtolower($_POST['new_contact_lastname']) . "' AND customer_id = '" . (int)$_GET['dealer_id'] . "'";
$check_results = @mysql_query($check_sql,$connection) or die(mysql_error());
if (mysql_num_rows($check_results) < 1) {
$sql = "INSERT INTO address SET customer_id = '" . (int)$_GET['dealer_id'] . "', firstname = '" . addslashes($_POST['new_contact_firstname']) . "', lastname = '" . addslashes($_POST['new_contact_lastname']) . "', email = '" . addslashes($_POST['new_contact_email']) . "', telephone = '" . addslashes($_POST['new_contact_phone']) . "', fax = '" . addslashes($_POST['new_contact_fax']) . "', address_1 = '" . addslashes($_POST['new_contact_address_1']) . "', address_2 = '" . addslashes($_POST['new_contact_address_2']) . "', city = '" . addslashes($_POST['new_contact_city']) . "', postcode = '" . addslashes($_POST['new_contact_zipcode']) . "', zone_id = '" . (int)$_POST['new_contact_state'] . "', country_id = '" . (int)$_POST['new_contact_country'] . "'";
} else {
$sql = "UPDATE address SET firstname = '" . addslashes($_POST['new_contact_firstname']) . "', lastname = '" . addslashes($_POST['new_contact_lastname']) . "', email = '" . addslashes($_POST['new_contact_email']) . "', telephone = '" . addslashes($_POST['new_contact_phone']) . "', fax = '" . addslashes($_POST['new_contact_fax']) . "', address_1 = '" . addslashes($_POST['new_contact_address_1']) . "', address_2 = '" . addslashes($_POST['new_contact_address_2']) . "', city = '" . addslashes($_POST['new_contact_city']) . "', postcode = '" . addslashes($_POST['new_contact_zipcode']) . "', zone_id = '" . (int)$_POST['new_contact_state'] . "', country_id = '" . (int)$_POST['new_contact_country'] . "' WHERE customer_id = '" . (int)$_GET['dealer_id'] . "'";
}
}
$results = @mysql_query($sql,$connection) or die(mysql_error());
if (isset($_GET['address_id'])) {
$address_id = $_GET['address_id'];
} else {
$address_id = mysql_insert_id($connection);
}
$options = "";
$sql = "SELECT * FROM address WHERE customer_id = '" . (int)$_GET['dealer_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
$sql2 = "SELECT DISTINCT * FROM zone WHERE zone_id = '" . (int)$row['zone_id'] . "'";
$results2 = @mysql_query($sql2,$connection) or die(mysql_error());
while ($line = mysql_fetch_array($results2, MYSQL_ASSOC)) {
$zone = $line['name'];
}
if ($row['address_id'] == $address_id) {
if ($row['address_2'] != "") {
$options .= "";
} else {
$options .= "";
}
} else {
if ($row['address_2'] != "") {
$options .= "";
} else {
$options .= "";
}
}
}
$json = array(
'error' => 0,
'contact_name' => $_POST['new_contact_firstname'] . " " . $_POST['new_contact_lastname'],
'contact_phone' => $_POST['new_contact_phone'],
'contact_fax' => $_POST['new_contact_fax'],
'contact_email' => $_POST['new_contact_email'],
'address' => $options
);
echo json_encode($json);
} elseif ($_GET['type'] == "edit_contact") {
$json = array();
$sql = "SELECT * FROM address WHERE address_id = '" . (int)$_POST['address_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
$json = array(
'firstname' => $row['firstname'],
'lastname' => $row['lastname'],
'phone' => $row['telephone'],
'fax' => $row['fax'],
'email' => $row['email'],
'address_1' => $row['address_1'],
'address_2' => $row['address_2'],
'city' => $row['city'],
'zone_id' => $row['zone_id'],
'country_id' => $row['country_id'],
'zipcode' => $row['postcode']
);
}
echo json_encode($json);
} elseif ($_GET['type'] == "delete_contact") {
$json = array();
$sql = "DELETE FROM address WHERE address_id = '" . (int)$_POST['address_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$sql = "SELECT * FROM address WHERE customer_id = '" . (int)$_GET['customer_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$options = "";
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
$sql2 = "SELECT DISTINCT * FROM zone WHERE zone_id = '" . (int)$row['zone_id'] . "'";
$results2 = @mysql_query($sql2,$connection) or die(mysql_error());
while ($line = mysql_fetch_array($results2, MYSQL_ASSOC)) {
$zone = $line['name'];
}
if ($row['address_2'] != "") {
$options .= "";
} else {
$options .= "";
}
}
$json = array(
'error' => 0,
'msg' => 'The selected contact was deleted successfully.',
'address' => $options
);
echo json_encode($json);
} elseif ($_GET['type'] == "add_machine") {
$address_sql = "SELECT * FROM address WHERE address_id = '" . (int)$_GET['address_id'] . "'";
$address_results = @mysql_query($address_sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($address_results, MYSQL_ASSOC)) {
$customer = $row['firstname'] . " " . $row['lastname'];
}
$sql = "SELECT * FROM Special_Machines WHERE SANY_SERIAL = '" . $_POST['machine_serial'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
if (mysql_num_rows($results) > 0) {
$error = 1;
$msg = "This machine already exists and cannot be added again!";
$date_reg = "";
$date_serv = "";
} else {
if ($_POST['machine_start'] == "") {
$date_reg = date('Y-m-d H:i:s');
} else {
$date_reg = date('Y-m-d H:i:s', strtotime($_POST['machine_start']));
}
if ($_POST['machine_end'] == "") {
$date_serv = date('Y-m-d H:i:s', strtotime($date_reg . " + 2 years"));
} else {
$date_serv = date('Y-m-d H:i:s', strtotime($_POST['machine_end']));
}
$sql = "INSERT INTO Special_Machines SET Dealer_ID = '" . (int)$_GET['dealer_id'] . "', Customer = '" . addslashes($customer) . "', TYPE = '" . addslashes($_POST['machine_type']) . "', Model = '" . addslashes($_POST['machine_model']) . "', S_N = '" . addslashes($_POST['machine_serial']) . "', SANY_SERIAL = '" . addslashes($_POST['machine_serial']) . "', date_reg = '" . $date_reg . "', date_serv = '" . $date_serv . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$error = 0;
$msg = "Machine has been added!";
}
$json = array(
'error' => $error,
'msg' => $msg,
'start_date' => $date_reg,
'end_date' => $date_serv
);
echo json_encode($json);
} elseif ($_GET['type'] == "save_ticket") {
$json = array();
$address_sql = "SELECT * FROM address WHERE address_id = '" . (int)$_POST['contact_address'] . "'";
$address_results = @mysql_query($address_sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($address_results, MYSQL_ASSOC)) {
$firstname = $row['firstname'];
$lastname = $row['lastname'];
$email = $row['email'];
}
$date = date('Y-m-d H:i:s');
$sql = "INSERT INTO form_comment_text SET status = '1'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$map_id = mysql_insert_id($connection);
if ($_POST['machine_start'] == "") {
$date_serv = date('Y-m-d H:i:s');
} else {
$date_serv = date('Y-m-d H:i:s', strtotime($_POST['machine_start']));
}
if ($_POST['machine_end'] == "") {
$date_end = date('Y-m-d H:i:s', strtotime($date_serv . " + 2 years"));
} else {
$date_end = date('Y-m-d H:i:s', strtotime($_POST['machine_end']));
}
$sql = "INSERT INTO form_comment_text SET map_id = '" . (int)$map_id . "', form_id = '1000', agent_id = '" . $_GET['agent_id'] . "', app_id = '1', customer_id = '" . (int)$_GET['dealer_id'] . "', address_id = '" . (int)$_POST['contact_address'] . "', create_date = '" . $date . "', close_date = '0000-00-00 00:00:00', prob = '" . addslashes($_POST['problem_type']) . "', firstname = '" . addslashes($firstname) . "', lastname = '" . addslashes($lastname) . "', email = '" . addslashes($email) . "', van1 = '" . $map_id . "-1', van3 = '" . addslashes($_POST['comments']) . "', van11 = '" . addslashes($_POST['call_type']) . "', van12 = '" . addslashes($_POST['priority_code']) . "', van13 = '" . addslashes($_POST['assigned_region']) . "', van14 = '" . addslashes($_POST['assigned_person']) . "', van20 = '" . addslashes($_POST['machine_type']) . "', van21 = '" . addslashes($_POST['machine_model']) . "', van22 = '" . addslashes($_POST['machine_serial']) . "', van23 = '" . $date_serv . "', van24 = '" . $date_end . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$error = 0;
$msg = "New ticket has been added.";
$sql = "SELECT * FROM user WHERE user_id = '" . (int)$_GET['agent_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
if (mysql_num_rows($results) > 0) {
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['firstname'] != "") {
$agent_name = $row['firstname'] . " " . $row['lastname'];
} else {
$agent_name = $row['username'];
}
}
}
$sql = "SELECT * FROM form_comment_text WHERE customer_id = '" . (int)$_GET['dealer_id'] . "' AND agent_id = '" . (int)$_GET['agent_id'] . "' ORDER BY create_date DESC limit 0,10";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$ticket_data = "";
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['status'] == 1) {
$status = "Open";
} else {
$status = "Closed";
}
$ticket_data .= "";
$ticket_data .= "| " . $row['form_id'] . "-" . $row['map_id'] . "-" . $row['app_id'] . " | ";
$ticket_data .= "" . date('m/d/Y H:i:s', strtotime($row['create_date'])) . " | ";
$ticket_data .= "" . $agent_name . " | ";
$ticket_data .= "" . $row['prob'] . " | ";
$ticket_data .= "" . $row['van21'] . " | ";
$ticket_data .= "" . $row['van22'] . " | ";
$ticket_data .= "" . $status . " | ";
$ticket_data .= "" . substr($row['van3'], 0, 50) . " | ";
$ticket_data .= " | ";
$ticket_data .= " | ";
$ticket_data .= "
";
}
$json = array(
'error' => $error,
'msg' => $msg,
'ticket_data' => $ticket_data
);
echo json_encode($json);
} elseif ($_GET['type'] == "update_ticket") {
$json = array();
$address_sql = "SELECT * FROM address WHERE address_id = '" . (int)$_POST['contact_address'] . "'";
$address_results = @mysql_query($address_sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($address_results, MYSQL_ASSOC)) {
$firstname = $row['firstname'];
$lastname = $row['lastname'];
$email = $row['email'];
}
$date = date('Y-m-d H:i:s');
$parts = explode("-", $_GET['ticket_id']);
$form_id = $parts[0];
$map_id = $parts[1];
$app_id = $parts[2];
$max_sql = "SELECT MAX(app_id) as app_id FROM form_comment_text WHERE form_id = '" . (int)$form_id . "' AND map_id = '" . (int)$map_id . "' AND customer_id = '" . (int)$_GET['dealer_id'] . "' AND agent_id = '" . (int)$_GET['agent_id'] . "'";
$max_results = @mysql_query($max_sql,$connection) or die(mysql_error());
if (mysql_num_rows($max_results) > 0) {
while ($max_app_id = mysql_fetch_array($max_results, MYSQL_ASSOC)) {
$app_id = $max_app_id['app_id'] + 1;
}
}
if ($_POST['machine_start'] == "") {
$date_serv = date('Y-m-d H:i:s');
} else {
$date_serv = date('Y-m-d H:i:s', strtotime($_POST['machine_start']));
}
if ($_POST['machine_end'] == "") {
$date_end = date('Y-m-d H:i:s', strtotime($date_serv . " + 2 years"));
} else {
$date_end = date('Y-m-d H:i:s', strtotime($_POST['machine_end']));
}
$sql = "UPDATE form_comment_text SET status = '1' WHERE status = '0' AND form_id = '1000' AND map_id = '" . (int)$map_id . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$sql = "INSERT INTO form_comment_text SET map_id = '" . (int)$map_id . "', form_id = '1000', agent_id = '" . $_GET['agent_id'] . "', app_id = '" . $app_id . "', customer_id = '" . (int)$_GET['dealer_id'] . "', address_id = '" . (int)$_POST['contact_address'] . "', create_date = '" . $date . "', close_date = '0000-00-00 00:00:00', prob = '" . addslashes($_POST['problem_type']) . "', firstname = '" . addslashes($firstname) . "', lastname = '" . addslashes($lastname) . "', email = '" . addslashes($email) . "', van1 = '" . $map_id . "-" . $app_id ."', van3 = '" . addslashes($_POST['comments']) . "', van11 = '" . addslashes($_POST['call_type']) . "', van12 = '" . addslashes($_POST['priority_code']) . "', van13 = '" . addslashes($_POST['assigned_region']) . "', van14 = '" . addslashes($_POST['assigned_person']) . "', van20 = '" . addslashes($_POST['machine_type']) . "', van21 = '" . addslashes($_POST['machine_model']) . "', van22 = '" . addslashes($_POST['machine_serial']) . "', van23 = '" . $date_serv . "', van24 = '" . $date_end . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$error = 0;
$msg = "Ticket thread " . $form_id . "-" . $map_id ." has been updated successfully!";
$sql = "SELECT * FROM user WHERE user_id = '" . (int)$_GET['agent_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
if (mysql_num_rows($results) > 0) {
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['firstname'] != "") {
$agent_name = $row['firstname'] . " " . $row['lastname'];
} else {
$agent_name = $row['username'];
}
}
}
$sql = "SELECT * FROM form_comment_text WHERE customer_id = '" . (int)$_GET['dealer_id'] . "' AND agent_id = '" . (int)$_GET['agent_id'] . "' ORDER BY create_date DESC limit 0,10";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$ticket_data = "";
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['status'] == 1) {
$status = "Open";
} else {
$status = "Closed";
}
$ticket_data .= "";
$ticket_data .= "| " . $row['form_id'] . "-" . $row['map_id'] . "-" . $row['app_id'] . " | ";
$ticket_data .= "" . date('m/d/Y H:i:s', strtotime($row['create_date'])) . " | ";
$ticket_data .= "" . $agent_name . " | ";
$ticket_data .= "" . $row['prob'] . " | ";
$ticket_data .= "" . $row['van21'] . " | ";
$ticket_data .= "" . $row['van22'] . " | ";
$ticket_data .= "" . $status . " | ";
$ticket_data .= "" . substr($row['van3'], 0, 50) . " | ";
$ticket_data .= " | ";
$ticket_data .= " | ";
$ticket_data .= "
";
}
$json = array(
'error' => $error,
'msg' => $msg,
'ticket_data' => $ticket_data
);
echo json_encode($json);
} elseif ($_GET['type'] == "get_ticket") {
$parts = explode("-", $_GET['ticket_id']);
$form_id = $parts[0];
$map_id = $parts[1];
$app_id = $parts[2];
$sql = "SELECT * FROM form_comment_text WHERE form_id = '" . (int)$form_id . "' AND map_id = '" . (int)$map_id . "' AND app_id = '" . (int)$app_id . "' AND agent_id = '" . (int)$_GET['agent_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
if (mysql_num_rows($results) > 0) {
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
$status = $row['status'];
$customer_id = $row['customer_id'];
$dealer_sql = "SELECT firstname FROM customer WHERE customer_id = '" . (int)$row['customer_id'] . "'";
$dealer_results = @mysql_query($dealer_sql,$connection) or die(mysql_error());
while ($row2 = mysql_fetch_array($dealer_results, MYSQL_ASSOC)) {
$dealer_name = $row2['firstname'];
}
$address_id = $row['address_id'];
$machine_type = $row['van20'];
$machine_model = $row['van21'];
$machine_serial = $row['van22'];
if ($row['van23'] == "") {
$machine_start = $_POST['machine_start'];
} else {
$machine_start = $row['van23'];
}
if ($row['van24'] == "") {
$machine_end = $_POST['machine_end'];
} else {
$machine_end = $row['van24'];
}
$call_type = $row['van11'];
$priority_code = $row['van12'];
$assigned_region = $row['van13'];
$assigned_person = $row['van14'];
$problem_type = $row['prob'];
$contact_name = $row['firstname'] . " " . $row['lastname'];
$contact_email = $row['email'];
$contact_phone = "";
$contact_fax = "";
$address_sql = "SELECT * FROM address WHERE customer_id = '" . (int)$row['customer_id'] . "'";
$address_results = @mysql_query($address_sql,$connection) or die(mysql_error());
$options = "";
while ($line = mysql_fetch_array($address_results, MYSQL_ASSOC)) {
$sql2 = "SELECT DISTINCT * FROM zone WHERE zone_id = '" . (int)$line['zone_id'] . "'";
$results2 = @mysql_query($sql2,$connection) or die(mysql_error());
while ($line2 = mysql_fetch_array($results2, MYSQL_ASSOC)) {
$zone = $line2['name'];
}
if ($line['address_id'] == $address_id) {
if ($line['address_2'] != "") {
$options .= $options .= "";
} else {
$options .= $options .= "";
}
$contact_phone = $line['telephone'];
$contact_fax = $line['fax'];
} elseif ($line['address_2'] != "") {
$options .= "";
} else {
$options .= "";
}
}
$json = array(
'error' => 0,
'status' => $status,
'ticket_id' => $_GET['ticket_id'],
'customer_id' => $customer_id,
'address_id' => $address_id,
'machine_type' => $machine_type,
'machine_model' => $machine_model,
'machine_serial' => $machine_serial,
'machine_start' => $machine_start,
'machine_end' => $machine_end,
'call_type' => $call_type,
'priority_code' => $priority_code,
'assigned_region' => $assigned_region,
'assigned_person' => $assigned_person,
'problem_type' => $problem_type,
'contact_name' => $contact_name,
'contact_email' => $contact_email,
'contact_phone' => $contact_phone,
'contact_fax' => $contact_fax,
'address' => $options,
'contact_information' => "Contact Information for " . $dealer_name . "
",
);
}
} else {
$json = array(
'error' => 1
);
}
echo json_encode($json);
} elseif ($_GET['type'] == "close_ticket") {
$json = array();
$parts = explode("-", $_GET['ticket_id']);
$form_id = $parts[0];
$map_id = $parts[1];
$app_id = $parts[2];
$sql = "UPDATE form_comment_text SET status = '0' WHERE form_id = '" . (int)$form_id . "' AND map_id = '" . (int)$map_id . "' AND agent_id = '" . (int)$_GET['agent_id'] . "' AND customer_id = '" . (int)$_GET['dealer_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$sql = "SELECT * FROM user WHERE user_id = '" . (int)$_GET['agent_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
if (mysql_num_rows($results) > 0) {
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['firstname'] != "") {
$agent_name = $row['firstname'] . " " . $row['lastname'];
} else {
$agent_name = $row['username'];
}
}
}
$sql = "SELECT * FROM form_comment_text WHERE customer_id = '" . (int)$_GET['dealer_id'] . "' AND agent_id = '" . (int)$_GET['agent_id'] . "' ORDER BY create_date DESC limit 0,10";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$ticket_data = "";
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['status'] == 1) {
$status = "Open";
} else {
$status = "Closed";
}
$ticket_data .= "";
$ticket_data .= "| " . $row['form_id'] . "-" . $row['map_id'] . "-" . $row['app_id'] . " | ";
$ticket_data .= "" . date('m/d/Y H:i:s', strtotime($row['create_date'])) . " | ";
$ticket_data .= "" . $agent_name . " | ";
$ticket_data .= "" . $row['prob'] . " | ";
$ticket_data .= "" . $row['van21'] . " | ";
$ticket_data .= "" . $row['van22'] . " | ";
$ticket_data .= "" . $status . " | ";
$ticket_data .= "" . substr($row['van3'], 0, 50) . " | ";
$ticket_data .= " | ";
$ticket_data .= " | ";
$ticket_data .= "
";
}
$json = array(
'msg' => "Ticket thread " . $form_id . "-" . $map_id . " has been closed!",
'ticket_data' => $ticket_data
);
echo json_encode($json);
} elseif ($_GET['type'] == "all_open") {
$json = array();
$sql = "SELECT * FROM user WHERE user_id = '" . (int)$_GET['agent_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
if (mysql_num_rows($results) > 0) {
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['firstname'] != "") {
$agent_name = $row['firstname'] . " " . $row['lastname'];
} else {
$agent_name = $row['username'];
}
}
}
if ($_GET['customer_id'] != "") {
$sql = "SELECT * FROM form_comment_text WHERE agent_id = '" . $_GET['agent_id'] . "' AND customer_id = '" . (int)$_GET['customer_id'] . "' AND status = '1' ORDER BY create_date DESC";
} else {
$sql = "SELECT * FROM form_comment_text WHERE agent_id = '" . $_GET['agent_id'] . "' AND status = '1' ORDER BY create_date DESC";
}
$results = @mysql_query($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['status'] == 1) {
$status = "Open";
} else {
$status = "Closed";
}
$ticket_data .= "";
$ticket_data .= "| " . $row['form_id'] . "-" . $row['map_id'] . "-" . $row['app_id'] . " | ";
$ticket_data .= "" . date('m/d/Y H:i:s', strtotime($row['create_date'])) . " | ";
$ticket_data .= "" . $agent_name . " | ";
$ticket_data .= "" . $row['prob'] . " | ";
$ticket_data .= "" . $row['van21'] . " | ";
$ticket_data .= "" . $row['van22'] . " | ";
$ticket_data .= "" . $status . " | ";
$ticket_data .= "" . substr($row['van3'], 0, 50) . " | ";
$ticket_data .= " | ";
$ticket_data .= " | ";
$ticket_data .= "
";
}
$json = array(
'error' => 0,
'ticket_data' => $ticket_data
);
echo json_encode($json);
} elseif ($_GET['type'] == "all_closed") {
$json = array();
$sql = "SELECT * FROM user WHERE user_id = '" . (int)$_GET['agent_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
if (mysql_num_rows($results) > 0) {
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['firstname'] != "") {
$agent_name = $row['firstname'] . " " . $row['lastname'];
} else {
$agent_name = $row['username'];
}
}
}
if ($_GET['customer_id'] != "") {
$sql = "SELECT * FROM form_comment_text WHERE agent_id = '" . $_GET['agent_id'] . "' AND customer_id = '" . (int)$_GET['customer_id'] . "' AND status != '1' ORDER BY close_date DESC";
} else {
$sql = "SELECT * FROM form_comment_text WHERE agent_id = '" . $_GET['agent_id'] . "' AND status != '1' ORDER BY close_date DESC";
}
$results = @mysql_query($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($row['status'] == 1) {
$status = "Open";
} else {
$status = "Closed";
}
$ticket_data .= "";
$ticket_data .= "| " . $row['form_id'] . "-" . $row['map_id'] . "-" . $row['app_id'] . " | ";
$ticket_data .= "" . date('m/d/Y H:i:s', strtotime($row['create_date'])) . " | ";
$ticket_data .= "" . $agent_name . " | ";
$ticket_data .= "" . $row['prob'] . " | ";
$ticket_data .= "" . $row['van21'] . " | ";
$ticket_data .= "" . $row['van22'] . " | ";
$ticket_data .= "" . $status . " | ";
$ticket_data .= "" . substr($row['van3'], 0, 50) . " | ";
$ticket_data .= " | ";
$ticket_data .= " | ";
$ticket_data .= "
";
}
$json = array(
'error' => 0,
'ticket_data' => $ticket_data
);
echo json_encode($json);
} elseif ($_GET['type'] == "get_zones") {
$options = "";
$sql = "SELECT * FROM zone WHERE country_id = '" . (int)$_GET['country_id'] . "'";
$results = @mysql_query($sql,$connection) or die(mysql_error());
$options .= "";
while ($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
$options .= "";
}
echo json_encode($options);
}
?>