$time = $_POST['checkouttime'];
if ($pm2cost <= 0.0 || $pm2cost == '') {
$pm2 = 'None';
}
if (!$pm2 == 'None') {
$paymentmethod = $pm1 . ' (' . $pm1cost . '), ' . $pm2 . ' (' . $pm2cost . ')';
} else {
$paymentmethod = $pm1;
}
$items = $_POST['items'];
$itemscut = explode("|", $items);
$ses = FORMAT::SES(10);
$T = ENGINE::TICKET($tid, 3);
$return = MYSQL::QUERY("INSERT INTO core_checkout_sessions (customer, items, pm_1, pm_1_cost, pm_2, pm_2_cost, ses, s_id, d_date) VALUES (?,?,?,?,?,?,?,?,?)", array($T['t_customer'], $items, $pm1, $pm1cost, $pm2, $pm2cost, $ses, $user['store'], Date("Y-m-d H:i:s")));
echo "\n <style>\n .escca td{\n border-top: 0px;\n border-right: 0px;\n }\n </style>\n ";
$content = "\n <center style='width:724px;'>\n <table border='1' cellspacing='0' id='Header-Table' class='escca' style='margin-top:10px;border: 1px solid black;width: 98% !important;border-left: 0px;border-bottom:0px none !important;'>\n\t <thead>\n\t\t <tr>\n\t\t\t <td style='width:150px;height:150px;border-right:0px none;'><img src='https://my-cpr.com/cprlogo.jpg' border='0'></td>\n\t\t\t\t <td style='border-left:0px none;border-right:0px none;text-align:center;'>\n\t\t\t\t <div style='font-size:28px;'>\n\t\t\t\t\t <label style='font-size:32px;'><b>" . $user['store_info']['s_header'] . "</b></label><br/>\n\t\t\t\t\t\t <label style='font-size:24px;'>Contact our " . $user['store_info']['s_name'] . " Location at</label><br/>\n\t\t\t\t\t\t <label>" . FORMAT::PHONE($user['store_info']['s_phone']) . "</label><br/>\n\t\t\t\t\t\t <label><b>" . $user['store_info']['s_website'] . "</b></label>\n\t\t\t\t\t </div>\n\t\t\t\t </td>\n\t\t\t </tr>\n\t\t </thead>\n\t </table>\n\t <table border='1' cellspacing='0' id='Customer-Table' class='escca' style='border: 1px solid black;width: 98% !important;border-left: 0px;border-bottom:0px none !important;border-top:0px none;'>\n\t <tbody>\n\t\t <tr>\n\t\t\t <td><b>Name</b></td>\n\t\t\t\t <td><b>Phone Number</b></td>\n\t\t\t\t <td><b>Date (M/D/Y)</b></td>\n\t\t\t\t <td><b>Time</b></td>\n\t\t\t </tr>\n\t\t\t <tr style='font-family:Courier, monospace;'>\n\t\t\t <td>" . $T['c_name'] . "</td>\n\t\t\t\t <td>" . FORMAT::PHONE($T['c_phone']) . "</td>\n\t\t\t\t <td>" . Date('m/d/y') . "</td>\n\t\t\t\t <td>" . Date('h:i A') . "</td>\n\t\t\t </tr>\n\t\t </tbody>\n\t </table>\n <table border='1' cellspacing='0' id='Device-Table' class='escca' style='border: 1px solid black;width: 98% !important;border-left: 0px;border-bottom:0px none !important;border-top:0px none;'>\n\t <thead>\n\t\t <tr>\n\t\t\t <td><b>Service/Item<b/></td>\n\t\t\t\t\t <td style='width:60px'><center><b>Physical</b></center></td>\n\t\t\t\t <td style='width:60px'><center><b>Software</b></center></td>\n\t\t\t\t\t\t<td><b>Cost</b></td>\n\t\t\t </tr>\n\t\t </thead>\n\t\t <tbody style='font-family:Courier, monospace;'>\n\t\t\t\t\t";
$nontaxable = '';
$taxable = '';
$itemscheckedout = 0;
foreach ($itemscut as $item) {
$itemscheckedout++;
$split = explode("/", $item);
$b = explode("-", $split[0]);
if ($b[0] == "ti") {
$NT = MYSQL::QUERY("SELECT t_phy, t_liq, t_sof FROM core_tickets_checkout WHERE t_id = ? LIMIT 1;", array($b[1]));
if ($NT['t_liq'] == 1) {
$warr = false;
} else {
$warr = true;
}
if ($NT['t_liq'] == 1) {
require "../../../frame/engine.php";
ENGINE::START();
$USER = USER::VERIFY(0, TRUE);
if (empty($_GET['sSearch'])) {
$S = $_GET['string'];
} else {
$S = $_GET['sSearch'];
}
$iDS = $_GET['iDisplayStart'];
$iDL = $_GET['iDisplayLength'];
$iSC = $_GET['iSortCol_0'];
$iSD = $_GET['sSortDir_0'];
switch ($iSC) {
case 0:
$SS = 'ORDER BY c_name ' . $iSD;
break;
case 1:
$SS = 'ORDER BY c_phone ' . $iSD;
break;
case 2:
$SS = '';
break;
}
$iTotal = MYSQL::QUERY('SELECT COUNT(c_id) AS `COUNT` FROM core_customers WHERE c_name LIKE ? OR c_phone LIKE ?', array('%' . $S . '%', '%' . $S . '%'));
$iQuery = MYSQL::QUERY("SELECT * FROM core_customers WHERE c_name LIKE ? OR c_phone LIKE ? {$SS} LIMIT {$iDS},{$iDL}", array('%' . $S . '%', '%' . $S . '%'), FALSE, TRUE);
$OUTPUT = array('sEcho' => $_GET['sEcho'], 'iTotalRecords' => $iTotal[0]['COUNT'], 'iTotalDisplayRecords' => $iTotal[0]['COUNT'], 'aaData');
foreach ($iQuery as $C) {
$OUTPUT['aaData'][] = array($C['c_name'], FORMAT::PHONE($C['c_phone']), '<button onClick="LoadCustomer(' . "'" . $C['c_id'] . "'" . ')">LOAD</button>');
}
echo JSON_ENCODE($OUTPUT);
$USER = USER::VERIFY(0, TRUE);
$CID = $_GET['cid'];
$CUST = MYSQL::QUERY("SELECT * FROM core_customers WHERE c_id = ? LIMIT 1", array($CID));
$PHONE = FORMAT::PHONE($CUST['c_phone']);
switch ($CUST['c_contact_method']) {
case 0:
$CONT = FORMAT::PHONE($CUST['c_contact_info']);
break;
case 1:
$CONT = $CUST['c_contact_info'];
break;
case 2:
$CONT = 'Customer Will Contact Us';
break;
case 3:
$CONT = FORMAT::PHONE($CUST['c_phone']);
break;
}
$CORP = MYSQL::QUERY("SELECT * FROM core_corporate_accounts WHERE c_id = ? LIMIT 1", array($CUST['c_acc']));
echo <<<STR
<div style="width:240px;height:95px;display:inline-block;float:left;border-right: 1px solid #ACB1B7;padding-right:5px;">
\t\t<div style="width:100%;">
\t\t\t<div class="aname">Name:</div>
\t\t\t<div class="bname" style="padding-right:2px;">{$CUST['c_name']}</div>
\t\t\t<br/>
\t\t\t<div class="aname">Primary Phone:</div>
\t\t\t<div class="bname" style="padding-right:2px;">{$PHONE}</div>
\t\t\t<br/>
\t\t\t<div class="aname">Contact:</div>
\t\t\t<div class="bname" style="padding-right:2px;">{$CONT}</div>
\t\t\t<br/>
include '../../ajax/simple_html_dom.php';
$user = USER::VERIFY(0);
$manu = $_GET['manu'];
$model = $_GET['model'];
$lp = $_GET['lp'];
$up = $_GET['up'];
$sp = str_replace(";", "&", $_GET['sp']);
$iden = $_GET['iden'];
$notes = $_GET['notes'];
$ses = FORMAT::SES(10);
$Model = MYSQL::QUERY("SELECT * FROM device_models WHERE m_id = ? LIMIT 1", array($model));
MYSQL::QUERY("INSERT INTO core_refurb_devices (d_manu_id, d_model_id, d_model, d_iden, d_locked_price, d_unlocked_price, d_service_provider, d_notes, d_by, d_store, d_ses, d_date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?);", array($manu, $model, $Model['m_name'], $iden, $lp, $up, $sp, $notes, $user['user_id'], $user['store'], $ses, Date("Y-m-d H:i:s")));
$SELECT = MYSQL::QUERY("SELECT d_id, d_ses FROM core_refurb_devices WHERE d_ses = ? LIMIT 1", array($ses));
$infoset = '';
$url = "http://www.phonearena.com" . $Model['m_link'];
$html = file_get_html($url);
foreach ($html->find('div.rightspecscol') as $section) {
foreach ($section->find('div.s_specs_box') as $info) {
$info->onclick = null;
$info->href = null;
$infoset .= $info;
}
}
echo "\n<style>\n#phone_specificatons a{display: none !important;font-family: Arial,Helvetica,sans-serif;}\n.s_box_4{border:5px\nsolid #d0e8f5}.s_box_4\nh2{margin:0px;padding:7px 10px 7px 10px;line-height:22px;font-size:18px;font-weight:normal;color:#0f6c9b;background-color:#d0e8f5;display:none;}.s_box_4_orange_1{border:5px\nsolid #ffc56b}.s_box_4_orange_1\nh2{color:#6f3700;background-color:#ffc56b}.s_box_4_gray_1{border:5px\nsolid #ddd}.s_box_4_gray_1\nh2{color:#666;background-color:#ddd}.s_box_4\n.s_listing{margin-right:-15px}.s_box_4\n.s_block_4{margin-right:10px;margin-bottom:10px;text-align:center}.s_block_1\n.s_wall_to_wall{display:inline-block;color:#aaa;font-size:18px;vertical-align:top}.s_block_1\n.s_show_hide{vertical-align:top;color:#999;font-size:14px}.s_block_1 a.s_show_hide:hover{color:#ff250f}.s_specs_box{margin-bottom:0px;font-size:12px;border:5px\nsolid #dff3fd;width:49%;float:left;display:inline-block;}.s_specs_box\nh3{padding-left:9px;background-color:#dff3fd}.s_specs_box li\nstrong.s_lv_1{display:block;float:left;width:100px;color:#226290}.s_specs_box li\nstrong.s_lv_1.s_bullet_advanced{width:85px}.s_specs_box li li\nstrong{font-weight:normal;color:#777}.s_specs_box\nli.s_lv_1{overflow:hidden;padding:5px\n5px 0px 5px;border-bottom:1px solid #eee}.s_specs_box>ul>li:nth-child(even),.s_specs_box>ul>li.s_even{}.s_specs_box>ul>li:hover{background:#FFFCE0}.s_specs_box>ul>li:last-child{}.s_specs_box\nul.s_lv_1{padding-left:110px}.s_specs_box ul.s_lv_1\nli{}.s_specs_box\nstrong.s_lv_2{position:relative;float:left;width:95px !important;margin-left:-96px;text-align:left;color:#4dafe1;color:#226290}.s_specs_box\nstrong.s_lv_2.s_bullet_advanced{width:80px !important;margin-left:-96px}.s_specs_box\nli.s_lv_3{~overflow: hidden;width:100%;~border: 1px solid #fff}.s_specs_box\nstrong.s_lv_3{position:relative;float:left;margin-left:-86px;width:85px !important;text-align:left;color:#1B93D0}.s_specs_box\nstrong.s_lv_3.s_bullet_advanced{width:70px !important;margin-left:-86px}.s_specs_box\nul.s_lv_3{~overflow: hidden;width:100%;position:relative;margin-bottom:4px}.s_specs_box>ul>li>ul>li>ul{margin-bottom:4px}.s_specs_box>ul>li>ul>li>ul:last-child{margin-bottom:0}.s_specs_box>ul>li>ul>li.clearfix{padding-top:4px}.s_specs_box.s_form > ul > li > ul\nli{padding-left:5px;padding-left:0px;text-align:left}.s_specs_box>ul>li>ul>li>ul>li{padding-left:0}.s_specs_box .s_text,\n.s_specs_box textarea,\n.s_specs_box\nselect{font-size:11px}.s_specs_box\nselect{width:100%}.s_specs_box .s_text,\n.s_specs_box\ntextarea{padding:2px\n!important}.s_specs_box label.s_radio,\n.s_specs_box\nlabel.s_checkbox{display:block !important;margin-bottom:2px}.s_specs_box{margin-bottom:0px;padding:1px;font-size:12px;border:none}.s_specs_box\nh3{padding:5px\n9px;font-size:16px;font-weight:bold;background:#fff;color:#505050;text-transform:uppercase;font-family:'Open Sans',Arial,Helvetica,sans-serif}.s_specs_box\nul{background:#f9f9f9;background:none;padding:0px;margin:0px;border:1px\nsolid #dadada;font-style:normal;font-size:13px;line-height:18px}.s_specs_box ul ul, .s_specs_box ul ul\nul{border:none;margin:0;padding:0}.s_specs_box ul\nli{display:block !important;margin:0px;padding:4px\n7px !important}.s_specs_box ul li + .s_specs_box ul\nli{border-top:1px solid #ccc !important}.s_specs_box ul li ul li, .s_specs_box ul li ul li ul\nli{border:none !important;margin:0;padding:0px\n!important}.s_specs_box li strong.s_lv_1, .s_specs_box\nstrong.s_lv_2{font-style:normal;color:#505050;font-size:12px;text-align:left}.s_specs_box > ul > li > ul > li\nstrong{margin-left:-100px !important}.s_specs_box>ul>li:last-child{border-bottom:none}.s_specs_box input.text,\n.s_specs_box\nlabel{text-align:left}.s_specs_box\ntable{margin-bottom:0;border:none}.s_filter_box th,\n.s_filter_box\ntd{border:none;border-top:1px solid #ddd}.s_filter_box\ntd{width:160px}.s_filter_box tr.s_level_2 td,\n.s_filter_box tr.s_level_2 th,\n.s_filter_box tr.s_level_3 th,\n.s_filter_box tr.s_level_3\ntd{padding-top:0;padding-bottom:7px;border:none !important;vertical-align:top;background:none !important}.s_filter_box tr:first-child th,\n.s_filter_box td:first-child\ntd{border:none !important}.s_filter_box\nlabel{white-space:normal !important}.s_specs_box table th,\n.s_specs_box table\nstrong.s_label{color:#226290;font-weight:bold}.s_specs_box table\nstrong.s_label{display:block;padding-bottom:5px}.s_specs_box table tr.s_level_2\nth{font-weight:normal;padding-left:13px}.s_specs_box table tr.s_level_3\nth{font-weight:normal;padding-left:18px;color:#52a1cc}.s_specs_box.s_1_col table tr.s_level_2\ntd{padding-left:13px}.s_specs_box.s_1_col table tr.s_level_2 td\nstrong.s_label{font-weight:normal}.s_specs_box.s_1_col table tr.s_level_3\ntd{padding-left:18px}.s_specs_box.s_1_col table tr.s_level_3 td\nstrong.s_label{font-weight:normal;color:#52a1cc}.s_specs_box table th:first-child{padding-left:8px}.s_specs_box table td:last-child{padding-right:8px}.s_specs_box table tr th:last-child,\n.s_specs_box table tr td:last-child{border-right:none}.s_specs_box table tr:last-child\nth{border-bottom:none}\n.s_tooltip_content{display:none;}\n.gray_9{display:none;}\n.floatright{display:none;}\n</style>\n<div style='height:450px;width:49%;overflow:hidden;display:inline-block;float:left;font-size:16px;position:relative;'>\n<center>\n <img src='https://my-cpr.com/barcode.php?encode=I25&height=20&scale=1&color=000000&bgcolor=FFFFFF&type=png&file=&bdata=" . $SELECT['d_id'] . "' border='0' /><br/>\n\tIdentifier<br/>" . $iden . "<br/>\n <img border='0' src='https://my-cpr.com/cprlogo.jpg' style='position:absolute;bottom:20px;left:0px;'>\n\t<div style='position:absolute;bottom:25px;right:5px;width:50%;'>\n\t <b>Device:</b> " . $Model['m_name'] . "<br/>\n\t <b>Carrier:</b> " . $sp . "<br/>\n\t <b>Price:</b> \$" . $lp . "<br/>\n\t ";
if ($up > $lp) {
echo "<b>UnLocked Price:</b> \$" . $up . "<br/><br/>";
} else {
echo "<br/><br/>";
}
echo "\n\t</div>\n</center>\n</div>\n<div style='height:500px;width:49%;overflow:hidden;display:inline-block;float:left;margin-left:2%;'><center>\n<font style='font-size:24px;'>" . $user['store_info']['s_header'] . "</font><br/>\n<font style='font-size:16px;'>Contact our " . $user['store_info']['s_name'] . " Location at</font><br/>\n<font style='font-size:20px;'>" . FORMAT::PHONE($user['store_info']['s_phone']) . "</font><br/>\n<font style='font-size:18px;'>" . $user['store_info']['s_website'] . "</font><br/><br/><br/>\n<font style='font-size:16px;'>Warranty:</font><br/>\n<font style='font-size:40px;'>6 Months</font><br/><br/>\n<b>Physical Warranty</b> - This warranty covers any device purchased. If the device proves to be defective in any way we will replace it at no extra charge.\n\t\t\t\t\t\t\tThis warranty is void if the device sustains any physical or liquid damage.\n\t\t\t\t\t\t\t<br/><br/>\n\t\t\t\t\t\t\t<b>Software Warranty</b> - This warranty guarantees any software service we provide for the device at sale (e.g. Unlocking). If for any reason the device is updated, modified (e.g. jailbreaking, unlocking, rooting) or sustains\n\t\t\t\t\t\t\tphysical or liquid damage the warranty becomes void.\n\t\t\t\t\t\t\t<br/><br/>\n\t\t\t\t\t\t\t<b>Liquid Damage</b> - If your device sustains liquid damage its warranty becomes null and void. No Exceptions.\n</center></div>\n<div style='height:450px;width:100%;overflow:hidden;'>\n" . $infoset . "\n</div>\n";
$BUTTONS['B3_F'] = 'DISABLED';
$BUTTONS['B4'] = 'Re-Open Ticket';
$BUTTONS['B4_F'] = 'onClick="ReopenTicket(' . "'" . $CODE . "'" . ')"';
break;
case 99:
$BUTTONS['B3_F'] = 'DISABLED';
$BUTTONS['B4'] = 'Re-Open Ticket';
$BUTTONS['B4_F'] = 'onClick="ReopenTicket(' . "'" . $CODE . "'" . ')"';
break;
}
$PHY = $TICKET['INFO']['t_phy'] == 1 ? "Yes" : "No";
$LIQ = $TICKET['INFO']['t_liq'] == 1 ? "Yes" : "No";
$SOF = $TICKET['INFO']['t_sof'] == 1 ? "Yes" : "No";
$MANU = $TICKET['MANU']['m_name'];
$MODEL = str_replace($MANU . " ", "", $TICKET['MODE']['m_name']);
$PHONE = FORMAT::PHONE($TICKET['CUST']['c_phone']);
$CD = date("M d, Y h:i A", strtotime($TICKET['INFO']['t_created']));
if (empty($TICKET['INFO']['t_estimate_created'])) {
$ED = "";
} else {
$ED = date("M d, Y h:i A", strtotime($TICKET['INFO']['t_estimate_created']));
}
if (empty($TICKET['INFO']['t_repair_created'])) {
$RD = "";
} else {
$RD = date("M d, Y h:i A", strtotime($TICKET['INFO']['t_repair_created']));
}
if (empty($TICKET['INFO']['t_checkout_created'])) {
$CHD = "";
} else {
$CHD = date("M d, Y h:i A", strtotime($TICKET['INFO']['t_checkout_created']));
<?php
require "../../../frame/engine.php";
ENGINE::START();
$user = USER::VERIFY(0, TRUE);
$string = $_GET['string'];
$string = str_replace('-', '', $string);
$string = '%' . $string . '%';
$params = array(':phone' => $string, ':name' => $string);
$Main = MYSQL::QUERY('SELECT c_id,c_name,c_phone FROM core_customers WHERE c_phone LIKE :phone OR c_name LIKE :name', $params);
if (!$Main == "") {
$options = "";
$i = 0;
foreach ($Main as $a) {
$options .= '<option value=' . $a['c_id'] . '>' . $a['c_name'] . ' ~ ' . FORMAT::PHONE($a['c_phone']) . '</option>';
$i++;
}
echo '<option value="">' . $i . ' Customer(s) Found...</option>' . $options;
} else {
echo '<option value="">0 Customer(s) Found...</option>';
}
<?php
require "../../../frame/engine.php";
ENGINE::START();
$user = USER::VERIFY(0, TRUE);
$string = $_GET['string'];
$Main = MYSQL::QUERY('SELECT c_id,c_name,c_phone FROM core_customers WHERE c_card = ? LIMIT 1', array($string));
if (!$Main == "") {
echo '<option value=' . $Main['c_id'] . '>' . $Main['c_name'] . ' ~ ' . FORMAT::PHONE($Main['c_phone']) . '</option>';
} else {
echo '<option value="">0 Customer(s) Found...</option>';
}
<?php
require "../../../frame/engine.php";
ENGINE::START();
$user = USER::VERIFY(0, TRUE);
$R = MYSQL::QUERY("SELECT c_name, c_phone FROM core_customers WHERE c_phone = ?", array($_GET['val']));
if (empty($R)) {
echo '1|No Customer Found with this Number';
} else {
echo '0|<b>Customer(s) Found Already using this Number:</b><br/>';
foreach ($R as $C) {
echo "<br/>" . $C['c_name'] . " - " . FORMAT::PHONE($C['c_phone']);
}
}
<?php
require "../../frame/engine.php";
ENGINE::START();
$user = USER::VERIFY(0, TRUE);
$MAIN = MYSQL::QUERY('SELECT * FROM core_customers WHERE c_name LIKE ? OR c_phone LIKE ? ORDER BY c_name ASC LIMIT 0,10', array('%' . $_GET['string'] . '%', '%' . $_GET['string'] . '%'));
if (!empty($MAIN)) {
if (!empty($MAIN[1])) {
echo 'MUL|<div><table id="custTable" class="stylized"><thead><tr><th>Name</th><th>Phone</th><th>Select</th></tr></thead><tbody>';
foreach ($MAIN as $C) {
echo '<tr><td>' . $C['c_name'] . '</td><td>' . FORMAT::PHONE($C['c_phone']) . '</td><td><button onClick="LoadCustomer(' . "'" . $C['c_id'] . "'" . ')">LOAD</button></tr>';
}
$R = MYSQL::QUERY('SELECT COUNT(c_id) FROM core_customers WHERE c_name LIKE ? OR c_phone LIKE ?', array('%' . $_GET['string'] . '%', '%' . $_GET['string'] . '%'));
echo '</tbody><tfoot><tr><th>Name</th><th>Phone</th><th>Select</th></tr></tfoot></table></div>|' . $R[0]['COUNT(c_id)'];
} else {
echo 'SIN|' . $MAIN[0]['c_id'];
}
} else {
echo 'NAN|';
}
