public function getStdComparator($comparator, $value, $datatype = "")
{
$return = "";
global $default_charset;
if ($comparator != "custom") {
$date_array = GenerateObj::getStandarFiltersStartAndEndDate($comparator);
} else {
$date_array = explode("<;@STDV@;>", html_entity_decode($value, ENT_QUOTES, $default_charset));
}
$s_date = $date_array[0];
$e_date = $date_array[1];
switch ($comparator) {
case "today":
case "yesterday":
case "tomorrow":
$return = " = '{$s_date}' ";
break;
case "thisweek":
case "lastweek":
case "nextweek":
case "thismonth":
case "lastmonth":
case "nextmonth":
case "next7days":
case "next15days":
case "next30days":
case "next60days":
case "next90days":
case "next120days":
case "last7days":
case "last15days":
case "last30days":
case "last60days":
case "last90days":
case "last120days":
case "thisfy":
case "prevfy":
case "nextfy":
case "nextfq":
case "prevfq":
case "thisfq":
$return = " BETWEEN '{$s_date}' AND '{$e_date}' ";
break;
case "todaymore":
$return = " > '{$s_date}' ";
break;
case "todayless":
case "older1days":
case "older7days":
case "older15days":
case "older30days":
case "older60days":
case "older90days":
case "older120days":
case "todayless":
$return = " < '{$s_date}' ";
break;
default:
$currentUser = Users_Record_Model::getCurrentUserModel();
$js_cal_dateformat = $currentUser->get('date_format');
//$js_cal_dateformat = "dd-mm-yyyy";
if ($s_date != "") {
$s_date = DateTimeField::__convertToDBFormat(trim($s_date), $js_cal_dateformat);
}
if ($e_date != "") {
$e_date = DateTimeField::__convertToDBFormat(trim($e_date), $js_cal_dateformat);
}
if ($s_date != "" && $e_date != "") {
$return = " BETWEEN '{$s_date}' AND '{$e_date}' ";
} elseif ($s_date != "") {
$return = " = '{$s_date}' ";
} elseif ($e_date != "") {
$return = " = '{$e_date}' ";
} else {
$return = "";
}
break;
}
return $return;
}
function getFilterDateHtml(Vtiger_Request $request)
{
$return_html = "";
$columnIndex = $request->get("columnIndex");
if ($columnIndex != "") {
$currentUser = Users_Record_Model::getCurrentUserModel();
$date_format = $currentUser->get('date_format');
//$date_format = "dd-mm-yyyy";
$moduleName = $request->getModule();
$record = $request->get("record");
$fop_type = $request->get("fop_type");
$reportModel = ITS4YouReports_Record_Model::getCleanInstance($record);
$rel_fields = $reportModel->getAdvRelFields();
$r_sel_fields = $request->get("r_sel_fields");
$ctype = "f";
$s_date_value = $e_date_value = "";
if ($r_sel_fields != "") {
$default_charset = vglobal("default_charset");
if ($fop_type != "custom") {
$std_val_array = GenerateObj::getStandarFiltersStartAndEndDate($fop_type);
} else {
$std_val_array = explode("<;@STDV@;>", html_entity_decode($r_sel_fields, ENT_QUOTES, $default_charset));
}
if (in_array($fop_type, array("todayless"))) {
$s_date_value = "";
if ($std_val_array[0] != "--" && $std_val_array[0] != "") {
$e_date_value = $std_val_array[0];
} else {
$e_date_value = $std_val_array[1];
}
} elseif (in_array($fop_type, array("todaymore", "older1days", "older7days", "older15days", "older30days", "older60days", "older90days", "older120days"))) {
$s_date_value = $std_val_array[0];
$e_date_value = "";
} else {
$s_date_value = $std_val_array[0];
$e_date_value = $std_val_array[1];
}
}
if ($fop_type != "custom") {
$readonly = "true";
} else {
$readonly = "false";
}
if ($s_date_value != "") {
$s_date_value_f = getValidDisplayDate($s_date_value);
}
if ($e_date_value != "") {
$e_date_value_f = getValidDisplayDate($e_date_value);
}
//'<input id="Invoice_editView_fieldName_invoicedate" class="span9 dateField" name="invoicedate" data-date-format="dd-mm-yyyy" value="21-07-2014" data-fieldinfo="{\'mandatory\':false,\'presence\':true,\'quickcreate\':false,\'masseditable\':true,\'defaultvalue\':false,\'type\':\'date\',\'name\':\'invoicedate\',\'label\':\'Invoice Date\',\'date-format\':\'dd-mm-yyyy\'}" type="text">';
$return_html .= "<div class='row-fluid'>\n <div class='span6'>\n <div class='row-fluid input-append'>\n <div id='jscal_trigger_sdate" . $columnIndex . "' class='span10 row-fluid date hide'>\n <input class='span9 dateField' name='startdate' id='jscal_field_sdate_val_" . $columnIndex . "' data-date-format='" . $date_format . "' maxlength='10' value='" . $s_date_value . "' type='text'>\n <span class='add-on'><i class='icon-calendar'></i></span> \n </div>\n <input data-value='value' class='span10' name='' id='jscal_field_sdate" . $columnIndex . "' readonly='true' value='" . $s_date_value_f . "'>\n </div>\n <!--<div class='row-fluid'>\n <font size='1'><b>" . vtranslate("LBL_SF_STARTDATE", $moduleName) . "</b></font>\n </div>-->\n </div>\n <div class='span6'>\n <div class='row-fluid input-append'>\n <div id='jscal_trigger_edate" . $columnIndex . "' class='span10 row-fluid date hide'>\n <input class='span9 dateField' name='enddate' id='jscal_field_edate_val_" . $columnIndex . "' data-date-format=" . $date_format . "' maxlength='10' value='" . $e_date_value . "' type='text'>\n <span class='add-on'><i class='icon-calendar'></i></span>\n </div>\n <input data-value='value' class='span10' name='' id='jscal_field_edate" . $columnIndex . "' readonly='true' value='" . $e_date_value_f . "'>\n </div>\n <!--<div class='row-fluid'>\n <font size='1'><b>" . vtranslate("LBL_SF_ENDDATE", $moduleName) . "</b></font>\n </div>-->\n </div>\n </div>";
/*
$return_html .= "
<table>
<tr>
<td width='20%'>
<table><tbody>
<tr>
<td style='vertical-align:top;'>
<input name='startdate' id='jscal_field_sdate$columnIndex' style='border: 1px solid rgb(186, 186, 186);' size='10' maxlength='10' value='$s_date_value' type='text'>
<img style='visibility: hidden;' src='themes/softed/images/btnL3Calendar.gif' id='jscal_trigger_sdate$columnIndex' align='absmiddle'><br>
<font size='1'><b>".vtranslate("LBL_SF_STARTDATE", $moduleName).":</b><em old='(yyyy-mm-dd)'>(dd-mm-yyyy)</em></font>
</td>
</tr>
</tbody></table>
</td>
<td width='30%'>
<table><tbody>
<tr>
<td style='vertical-align:top;'>
<input name='enddate' id='jscal_field_edate$columnIndex' style='border: 1px solid rgb(186, 186, 186);' size='10' maxlength='10' value='$e_date_value' type='text'>
<img style='visibility: hidden;' src='themes/softed/images/btnL3Calendar.gif' id='jscal_trigger_edate$columnIndex' align='absmiddle'><br>
<font size='1'><b>".vtranslate("LBL_SF_ENDDATE", $moduleName).":</b><em old='(yyyy-mm-dd)'>(dd-mm-yyyy)</em></font>
</td>
</tr>
</tbody></table>
</td>
</tr>
</table>
";*/
}
echo $return_html;
}
