/**
  * public function getData(){
  * 		global $database;
  * 		$depts 			= Department::find_all();
  * 		$role			= Roles::find_all();
  * 		$country 		= Country::find_all();
  *         $vendors 		= Vendor::find_all();
  * 		$zone 			= Zone::find_by_sql("SELECT * FROM zone");
  *         $clietproducts  = Cproduct::find_all();
  * 		$startups 		= array("departs"=>$depts,"country"=>$country,"zone"=>$zone,"vendors"=>$vendors,"role"=>$role,'products'=>$clietproducts);
  * 		return $startups;		
  * 	}
  */
 public function creatworksheet()
 {
     if (!empty($_POST["prod_id"]) && !empty($_POST["w_date"])) {
         $newWorkSheet = new Worksheet();
         if (isset($_FILES['fupload']) && $_FILES['fupload']['error'] == 0) {
             //if file upload is set
             move_uploaded_file($_FILES['fupload']['tmp_name'], "public/uploads/" . basename($_FILES['fupload']['name']));
             $image = new Imageresize();
             // an instance of image resize object
             $image->load("public/uploads/" . basename($_FILES['fupload']['name']));
             //$image->image =;
             $image->resize(400, 400);
             $image->save("public/uploads/" . basename($_FILES['fupload']['name']));
             //this section is needed to get the extension for image type in renaming the image
             if ($_FILES['fupload']['type'] == "image/gif") {
                 $ext = ".gif";
             }
             if ($_FILES['fupload']['type'] == "image/png") {
                 $ext = ".png";
             }
             if ($_FILES['fupload']['type'] == "image/jpeg") {
                 $ext = ".jpeg";
             }
             if ($_FILES['fupload']['type'] == "image/pjpeg") {
                 $ext = ".jpeg";
             }
             if ($_FILES['fupload']['type'] == "image/gif") {
                 $ext = ".gif";
             }
             if ($_FILES['fupload']['type'] == "image/jpg") {
                 $ext = ".jpg";
             }
             $new_name = uniqid() . "_" . time() . $ext;
             //new name for the image
             rename("public/uploads/" . basename($_FILES['fupload']['name']), "public/uploads/" . $new_name);
             $photo = $new_name;
             $newWorkSheet->scan_url = $photo;
         } else {
             //$applicant->img_url = $_POST['imgvalue'];
         }
         $mySchedule = Schedule::find_by_id($_POST['wsid']);
         $newWorkSheet->prod_id = $_POST["prod_id"];
         $newWorkSheet->formid = $_POST['wsid'];
         $newWorkSheet->prod_name = $mySchedule->prod_name;
         $newWorkSheet->sheet_date = $_POST["w_date"];
         $newWorkSheet->time_in = $_POST["time_in"];
         $newWorkSheet->time_out = $_POST["time_out"];
         $newWorkSheet->contact_person = $_POST["contact_person"];
         $newWorkSheet->cse_emp_id = empty($_POST["emp_id"]) ? $mySchedule->emp_id : $_POST['emp_id'];
         $newWorkSheet->problem = empty($_POST["problem"]) ? $mySchedule->issue : $_POST['problem'];
         $newWorkSheet->cause = $_POST["cause"];
         $newWorkSheet->corrective_action = $_POST["corrective_action"];
         $newWorkSheet->part_changed = $_POST["part_changed"];
         $newWorkSheet->cse_remark = $_POST["cse_remark"];
         $newWorkSheet->client_remark = $_POST["client_remark"];
         $newWorkSheet->datecreated = date("Y-m-d H:i:s");
         global $session;
         if ($newWorkSheet->create()) {
             // $schedulee      =   Schedule::find_by_id($_POST["wsid"]);
             $mySchedule->status = "Closed";
             $mySchedule->datemodified = date("Y:m:d H:i:s");
             $mySchedule->update();
             $_SESSION["message"] = "<div data-alert class='alert-box success'>Record Saved <a href='#' class='close'>&times;</a></div>";
             return 1;
             //returns 1 on success
         } else {
             $_SESSION["message"] = "<div data-alert class='alert-box alert'>Unexpected Error! Record not Saved <a href='#' class='close'>&times;</a></div>";
             return 2;
             // returns 2 on insert error
         }
     } else {
         $_SESSION["message"] = "<div data-alert class='alert-box alert'>Unexpected Error! Record not Saved <a href='#' class='close'>&times;</a></div>";
         return 3;
         //returns 3 if requiered input field is not supplied
     }
 }
 public function acceptTask()
 {
     global $session;
     $newWorkSheet = new Worksheet();
     $ticket = Schedule::find_by_id($_POST['taskid']);
     if (isset($_POST['taskid'])) {
         $newWorkSheet->cse_emp_id = $_SESSION['emp_ident'];
         $newWorkSheet->formid = $_POST['taskid'];
         $newWorkSheet->prod_id = $ticket->prod_id;
         $newWorkSheet->client_id = $ticket->client_id;
         //$newWorkSheet->contact_person   =   $ticket->contact_name;
         $newWorkSheet->problem = $ticket->issue;
         $newWorkSheet->sheet_date = date("Y:m:d H:i:s");
         $newWorkSheet->datecreated = date("Y:m:d H:i:s");
         $newWorkSheet->status = "Open";
         $ticket->status = "In Progress";
         $ticket->datemodified = date("Y:m:d H:i:s");
         if ($newWorkSheet->create()) {
             $ticket->update();
             return 1;
         } else {
             return 2;
         }
     } else {
         return 3;
     }
 }