public function getWorkSheetList($id = "", $pg) { $purl = array(); if (isset($_GET['url'])) { $purl = $_GET['url']; $purl = rtrim($purl); $purl = explode('/', $_GET['url']); } else { $purl = null; } if (!isset($purl['2'])) { $pn = 1; } else { $pn = $purl['2']; } global $database; $resultWorksheet = $database->db_query("SELECT * FROM work_sheet_form "); $pagin = new Pagination(); //create the pagination object; $pagin->nr = $database->dbNumRows($resultWorksheet); $pagin->itemsPerPage = 20; $myworksheets = Ticket::find_by_sql("SELECT * FROM work_sheet_form " . $pagin->pgLimit($pn)); $index_array = array("worksheet" => $myworksheets, "mypagin" => $pagin->render($pg)); return $index_array; return $index_array; }
function __construct() { parent::__construct(); $this->view_data['core_settings'] = Setting::first(); if ($this->input->cookie('language') != "") { $language = $this->input->cookie('language'); } else { if (isset($this->view_data['language'])) { $language = $this->view_data['language']; } else { if (!empty($this->view_data['core_settings']->language)) { $language = $this->view_data['core_settings']->language; } else { $language = "english"; } } } $this->lang->load('application', $language); $this->lang->load('messages', $language); $this->lang->load('event', $language); $this->user = $this->session->userdata('user_id') ? User::find_by_id($this->session->userdata('user_id')) : FALSE; $this->client = $this->session->userdata('client_id') ? Client::find_by_id($this->session->userdata('client_id')) : FALSE; if ($this->client) { $this->theme_view = 'application_client'; } $this->view_data['datetime'] = date('Y-m-d H:i', time()); $this->view_data['sticky'] = Project::all(array('conditions' => 'sticky = 1')); $this->view_data['quotations_new'] = Quote::find_by_sql("select count(id) as amount from quotations where status='New'"); if ($this->user || $this->client) { $access = $this->user ? $this->user->access : $this->client->access; $access = explode(",", $access); if ($this->user) { $this->view_data['menu'] = Module::find('all', array('order' => 'sort asc', 'conditions' => array('id in (?) AND type = ?', $access, 'main'))); $this->view_data['widgets'] = Module::find('all', array('conditions' => array('id in (?) AND type = ?', $access, 'widget'))); } else { $this->view_data['menu'] = Module::find('all', array('order' => 'sort asc', 'conditions' => array('id in (?) AND type = ?', $access, 'client'))); } if ($this->user) { $update = User::find($this->user->id); } else { $update = Client::find($this->client->id); } $update->last_active = time(); $update->save(); if ($this->user) { $this->view_data['user_online'] = User::all(array('conditions' => array('last_active+(30 * 60) > ? AND status = ?', time(), "active"))); $this->view_data['client_online'] = Client::all(array('conditions' => array('last_active+(30 * 60) > ? AND inactive = ?', time(), "0"))); } $email = $this->user ? 'u' . $this->user->id : 'c' . $this->client->id; $this->view_data['messages_new'] = Privatemessage::find_by_sql("select count(id) as amount from privatemessages where `status`='New' AND recipient = '" . $email . "'"); $this->view_data['tickets_new'] = Ticket::find_by_sql("select count(id) as amount from tickets where `status`='New'"); } /*$this->load->database(); $sql = "select * FROM templates WHERE type='notes'"; $query = $this->db->query($sql); */ $this->view_data["note_templates"] = ""; //$query->result(); }
/** * Dashboard statistics section */ public function getDashboardStat() { global $database; $darray = array(); $open_ticket_count = $database->dbNumRows($database->db_query("SELECT * FROM support_ticket WHERE status ='Open' ")); $open_schedule_count = $database->dbNumRows($database->db_query("SELECT * FROM schedule WHERE status ='Open' ")); $open_worksheet_count = $database->dbNumRows($database->db_query("SELECT * FROM work_sheet_form WHERE status ='Open' ")); $awaiting_ticket_count = $database->dbNumRows($database->db_query("SELECT * FROM support_ticket WHERE status ='Customer Reply' ")); $closed_worksheet_count = $database->dbNumRows($database->db_query("SELECT * FROM work_sheet_form WHERE status ='Closed' ")); $client_count = $database->dbNumRows($database->db_query("SELECT * FROM tbl_client")); $client_products = $database->dbNumRows($database->db_query("SELECT * FROM client_product")); //$schedule $openPendings = Ticket::find_by_sql("SELECT * FROM support_ticket WHERE (status ='Admin Reply' OR status='Customer Reply') OR status ='Open' "); // print_r($openPendings); $clients = Client::find_all(); $darray = array("cproducts" => $client_products, "clients" => $clients, "oworksheet" => $open_worksheet_count, "oschedule" => $open_schedule_count, "otcount" => $open_ticket_count, "atcount" => $awaiting_ticket_count, "openPend" => $openPendings); return $darray; }
public function getData() { global $database; $depts = Department::find_all(); $role = Roles::find_all(); $country = Country::find_all(); $vendors = Vendor::find_all(); $countAcc = count(Cproduct::find_by_client($_SESSION["client_ident"])); $schedule = Cproduct::getNextSchedule($_SESSION["client_ident"]); $OnSchedule = Schedule::find_by_sql("SELECT * FROM schedule WHERE client_id='" . $_SESSION['client_ident'] . "' AND maint_type !='Activation' AND (status='Open' OR status='In Progress') ORDER BY id DESC LIMIT 10"); $OnScheduleAct = Schedule::find_by_sql("SELECT * FROM schedule WHERE client_id='" . $_SESSION['client_ident'] . "' AND maint_type='Activation' AND (status='Open' OR status='In Progress') ORDER BY id DESC LIMIT 10"); $countTicketOpen = count(Ticket::find_by_sql("SELECT * FROM support_ticket WHERE client_id ='" . $_SESSION['client_ident'] . "' AND status ='Open'")); $countTicketClose = count(Ticket::find_by_sql("SELECT * FROM support_ticket WHERE client_id ='" . $_SESSION['client_ident'] . "' AND status ='Closed'")); $countTicketPending = count(Ticket::find_by_sql("SELECT * FROM support_ticket WHERE client_id ='" . $_SESSION['client_ident'] . "' AND (status ='Admin Reply' OR status='Customer Reply')")); $countTic = count(Ticket::find_by_client($_SESSION['client_ident'])); $countuser = count(Clientuser::find_by_client($_SESSION['client_ident'])); $zone = Zone::find_by_sql("SELECT * FROM zone"); $startups = array("cschedule" => $OnSchedule, "departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "countProd" => $countAcc, "countTick" => $countTic, "Schel" => $schedule, "SchelAct" => $OnScheduleAct, "CountPending" => $countTicketPending, "CountOpent" => $countTicketOpen, "CountClosed" => $countTicketClose, "CountUsers" => $countuser); return $startups; }
public function getListClient($id = "", $pg) { $purl = array(); if (isset($_GET['url'])) { $purl = $_GET['url']; $purl = rtrim($purl); $purl = explode('/', $_GET['url']); } else { $purl = null; } if (!isset($purl['2'])) { $pn = 1; } else { $pn = $purl['2']; } $statusfield = ""; /** * of all the filter fields if only one field is set */ $filterResult = ""; if (isset($_REQUEST['status']) && !empty($_REQUEST['status'])) { if ($_REQUEST['status'] != "Pending") { $statusfield .= " AND status = '" . $_REQUEST['status'] . "' "; } else { $statusfield .= " AND status = 'Admin Reply' OR status = 'Customer Reply'"; } } $filterResult .= " WHERE client_id ='" . $_SESSION['client_ident'] . "' " . $statusfield; global $database; $resultEmployee = $database->db_query("SELECT * FROM support_ticket WHERE client_id='" . $_SESSION["client_ident"] . "'"); $pagin = new Pagination(); //create the pagination object; $pagin->nr = $database->dbNumRows($resultEmployee); $pagin->itemsPerPage = 20; $myitems = Ticket::find_by_sql("SELECT * FROM support_ticket " . $filterResult . " ORDER BY datemodified DESC " . $pagin->pgLimit($pn) . ""); $index_array = array("supportticket" => $myitems, "mypagin" => $pagin->render($pg)); return $index_array; return $index_array; }
function __construct() { parent::__construct(); $access = FALSE; $link = '/' . $this->uri->uri_string(); if ($this->client) { if ($this->input->cookie('fc2_link') != "") { $link = str_replace("/tickets/", "/ctickets/", $link); redirect($link); } redirect('ctickets'); } elseif ($this->user) { foreach ($this->view_data['menu'] as $key => $value) { if ($value->link == "tickets") { $access = TRUE; } } if (!$access) { redirect('login'); } } else { $cookie = array('name' => 'fc2_link', 'value' => $link, 'expire' => '500'); $this->input->set_cookie($cookie); redirect('login'); } $this->view_data['submenu'] = array($this->lang->line('application_open') => 'tickets', $this->lang->line('application_my_tickets') => 'tickets/filter/assigned', $this->lang->line('application_closed') => 'tickets/filter/closed'); $this->load->database(); $this->view_data['tickets_assigned_to_me'] = Ticket::count(array('conditions' => 'user_id = ' . $this->user->id . ' and status != "closed"')); $this->view_data['tickets_in_my_queue'] = Ticket::count(array('conditions' => 'queue_id <= ' . $this->user->queue . ' and status != "closed"')); $now = time(); $beginning_of_week = strtotime('last Monday', $now); // BEGINNING of the week $end_of_week = strtotime('next Sunday', $now) + 86400; // END of the last day of the week $this->view_data['tickets_opened_this_week'] = Ticket::find_by_sql('select count(id) AS "amount", DATE_FORMAT(FROM_UNIXTIME(`created`), "%w") AS "date_day", DATE_FORMAT(FROM_UNIXTIME(`created`), "%Y-%m-%d") AS "date_formatted" from tickets where created >= "' . $beginning_of_week . '" AND created <= "' . $end_of_week . '" '); //$this->view_data['tickets_closed_this_week'] = Ticket::find_by_sql('select count(id) AS "amount", DATE_FORMAT(FROM_UNIXTIME(`created`), "%w") AS "date_day", DATE_FORMAT(FROM_UNIXTIME(`created`), "%Y-%m-%d") AS "date_formatted" from tickets where created >= "'.$beginning_of_week.'" AND created <= "'.$end_of_week.'" '); }
public function getWorkSheetList($id = "", $pg) { $purl = array(); if (isset($_GET['url'])) { $purl = $_GET['url']; $purl = rtrim($purl); $purl = explode('/', $_GET['url']); } else { $purl = null; } if (!isset($purl['2'])) { $pn = 1; } else { $pn = $purl['2']; } $statusfield = ""; $clientidfield = ""; $issuefield = ""; // $productidfield =""; $datefield = ""; /** * of all the filter fields if only one field is set */ $filterResult = ""; if (isset($_REQUEST['status']) && !empty($_REQUEST['status'])) { $statusfield .= " AND status = '" . $_REQUEST['status'] . "' "; } if (isset($_REQUEST['clientid']) && !empty($_REQUEST['clientid'])) { $clientidfield .= " AND client_id=" . $_REQUEST['clientid']; } if (isset($_REQUEST['issue']) && !empty($_REQUEST['issue'])) { $issuefield .= " AND problem LIKE '%" . $_REQUEST['issue'] . "%' "; } //if(isset($_REQUEST['prodid']) && !empty($_REQUEST['prodid'])){ // $productidfield .= " AND prod_id = '".$_REQUEST['prodid']."' "; //} /*if(!empty($_REQUEST['fdate']) && !empty($_REQUEST['tdate'])){ $datefield .= " AND datecreated BETWEEN '".$_REQUEST['fdate']."' AND '".$_REQUEST['tdate']."' "; } if(empty($_REQUEST['fdate']) && !empty($_REQUEST['tdate'])){ $datefield .= " AND datecreated < '".$_REQUEST['tdate']."' "; } if(!empty($_REQUEST['fdate']) && empty($_REQUEST['tdate'])){ $datefield .= " AND datecreated > '".$_REQUEST['fdate']."' "; }*/ $filterResult .= " WHERE id !=''" . $clientidfield . $issuefield . $statusfield; global $database; $resultWorksheet = $database->db_query("SELECT * FROM work_sheet_form "); $pagin = new Pagination(); //create the pagination object; $pagin->nr = $database->dbNumRows($resultWorksheet); $pagin->itemsPerPage = 20; $myworksheets = Ticket::find_by_sql("SELECT * FROM work_sheet_form " . $filterResult . " ORDER BY id DESC " . $pagin->pgLimit($pn)); $index_array = array("worksheet" => $myworksheets, "mypagin" => $pagin->render($pg, "worksheetlist")); return $index_array; }