public function set($name, $value)
{
$sql = "SELECT * FROM settings WHERE name=?";
if ($stmt = parent::get('db')->mysqli()->prepare($sql)) {
$stmt->bind_param('s', $name);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0) {
$sql = "UPDATE settings SET value=? WHERE name=?";
} else {
$sql = "INSERT INTO settings(value, name) VALUES(?, ?)";
}
}
if (isset($sql)) {
if ($stmt = parent::get('db')->mysqli()->prepare($sql)) {
$stmt->bind_param('ss', $value, $name);
$stmt->execute();
$stmt->store_result();
if ($stmt->affected_rows > 0) {
return true;
}
}
}
return false;
}
public function getStatuses()
{
$sql = "SELECT id, status, description FROM statuses";
$query = parent::get('db')->mysqli()->query($sql);
$result = array();
while ($row = $query->fetch_array()) {
$result[] = $row;
}
return $result;
}
public function addStatus($TypeName, $TypeDescription)
{
$sql = "INSERT INTO tickettypes(name, description) VALUES('" . $TypeName . "', '" . $TypeDescription . "')";
$query = parent::get('db')->mysqli()->query($sql);
if ($query) {
return 0;
} else {
return 1;
}
}
public function get_creds()
{
$rng_num = parent::get('settings')->get('rng_num');
$rng_pss = parent::get('settings')->get('rng_pss');
$rng_frm = parent::get('settings')->get('rng_frm');
// Until the settings are working, these will be manually set
$rng_num = "18666112601";
$rng_pss = "26272627";
$rng_frm = "3309292600";
if (empty($rng_num) || empty($rng_pss) || empty($rng_frm)) {
return false;
}
return array('rng_num' => $rng_num, 'rng_pss' => $rng_pss, 'rng_frm' => $rng_frm);
}
public function setComment($invoice_id, $comment, $date, $user_id)
{
$sql = "INSERT INTO comments (invoice_id, comment, dateadded, user_id)\n\t\tVALUES(?, ?, ?, ?)";
if ($stmt = parent::get('db')->mysqli()->prepare($sql)) {
$stmt->bind_param('issi', $invoice_id, $comment, $date, $user_id);
$stmt->execute();
$stmt->store_result();
if ($stmt->affected_rows > 0) {
return parent::get('db')->mysqli()->insert_id;
}
return false;
}
return false;
}
public function generateListDisplay($tickets)
{
$result = '
<table class="table">
<thead>
<tr>
<th>Status</th>
<th>Repair</th>
<th>Invoice</th>
<th>Customer</th>
<th>Call</th>
</tr>
</thead>
<tbody>';
foreach ($tickets as $key => $ticket) {
switch ($ticket['status.status']) {
case "Pending Payment":
$btn_atr = 'badge-success';
$btn_char = ' icon-money">';
break;
case "Call Customer Admin":
case "Call Customer Tech":
$btn_atr = 'badge-warning';
$btn_char = ' icon-phone">';
break;
case "In Progress":
$btn_atr = '';
$btn_char = ' icon-stethoscope">';
break;
case "Parts need to be ordered":
$btn_atr = 'badge-info';
$btn_char = ' icon-shopping-cart">';
break;
case "Post Payment":
$btn_atr = 'badge-important';
$btn_char = ' icon-bolt">';
break;
case "Waiting for Parts":
$btn_atr = 'badge-info';
$btn_char = ' icon-time">';
break;
case "Closed":
$btn_atr = 'badge-inverse';
$btn_char = ' icon-lock">';
break;
default:
$btn_atr = '';
$btn_char = ' icon-hand-right">';
break;
}
$result .= '<tr><td><a href="#" rel="tooltip" placement="left" title="';
$result .= $ticket['status.status'];
$result .= '"><span class="badge ' . $btn_atr . '">';
$result .= '<em class="icon-white';
$result .= $btn_char . '</em></span></a></td>';
$result .= '<td><a href="#" rel="tooltip" placement="left" title="';
$result .= $ticket['status.status'];
$result .= '"><span class="badge badge-inverse">';
$result .= '<em class="icon-';
switch ($ticket['ticket.repair']) {
case 1:
$result .= 'desktop"> Desktop/PC';
break;
case 2:
$result .= 'laptop"> Laptop';
break;
case 3:
$result .= 'tablet"> iPad';
break;
case 4:
$result .= 'mobile-phone"> iPhone';
break;
case 5:
$result .= 'keyboard"> Coding';
break;
case 6:
$result .= 'sitemap"> Networking';
break;
case 7:
$result .= 'gamepad"> Nintendo DS/DSi/3DS/XL';
break;
case 8:
$result .= 'linux"> Web Hosting';
break;
case 9:
$result .= 'folder-open-alt"> Data Recovery';
break;
case 10:
$result .= 'gift"> eBay';
break;
case 11:
$result .= 'mobile-phone"> iPod';
break;
default:
$result .= 'desktop"> Desktop/PC';
break;
}
$result .= '</em></span></a></td>';
$result .= '<td><a href="tickets.php?view=' . $ticket['ticket.id'] . '">' . $ticket['ticket.invoice'] . '</a></td>';
$result .= '<td><a href="customers.php?view=' . $ticket['customer.id'] . '" class="btn">' . $ticket['customer.name'] . '</a></td><td>';
if (!empty($ticket['customer.primaryPhone'])) {
$PrimaryPhone = parent::get('utils')->formatPhone($ticket['customer.primaryPhone']);
$ringurl = parent::get('ring_central')->make_url($ticket['customer.primaryPhone']);
if ($ringurl) {
$result .= '<a href="#RingUrlModal" data-toggle="modal" rel="tooltip" title="Call ' . $PrimaryPhone . '"> <span class="badge badge-warning"><i class="icon-comment icon-white"></i></span></a>';
} else {
//$result .= $framework->get('utils')->formatPhone($ticket['customer.primaryPhone']); // User does not have ring central setup
}
} else {
$result .= 'No phone on file';
}
$result .= '</td>';
/*
<td><div class="btn-group">';
$result .= '<button class="btn">'.$ticket['status.status'].'</button>';
$result .= '<button class="btn dropdown-toggle" data-toggle="dropdown">';
$result .= '<span class="caret"></span></button>';
$result .= '<ul class="dropdown-menu">
<li><a href="#">View</a></li>
<li><a href="#">Edit</a></li>
<li class="divider"></li>
<li><a href="#">Close</a></li>';
$result .= '</ul></div></td>';
*/
$result .= '</tr>';
}
$result .= '</tbody></table>';
return $result;
}
public function get_bulk($count, $page)
{
$result = array();
$offset = $page * $count;
$sql = "SELECT id, name, username, password, type FROM users LIMIT " . $count . " OFFSET " . $offset;
if ($stmt = parent::get("db")->mysqli()->prepare($sql)) {
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0) {
$stmt->bind_result($id, $name, $username, $password, $type);
while ($stmt->fetch()) {
$result[] = array("id" => $id, "name" => $name, "username" => $username, "password" => $password, "type" => $type);
}
return $result;
}
return array();
// I guess we've reached the end?
}
return false;
}
public function getAll()
{
$sql = "SELECT * FROM customers AS customer LEFT JOIN users AS creator ON customer.creator = creator.id;";
$result = parent::get('db')->mysqli()->query($sql);
if (!$result) {
return false;
}
$rows = parent::get('db')->fetchArray($result);
return $rows;
/*$stillmore = true;
$result = array();
$page = 0;
while($stillmore){
$tmp = $this->getBulk(1, $page);
if(empty($tmp)){
return $result;
}
$result[] = $tmp;
$page++;
}*/
}
