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++; }*/ }