File manager

File manager - Edit - /home/autoph/public_html/connectv1/src/Controllers/NatureOfBusinessController.php

Back
<?php namespace App\Controllers; use App\Core\Controller; use App\Core\Sms; use App\Utilities\Session; use App\Utilities\Uuid; use App\Utilities\Utility; class NatureOfBusinessController extends Controller { private $nob; private $nob_perm = array(); function __construct() { $this->nob = new \App\Models\NatureOfBusiness; //access if (isset(Session::get('action_permissions')['5']['53']['25'])) { $this->nob_perm = Session::get('action_permissions')['5']['53']['25']; } if (isset(Session::get('action_permissions')['5']['53']['27'])) { $this->nob_perm = Session::get('action_permissions')['5']['53']['27']; } } public function topNatureOfBusinessIndex() { //access if (!in_array("1", $this->nob_perm)) { response()->redirect("/index.php"); } $page_title = "Top Nature of Business"; //get the attributes $attribute_list = $this->nob->getNatureOfBusinessCategories(); $nob_cat_options = ""; foreach ($attribute_list as $row) { $nob_cat_options .= '<option value="' . $row['id'] . '">' . $row['name'] . '</option>'; } include('resources/views/nature_of_business/top/list.php'); } public function summaryReport() { //access if (!in_array("1", $this->nob_perm)) { response()->redirect("/index.php"); } $page_title = "NoB Summary Report"; include('resources/views/nature_of_business/top/summary_report.php'); } public function topNatureOfBusinessList($cat_id) { if (!in_array("1", $this->nob_perm)) { response()->redirect("/index.php"); } $page_title = $this->nob->getNatureOfBusinessInfo($cat_id)[0]['name']; $attribute_list = $this->nob->getNatureOfBusinessCategories(); $nob_cat_options = ""; foreach ($attribute_list as $row) { if ($cat_id == $row['id']) { $nob_cat_options .= '<option value="' . $row['id'] . '" selected>' . $row['name'] . '</option>'; } else { $nob_cat_options .= '<option value="' . $row['id'] . '">' . $row['name'] . '</option>'; } } include('resources/views/nature_of_business/top/data.php'); } public function natureOfBusinessData(){ $array_data['offset'] = input('offset'); $array_data['limit'] = input('limit'); $array_data['offset_limit'] = " LIMIT " . $array_data['offset'] . "," . $array_data['limit'] . ""; $array_data['sort'] = empty(input('sort')) ? " ORDER BY date DESC" : " ORDER BY " . input('sort') . " " . input('order'); $array_data['category'] = !empty(input('nob_id')) ? " AND snob.id = " . input('nob_id') . "" : ""; // start date filter if (empty(input('start_sales_date'))) { $array_data['sales_date'] = ""; } else { $array_data['sales_date'] = " AND DATE_FORMAT(s.activity_date,'%Y-%m-%d') BETWEEN '" . input('start_sales_date') . "' AND '" . input('end_sales_date') . "' "; } $array_data['company_access'] = input('company_id') ? input('company_id') : implode(",", Session::get('company_permissions')); $array_data['dealer_access'] = input('dealer_id'); $array_data['company_access'] = " AND sc.id IN (" . $array_data['company_access'] . ")"; if ($array_data['dealer_access']) { $array_data['dealer_access'] = " AND sd.id IN (" . $array_data['dealer_access'] . ")"; } $result = $this->nob->getNatureOfBusinessData($array_data); $response['rows'] = array(); $response['total'] = $this->nob->getNatureOfBusinessDataCount($array_data); // $nob_perm = Session::get('action_permissions')['5']['53']['25']; foreach ($result AS $row) { $response['rows'] = array_merge( $response['rows'], array(array( 'id' => $row['id'], 'sales_id' => $row['sales_id'], 'date' => date('F d, Y', strtotime($row['date'])), 'customer' => $row['customer'], 'mobile' => (!in_array("2", $this->nob_perm)) ? Utility::maskString($row['mobile']) : "<a href='tel:" . $row['mobile'] . "'>" . $row['mobile'] . "</a>", 'mobile_var' => $row['mobile'], 'email' => (!in_array("3", $this->nob_perm)) ? Utility::maskEmail($row['email']) : "<a href='mailto:" . $row['email'] . "'>" . $row['email'] . "</a>", 'company' => $row['company'] . ' - ' . $row['dealer'], 'nob' => $row['nob'], 'sales_id' => $row['sales_id'], 'sms' => $row['sms'] != NULL ? '<span><i class="fas fa-check-circle" style="color: green;"></i></span>' : '<span><i class="fas fa-times-circle" style="color: #b22222;"></i></span>', 'called' => $row['called'] != NULL ? '<span><i class="fas fa-check-circle" style="color: green;"></i></span>' : '<span><i class="fas fa-times-circle" style="color: #b22222;"></i></span>', 'sms_var' => $row['sms'], 'called_var' => $row['called'] )) ); } response()->json($response); } public function natureOfBusinessCategoryCount() { $array_data['company_access'] = input('company_id') ? input('company_id') : implode(",", Session::get('company_permissions')); $array_data['dealer_access'] = input('dealer_id'); $array_data['category'] = input('category'); $array_data['company_access'] = " AND sc.id IN (" . $array_data['company_access'] . ")"; if ($array_data['dealer_access']) { $array_data['dealer_access'] = " AND sd.id IN (" . $array_data['dealer_access'] . ")"; } if ($array_data['category']) { $array_data['category'] = " AND snob.id IN (" . $array_data['category'] . ")"; } if (empty(input('start_sales_date'))) { $array_data['sales_date'] = ""; } else { $array_data['sales_date'] = " AND DATE_FORMAT(s.activity_date,'%Y-%m-%d') BETWEEN '" . input('start_sales_date') . "' AND '" . input('end_sales_date') . "' "; } $response = $this->nob->getNatureOfBusinessCategoryCount($array_data); response()->json($response); } public function tableListAction() { $array_data['offset'] = input('offset'); $array_data['limit'] = input('limit'); $array_data['offset_limit'] = " LIMIT " . $array_data['offset'] . "," . $array_data['limit'] . ""; $array_data['sales_id'] = input('sales_id'); $action_list = $this->nob->tableAction($array_data); response()->json($action_list); } public function makeSmsCall() { $array_data['type'] = input('type'); $array_data['sales_id'] = input('sales_id'); $array_data['phone'] = input('phone'); $sms_call = $this->nob->smsCall($array_data); response()->json($sms_call); } public function remarks() { $array_data['remarks'] = input('remarks'); $array_data['sales_id'] = input('sales_id'); $remarks = $this->nob->remarks($array_data); response()->json($remarks); } public function loadRemarks() { $array_data['sales_id'] = input('sales_id'); $remarks = $this->nob->loadRemarks($array_data); response()->json($remarks); } }

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0.01 | proxy | phpinfo | Settings