$w = 0; } else { $sof = '6 Months'; $w = 6; } } else { $sof = 'None'; $w = 0; } $content .= "<tr>\n\t\t\t\t\t\t\t\t<td>Ticket #" . $b[1] . "</td>\n\t\t\t\t\t\t\t <td style='width:60px;'><center>{$phy}</center></td>\n\t\t\t\t\t\t\t\t<td style='width:60px;'><center>{$sof}</center></td>\n\t\t\t\t\t\t\t\t<td>\$" . $split[1] . "</td>\n\t\t\t\t\t\t\t</tr>"; $nontaxable = $nontaxable + $split[1]; MYSQL::QUERY("INSERT INTO core_tickets_processed (t_id, t_customer, t_manufacturer, t_model, t_imei, t_password, t_phy, t_liq, t_sof, t_created_by, t_store, t_session, t_created, t_estimate_created, t_estimate_price, t_estimate_items, t_estimate_time, t_repair_created, t_repair_price, t_repair_items, t_repair_time) SELECT * FROM core_tickets_checkout WHERE t_id = ? LIMIT 1", array($b[1])); MYSQL::QUERY("UPDATE core_tickets_processed SET t_warranty=?, t_checkout_created=?, t_checkout_price=?, t_checkout_time=? WHERE t_id = ? LIMIT 1", array($w, Date("Y-m-d H:i:s"), $split[1], $time, $b[1])); MYSQL::QUERY("UPDATE core_tickets_status SET t_status = ? WHERE t_id = ? LIMIT 1", array(4, $b[1])); MYSQL::QUERY("DELETE FROM core_tickets_checkout WHERE t_id = ? LIMIT 1", array($b[1])); USER::NOTE($b[1], "Processed This Ticket [ " . $split[1] . " ] [ {$time} ]", 2); } else { if ($b[0] == "ac") { $taxable = $taxable + $split[1]; $ITEM = MYSQL::QUERY('SELECT * FROM device_accessories WHERE a_id = ? LIMIT 1', array($b[1])); $content .= "<tr>\n\t\t\t\t\t\t\t\t<td>" . $ITEM['a_name'] . "</td>\n\t\t\t\t\t\t\t <td style='width:60px;'></td>\n\t\t\t\t\t\t\t\t<td style='width:60px;'></td>\n\t\t\t\t\t\t\t\t<td>\$" . $split[1] . "</td>\n\t\t\t\t\t\t\t</tr>"; } else { if ($b[0] == "de") { $taxable = $taxable + $split[1]; $DEVICE = MYSQL::QUERY('SELECT * FROM core_refurb_devices WHERE d_id = ? LIMIT 1', array($b[1])); $MODEL = MYSQL::QUERY('SELECT m_name FROM device_models WHERE m_id = ? LIMIT 1', array($DEVICE['d_model_id'])); $content .= "<tr>\n\t\t\t\t\t\t\t <td>" . $MODEL['m_name'] . "</td>\n\t\t\t\t\t\t\t\t<td style='width:60px;'>6 Month</td>\n\t\t\t\t\t\t\t\t<td style='width:60px;'>None</td>\n\t\t\t\t\t\t\t\t<td>\$" . $split[1] . "</td>\n\t\t\t\t\t\t\t</tr>"; MYSQL::QUERY("UPDATE core_refurb_devices SET d_sold = ? WHERE d_id = ? LIMIT 1", array($T['c_id'] . "|" . $split[1], $b[1])); } } }
switch ($TICKET['t_status']) { case 97: $TBL = 'core_tickets_estimate'; $ST = 1; break; case 98: $TBL = 'core_tickets_repair'; $ST = 2; break; case 99: $TBL = 'core_tickets_checkout'; $ST = 3; break; } $ROWS = MYSQL::QUERY("SHOW COLUMNS FROM {$TBL}"); $QUERY = "INSERT INTO {$TBL} SELECT "; $I = 0; foreach ($ROWS as $R) { if ($I == 0) { $QUERY .= $R['Field']; } else { $QUERY .= "," . $R['Field']; } $I++; } $QUERY .= " FROM core_tickets_walkout WHERE t_id = ? LIMIT 1"; MYSQL::QUERY($QUERY, array($TID)); MYSQL::QUERY("DELETE FROM core_tickets_walkout WHERE t_id = ? LIMIT 1", array($TID)); MYSQL::QUERY("UPDATE core_tickets_status SET t_status = ? WHERE t_id = ? LIMIT 1", array($ST, $TID)); USER::NOTE($TID, "Ticket Re-Opened", 2);
require "../../../frame/engine.php"; ENGINE::START(); $user = USER::VERIFY(0, TRUE); $tid = $_GET['tid']; $note = $_GET['note']; $Ticket = MYSQL::QUERY("SELECT * FROM core_tickets_status WHERE t_id = ? LIMIT 1", array($tid)); if ($Ticket['t_status'] == 1) { MYSQL::QUERY("INSERT INTO core_tickets_walkout (t_id, t_customer, t_manufacturer, t_model, t_imei, t_password, t_phy, t_liq, t_sof, t_created_by, t_store, t_session, t_created) SELECT * FROM core_tickets_estimate WHERE t_id = ? LIMIT 1", array($tid)); MYSQL::QUERY("UPDATE core_tickets_status SET t_status = 97 WHERE t_id = ? LIMIT 1", array($tid)); MYSQL::QUERY("DELETE FROM core_tickets_estimate WHERE t_id = ? LIMIT 1", array($tid)); } else { if ($Ticket['t_status'] == 2) { MYSQL::QUERY("INSERT INTO core_tickets_walkout (t_id, t_customer, t_manufacturer, t_model, t_imei, t_password, t_phy, t_liq, t_sof, t_created_by, t_store, t_session, t_created, t_estimate_created, t_estimate_price, t_estimate_items, t_estimate_time) SELECT * FROM core_tickets_repair WHERE t_id = ? LIMIT 1", array($tid)); MYSQL::QUERY("UPDATE core_tickets_status SET t_status = 98 WHERE t_id = ? LIMIT 1", array($tid)); MYSQL::QUERY("DELETE FROM core_tickets_repair WHERE t_id = ? LIMIT 1", array($tid)); } else { if ($Ticket['t_status'] == 3) { MYSQL::QUERY("INSERT INTO core_tickets_walkout (t_id, t_customer, t_manufacturer, t_model, t_imei, t_password, t_phy, t_liq, t_sof, t_created_by, t_store, t_session, t_created, t_estimate_created, t_estimate_price, t_estimate_items, t_estimate_time, t_repair_created, t_repair_price, t_repair_items, t_repair_time) SELECT * FROM core_tickets_checkout WHERE t_id = ? LIMIT 1", array($tid)); MYSQL::QUERY("UPDATE core_tickets_status SET t_status = 99 WHERE t_id = ? LIMIT 1", array($tid)); MYSQL::QUERY("DELETE FROM core_tickets_checkout WHERE t_id = ? LIMIT 1", array($tid)); } } } if (!$note == '') { USER::NOTE($tid, "Walkedout Ticket [{$note}]", 2); } else { USER::NOTE($tid, "Walked this ticket out", 2); } TRACKING::WALKOUTS($user); echo "Ticket Walked Out";
<?php require "../../../frame/engine.php"; ENGINE::START(); $user = USER::VERIFY(0, TRUE); $price = $_POST['price']; unset($_POST['price']); $time = $_POST['time']; unset($_POST['time']); $items = $_POST['items']; unset($_POST['items']); $ticket = $_POST['ticket']; unset($_POST['ticket']); $Main = MYSQL::QUERY("SELECT * FROM core_tickets_status WHERE t_id = ? LIMIT 1", array($ticket)); if ($Main['t_status'] == 1) { $status = array(2); foreach ($_POST as $k => $v) { $key1 = "t_" . str_replace($ticket, "", $k); $key2 = explode(".", $Main[$key1]); $key3 = $v . "." . $key2[1]; array_push($status, $key3); } array_push($status, $ticket); MYSQL::QUERY("INSERT INTO core_tickets_repair (t_id, t_customer, t_manufacturer, t_model, t_imei, t_password, t_phy, t_liq, t_sof, t_created_by, t_store, t_session, t_created) SELECT * FROM core_tickets_estimate WHERE t_id = ? LIMIT 1", array($ticket)); MYSQL::QUERY("UPDATE core_tickets_repair SET t_estimate_created = ?, t_estimate_price = ?, t_estimate_items = ?, t_estimate_time = ? WHERE t_id = ? LIMIT 1", array(Date("Y-m-d H:i:s"), $price, $items, $time, $ticket)); MYSQL::QUERY("UPDATE core_tickets_status SET t_status = ?,t_simcard = ?,t_sdcard = ?,t_case = ?,t_charger = ?,t_power = ?,t_buttons = ?,t_inaudio = ?,t_exaudio = ?,t_touch = ?,t_housing = ?,t_charging = ?,t_service = ? WHERE t_id = ? LIMIT 1", $status); MYSQL::QUERY("DELETE FROM core_tickets_estimate WHERE t_id = ? LIMIT 1", array($ticket)); USER::NOTE($ticket, "Ticket Estimated [ {$price} ] [ {$time} ]", 2); USER::STAT('estimates'); USER::MEDAL('bronze', 1); }
<?php require "../../frame/engine.php"; ENGINE::START(); $USER = USER::VERIFY(0, TRUE); $CODE = $_GET['tid']; $TICKET = ENGINE::TICKETINFO($CODE); if (!isset($_GET['from'])) { USER::NOTE($_GET['tid'], "(" . $USER['username'] . ") Loaded this Ticket", 1, 4); } $CO = "DISABLED"; $RT = "DISABLED"; $ET = "DISABLED"; $AE = "DISABLED"; $WT = 'OnClick="Walkout(' . "'" . $CODE . "'" . ')"'; $LC = "DISABLED"; $WTA = 'Walkout Ticket'; $BUTTONS = array('B1' => 'Load Customer', 'B1_F' => 'onClick="LoadCustomer(' . "'" . $TICKET['CUST']['c_id'] . "'" . ')"', 'B2' => 'Load Corporation', 'B2_F' => 'DISABLED', 'B3' => 'Walkout Ticket', 'B3_F' => 'OnClick="Walkout(' . "'" . $CODE . "'" . ')"', 'B4' => 'Estimate Ticket', 'B4_F' => 'onClick="Estimate(' . "'" . $CODE . "'" . ', ' . $TICKET['INFO']['t_model'] . ', ' . $TICKET['MODE']['m_type'] . ', ' . "'" . $TICKET['MODE']['m_date'] . "'" . ')"', 'B5' => 'Print Check-In', 'B5_F' => 'onClick="PrintCheckIn(' . "'" . $CODE . "'" . ')"', 'B6' => 'Load Device info', 'B6_F' => 'DISABLED', 'B7' => 'Change Device', 'B7_F' => 'onClick="ChangeDevice(' . "'" . $CODE . "'" . ')"'); switch ($TICKET['STATUS']['t_status']) { case 1: $BUTTONS['B4'] = 'Estimate Ticket'; $BUTTONS['B4_F'] = 'onClick="Estimate(' . "'" . $CODE . "'" . ', ' . $TICKET['INFO']['t_model'] . ', ' . $TICKET['MODE']['m_type'] . ', ' . "'" . $TICKET['MODE']['m_date'] . "'" . ')"'; break; case 2: if ($TICKET['STATUS']['t_reserved'] == 0) { $BUTTONS['B4'] = 'Accept Estimate'; $BUTTONS['B4_F'] = 'onClick="AcceptEstimate(' . "'" . $CODE . "'" . ', ' . $TICKET['INFO']['t_model'] . ', ' . $TICKET['MODE']['m_type'] . ', ' . "'" . $TICKET['MODE']['m_date'] . "'" . ')"'; } else { if ($TICKET['STATUS']['t_reserved'] == 1) { $BUTTONS['B4'] = 'Repair Device'; $BUTTONS['B4_F'] = 'onClick="Repair(' . "'" . $CODE . "'" . ', ' . $TICKET['INFO']['t_model'] . ', ' . $TICKET['MODE']['m_type'] . ', ' . "'" . $TICKET['MODE']['m_date'] . "'" . ')"';
$v = explode("-", $v); if ($v[0] == "it") { MYSQL::QUERY("UPDATE inventory_stock SET quantity = quantity + 1 WHERE store = ? AND item = ? LIMIT 1", array($user['store'], $v[1])); } } foreach ($added as $k => $v) { $v = explode("-", $v); if ($v[0] == "it") { MYSQL::QUERY("UPDATE inventory_stock SET quantity = quantity - 1 WHERE store = ? AND item = ? LIMIT 1", array($user['store'], $v[1])); } } $status = array(3); foreach ($_POST as $k => $v) { $key1 = "t_" . str_replace($ticket, "", $k); $key2 = explode(".", $Main[$key1]); $key3 = $key2[0] . "." . $v; array_push($status, $key3); } $reward = round($price / 50); array_push($status, $ticket); MYSQL::QUERY("INSERT INTO core_tickets_checkout (t_id, t_customer, t_manufacturer, t_model, t_imei, t_password, t_phy, t_liq, t_sof, t_created_by, t_store, t_session, t_created, t_estimate_created, t_estimate_price, t_estimate_items, t_estimate_time) SELECT * FROM core_tickets_repair WHERE t_id = ? LIMIT 1", array($ticket)); MYSQL::QUERY("UPDATE core_tickets_checkout SET t_repair_created = ?, t_repair_price = ?, t_repair_items = ?, t_repair_time = ? WHERE t_id = ?", array(Date("Y-m-d H:i:s"), $price, $items, $time, $ticket)); MYSQL::QUERY("UPDATE core_tickets_status SET t_status = ?,t_order = 0,t_simcard = ?,t_sdcard = ?,t_case = ?,t_charger = ?,t_power = ?,t_buttons = ?,t_inaudio = ?,t_exaudio = ?,t_touch = ?,t_housing = ?,t_charging = ?,t_service = ? WHERE t_id = ? LIMIT 1", $status); MYSQL::QUERY("DELETE FROM core_tickets_repair WHERE t_id = ? LIMIT 1", array($ticket)); MYSQL::QUERY('INSERT INTO core_tickets_note (t_id, t_note, t_note_by, t_date) VALUES (?, ?, ?, ?)', array($ticket, "Device Repaired [{$time}]", $user['user_id'], Date("Y-m-d H:i:s"))); TRACKING::REPAIRS($itemsnew, $user); USER::NOTE($ticket, "Device Repaired [ {$price} ] [ {$time} ]", 2); USER::STAT('repairs'); USER::MEDAL('bronze', $reward); ?>