/**
* 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);
}
}
