/** * Event Method to check empty invoice date. If the due_date is empty * set this to the current date and update the $fields array * @param $evtcl -- Object */ function checkEmptyDueDate(EventControler $evtcl) { //echo $evtcl->fields["due_date"]; if ($evtcl->fields["due_date"] == '') { $fields["due_date"] = date('Y-m-d'); $evtcl->updateParam("fields", $fields); } }
function eventSetUserId(EventControler $evtcl) { $fields = $evtcl->getParam("fields"); $idcontact = $evtcl->getParam("idcontact"); $q = new sqlQuery($this->getDbCon()); //$iduser = 17; $fields["iduser"] = 0; $fields["idcontact"] = $idcontact; $evtcl->updateParam("fields", $fields); //print_r($fields); exit; }
/** * Set the company id for the contact * and create a new one if doesn't exists. * @param object EventControler */ function eventSetCompany(EventControler $event_controler) { $fields = $event_controler->getParam('fields'); $newCompany = new Company($this->getDbCon()); $newCompany->query("select * from company where name='" . trim($fields['company']) . "' and iduser = "******"\n Company id:" . $fields['idcompany'] . " for " . $fields['company']); $event_controler->updateParam("fields", $fields); return true; }
/** * Event Controller that will take the form data for the task * The due date here is a string so that string will be * converted to Mysql date format Y-m-d with cool PHP * strtotime() method * Finally the field array will be updated * with the modified data. * */ function eventSetDateInFormat(EventControler $evtcl) { $fields = $evtcl->getParam("fields"); $dutedate = $fields["due_date"]; $sp_date_sel_hidden = $_POST["sp_date_selected"]; if ($sp_date_sel_hidden == "") { if ($dutedate != 'Later') { switch ($dutedate) { case "Today": $formated_date = date("Y-m-d"); break; case "Tomorrow": $formated_date = date("Y-m-d", strtotime("+1 day")); break; case "This week": $formated_date = date("Y-m-d", strtotime("next Friday")); break; case "Next week": $formated_date = date("Y-m-d", strtotime("next Friday", strtotime("+1 week"))); break; case "This month": $formated_date = date('Y-m-d', strtotime('-1 second', strtotime('+1 month', strtotime(date('m') . '/01/' . date('Y') . ' 00:00:00')))); break; } $fields["due_date_dateformat"] = $formated_date; //print_r($fields);exit; $evtcl->updateParam("fields", $fields); } else { $fields["due_date_dateformat"] = '0000-00-00'; $evtcl->updateParam("fields", $fields); } } elseif ($sp_date_sel_hidden == "Yes") { $formated_date = $fields["due_date_dateformat"]; $today = date("Y-m-d"); if ($formated_date == '0000-00-00' || $formated_date == '' || empty($formated_date)) { $return_string = 'Later'; } else { $difference = strtotime($formated_date) - strtotime($today); $date_diff = round($difference / 60 / 60 / 24, 0); if ($date_diff < 0) { $return_string = 'Today'; } elseif ($date_diff == 0) { $return_string = 'Today'; } elseif ($date_diff == 1) { $return_string = 'Tomorrow'; } elseif ($date_diff >= 2 && $date_diff < 8) { $return_string = 'This week'; } elseif ($date_diff > 7 && $date_diff < 15) { $return_string = 'Next week'; } elseif ($date_diff > 15) { $return_string = 'Later'; } } $fields["is_sp_date_set"] = "Yes"; $fields["due_date"] = $return_string; //print_r($fields);exit; $evtcl->updateParam("fields", $fields); } }