Exemple #1
0
 public function ticket_type()
 {
     $md = Masterdata::where('id', '=', $this->ticket_type_id)->get()->first();
     if (!is_null($md)) {
         return $md->name;
     }
 }
 public function run()
 {
     //////////////////////////////////////////////////////////////////////////////////
     // new row should be added at the bottom. do no insert in between ///////////
     ///////////////////////////////////////////////////////////////////////////////
     DB::table('lat_long_area')->truncate();
     LatLongDetails::create(array('area' => 'Sholinganallur', 'lat' => 12.894712, 'long' => 80.230402));
     LatLongDetails::create(array('area' => 'Karapakam', 'lat' => 12.918059, 'long' => 80.229844));
     LatLongDetails::create(array('area' => 'Navallur', 'lat' => 12.847677, 'long' => 80.224925));
     LatLongDetails::create(array('area' => 'Kumaran Nagar', 'lat' => 12.876499, 'long' => 80.22698));
     LatLongDetails::create(array('area' => 'Chemencherry', 'lat' => 12.858658, 'long' => 80.23048799999999));
     LatLongDetails::create(array('area' => 'Ogiyyam Thoraipakkam', 'lat' => 12.945899, 'long' => 80.23936999999999));
     LatLongDetails::create(array('area' => 'Mettukuppam', 'lat' => 12.939925, 'long' => 80.23596000000001));
     LatLongDetails::create(array('area' => 'PTC', 'lat' => 12.933609, 'long' => 80.232879));
     LatLongDetails::create(array('area' => 'Thoraipakkam', 'lat' => 12.951943, 'long' => 80.241434));
     LatLongDetails::create(array('area' => 'Perungudi', 'lat' => 12.968241, 'long' => 80.241984));
     LatLongDetails::create(array('area' => 'Neelankarai', 'lat' => 12.948612, 'long' => 80.254546));
     LatLongDetails::create(array('area' => 'kottivakkam', 'lat' => 12.969478, 'long' => 80.258962));
     LatLongDetails::create(array('area' => 'thiruvanmayur', 'lat' => 12.983187, 'long' => 80.25997599999999));
     LatLongDetails::create(array('area' => 'adayar', 'lat' => 13.006565, 'long' => 80.25748299999999));
     LatLongDetails::create(array('area' => 'Besant Nagar', 'lat' => 12.999359, 'long' => 80.26797999999999));
     LatLongDetails::create(array('area' => 'pallavakkam', 'lat' => 12.962583, 'long' => 80.256863));
     LatLongDetails::create(array('area' => 'Medavakkam', 'lat' => 12.920203, 'long' => 80.186015));
     LatLongDetails::create(array('area' => 'Perumbakkam', 'lat' => 12.898582, 'long' => 80.199358));
     Masterdata::create(array('name' => 'Incident', 'type' => 'Complaint', 'active' => 1));
 }
 public function viewStatus($id)
 {
     $name = Masterdata::where('id', '=', $id)->get()->first();
     if (!is_null($name)) {
         return $name->name;
     }
 }
 public static function statusSanityCheck($customer_id)
 {
     $message = "";
     $status_list = CustomerApplicationStatus::where('customer_id', '=', $customer_id)->where('done', '=', 1)->get();
     foreach ($status_list as $key => $current_status) {
         if ($current_status->statusName() == "fiber") {
             //check for splicing
             $splicing_check = CustomerApplicationStatus::where('customer_id', '=', $customer_id)->where('status_id', '=', Masterdata::getId("splicing", "customer_activation_process"))->first();
             if (!$splicing_check->done) {
                 $current_status->done = 0;
                 $current_status->save();
                 $message .= "Splicing Should be Done before proceed to Fiber!! ";
             }
         }
         //check the rest of the status and add the condition
         if ($current_status->statusName() == "configuration") {
             //check for all status the is done
             $all_status = CustomerApplicationStatus::where('customer_id', '=', $customer_id)->lists('done');
             if (in_array("0", $all_status)) {
                 $current_status->done = 0;
                 $current_status->save();
                 $message .= "All the steps has to be Done before proceed to configuration!! ";
             }
         }
     }
     if (empty($message)) {
         return array('status' => true);
     } else {
         return array('status' => false, 'message' => $message);
     }
 }
 public static function getId($name, $type)
 {
     $id = Masterdata::where('name', '=', $name)->where('type', '=', $type)->first();
     if (!is_null($id)) {
         return $id->id;
     } else {
         return null;
     }
 }
 public function ticket($thread_id)
 {
     $data['ticket_type'] = Masterdata::where('type', '=', 'ticket_type')->get();
     $data['team_type'] = Masterdata::where('type', '=', 'customer_activation_process')->get();
     $data['complaints'] = Masterdata::where('type', '=', 'complaint')->get();
     $data['list'] = MailSupport::where('thread_id', $thread_id)->orderBy('time', 'ASC')->get()->first();
     $data['mails'] = MailSupport::where('thread_id', $thread_id)->orderBy('time', 'ASC')->get();
     $data['team_list'] = Masterdata::where('type', '=', 'customer_activation_process')->get();
     //return View::make('support.mailSupport.ticket', $data);
     return View::make('support.mailSupport.ticket1', $data);
 }
 public function run()
 {
     //////////////////////////////////////////////////////////////////////////////////
     // new row should be added at the bottom. do no insert in between ///////////
     ///////////////////////////////////////////////////////////////////////////////
     DB::table('master_data')->truncate();
     Masterdata::create(array('name' => 'New Connection', 'type' => 'ticket_type', 'active' => 1));
     Masterdata::create(array('name' => 'Complaint', 'type' => 'ticket_type', 'active' => 1));
     Masterdata::create(array('name' => 'Open', 'type' => 'ticket_status', 'active' => 1));
     Masterdata::create(array('name' => 'Closed', 'type' => 'ticket_status', 'active' => 1));
     Masterdata::create(array('name' => 'Processing', 'type' => 'ticket_status', 'active' => 1));
     Masterdata::create(array('name' => 'Invalid', 'type' => 'ticket_status', 'active' => 1));
     Masterdata::create(array('name' => 'Trash', 'type' => 'ticket_status', 'active' => 1));
     Masterdata::create(array('name' => 'Urgent', 'type' => 'ticket_priority', 'active' => 1));
     Masterdata::create(array('name' => 'High', 'type' => 'ticket_priority', 'active' => 1));
     Masterdata::create(array('name' => 'Medium', 'type' => 'ticket_priority', 'active' => 1));
     Masterdata::create(array('name' => 'Low', 'type' => 'ticket_priority', 'active' => 1));
     Masterdata::create(array('name' => 'Chennai', 'type' => 'city', 'active' => 1));
     Masterdata::create(array('name' => 'OFAPL', 'type' => 'document_type', 'active' => 1));
     Masterdata::create(array('name' => 'OFPHO', 'type' => 'document_type', 'active' => 1));
     Masterdata::create(array('name' => 'OFPOI', 'type' => 'document_type', 'active' => 1));
     Masterdata::create(array('name' => 'OFPOA', 'type' => 'document_type', 'active' => 1));
     Masterdata::create(array('name' => 'fiber', 'type' => 'customer_activation_process', 'active' => 1));
     Masterdata::create(array('name' => 'splicing', 'type' => 'customer_activation_process', 'active' => 1));
     Masterdata::create(array('name' => 'ethernet', 'type' => 'customer_activation_process', 'active' => 1));
     Masterdata::create(array('name' => 'HUT boxes', 'type' => 'customer_activation_process', 'active' => 1));
     Masterdata::create(array('name' => 'configuration', 'type' => 'customer_activation_process', 'active' => 1));
     Masterdata::create(array('name' => 'Sholinganaloor', 'type' => 'area', 'active' => 1));
     Masterdata::create(array('name' => 'Karapakam', 'type' => 'area', 'active' => 1));
     Masterdata::create(array('name' => 'Navallur', 'type' => 'area', 'active' => 1));
     Masterdata::create(array('name' => 'Kumaran nager', 'type' => 'area', 'active' => 1));
     Masterdata::create(array('name' => 'Chemencherry', 'type' => 'area', 'active' => 1));
     Masterdata::create(array('name' => 'NewConnections Pre Request', 'type' => 'ticket_type', 'active' => 1));
     Masterdata::create(array('name' => 'Technical Complaint', 'type' => 'Complaint', 'active' => 1));
     Masterdata::create(array('name' => 'Billing Complaint', 'type' => 'Complaint', 'active' => 1));
 }
 public function ticket_type()
 {
     $md = Masterdata::where('type', '=', 'customer_activation_process')->get();
     return $md;
 }
Exemple #9
0
 public function statuslist()
 {
     $statuslist = Masterdata::where('type', '=', 'ticket_status')->get();
     return $statuslist;
 }