/**
* This method generates the where clause part.
* @param string $fieldName
* @param string $value
* @return string
*/
public function generateWhereClausePart($fieldName, $dateRanges)
{
$fromDate = "1970-01-01";
$toDate = date("Y-m-d");
$inputDatePattern = sfContext::getInstance()->getUser()->getDateFormat();
$datepickerDateFormat = get_datepicker_date_format($inputDatePattern);
if ($dateRanges["from"] != $datepickerDateFormat && $dateRanges["to"] != $datepickerDateFormat) {
if ($dateRanges["to"] != "") {
$toDate = $dateRanges["to"];
}
if ($dateRanges["from"] != "") {
$fromDate = $dateRanges["from"];
}
} else {
if ($dateRanges["from"] == $datepickerDateFormat && $dateRanges["to"] != $datepickerDateFormat) {
if ($dateRanges["to"] != "") {
$toDate = $dateRanges["to"];
}
} else {
if ($dateRanges["from"] != $datepickerDateFormat && $dateRanges["to"] == $datepickerDateFormat) {
if ($dateRanges["from"] != "") {
$fromDate = $dateRanges["from"];
}
}
}
}
return "( " . $fieldName . " " . $this->getWhereClauseCondition() . " '" . $fromDate . "' AND '" . $toDate . "' )";
}
public function setStaticColumns($formValues)
{
$staticColumns["fromDate"] = "";
$staticColumns["toDate"] = "";
$inputDatePattern = sfContext::getInstance()->getUser()->getDateFormat();
$datepickerDateFormat = get_datepicker_date_format($inputDatePattern);
if ($formValues["project_date_range"]["from"] != $datepickerDateFormat && $formValues["project_date_range"]["to"] != $datepickerDateFormat) {
if ($formValues["project_date_range"]["from"] != '') {
$staticColumns["fromDate"] = $formValues["project_date_range"]["from"];
}
if ($formValues["project_date_range"]["to"] != '') {
$staticColumns["toDate"] = $formValues["project_date_range"]["to"];
}
} else {
if ($formValues["project_date_range"]["from"] != $datepickerDateFormat && $formValues["project_date_range"]["to"] == $datepickerDateFormat) {
if ($formValues["project_date_range"]["from"] != '') {
$staticColumns["fromDate"] = $formValues["project_date_range"]["from"];
}
} else {
if ($formValues["project_date_range"]["from"] == $datepickerDateFormat && $formValues["project_date_range"]["to"] != $datepickerDateFormat) {
if ($formValues["project_date_range"]["to"] != '') {
$staticColumns["toDate"] = $formValues["project_date_range"]["to"];
}
}
}
}
$staticColumns["projectId"] = $formValues["project_name"];
if ($formValues["only_include_approved_timesheets"] == "on") {
$staticColumns["onlyIncludeApprovedTimesheets"] = "on";
} else {
$staticColumns["onlyIncludeApprovedTimesheets"] = "off";
}
return $staticColumns;
}
/**
* @see sfValidatorBase
*/
protected function doClean($value)
{
$trimmedValue = trim($value);
$pattern = $this->getOption('date_format');
if (empty($pattern)) {
$pattern = sfContext::getInstance()->getUser()->getDateFormat();
}
$required = $this->getOption('required');
$isDefaultValue = strcasecmp(str_replace('yyyy', 'yy', $trimmedValue), get_datepicker_date_format($pattern)) == 0;
if ($trimmedValue == '' || $isDefaultValue) {
if (!$required) {
// If not required and empty or the format pattern, return valid
return null;
} else {
throw new sfValidatorError($this, 'required');
}
}
$localizationService = new LocalizationService();
$result = $localizationService->convertPHPFormatDateToISOFormatDate($pattern, $trimmedValue);
$valid = $result == "Invalid date" ? false : true;
if (!$valid) {
throw new sfValidatorError($this, 'bad_format', array('value' => $value, 'date_format' => $this->getOption('date_format_error') ? $this->getOption('date_format_error') : get_datepicker_date_format($pattern)));
}
return $result;
}
/**
* @see sfValidatorBase
*/
protected function doClean($value)
{
$from = $value["from"];
$to = $value["to"];
$inputDatePattern = sfContext::getInstance()->getUser()->getDateFormat();
$datepickerDateFormat = get_datepicker_date_format($inputDatePattern);
if ($from != $datepickerDateFormat && $to != $datepickerDateFormat) {
try {
$value["from"] = parent::doClean($value["from"]);
} catch (Exception $exc) {
try {
$value["to"] = parent::doClean($value["to"]);
} catch (Exception $exc) {
$this->setMessage('invalid', 'Insert valid "from" and "to" date');
$this->setMessage("bad_format", "From date and To date values do not match the date format " . $datepickerDateFormat);
throw $exc;
}
$this->setMessage('invalid', 'Insert a valid "from" date');
throw $exc;
}
try {
$value["to"] = parent::doClean($value["to"]);
} catch (Exception $exc) {
$this->setMessage('invalid', 'Insert a valid "to" date');
throw $exc;
}
} else {
if ($from == $datepickerDateFormat && $to != $datepickerDateFormat) {
if ($to != "") {
$value["to"] = parent::doClean($value["to"]);
$this->setMessage('invalid', 'Insert a valid "to" date');
$this->setMessage("bad_format", "To date value does not match the date format " . $datepickerDateFormat);
}
} else {
if ($from != $datepickerDateFormat && $to == $datepickerDateFormat) {
if ($from != "") {
$value["from"] = parent::doClean($value["from"]);
$this->setMessage('invalid', 'Insert a valid "from" date');
$this->setMessage("bad_format", "From date value does not match the date format " . $datepickerDateFormat);
}
} else {
if ($from == $datepickerDateFormat && $to == $datepickerDateFormat) {
return $value;
}
}
}
}
if ($value["from"] != $datepickerDateFormat && $value["to"] != $datepickerDateFormat && $value["from"] != "" && $value["to"] != "") {
$this->setMessage('invalid', 'From date should be before to date.');
$v = new ohrmValidatorSchemaDateRange("project_date_range", sfValidatorSchemaCompare::LESS_THAN_EQUAL, "project_date_range", array('throw_global_error' => true), array('invalid' => $this->getMessage('invalid')));
$v->clean($value);
}
return $value;
}
protected function configure($options = array(), $messages = array())
{
parent::configure($options, $messages);
$inputDatePattern = sfContext::getInstance()->getUser()->getDateFormat();
$this->addOption('date_format', $inputDatePattern);
$this->addOption('values', array('from', 'to'));
$this->addMessage('value1_required', __(ValidationMessages::REQUIRED));
$this->addMessage('value2_required', __(ValidationMessages::REQUIRED));
$this->addMessage('value1_value2_required', __(ValidationMessages::REQUIRED));
$this->addMessage('value1_greater_than_value2', __('Should be greater than first value'));
$this->addMessage('value1_invalid', ValidationMessages::DATE_FORMAT_INVALID);
$this->addMessage('value2_invalid', ValidationMessages::DATE_FORMAT_INVALID);
$this->addMessage('value1_and_value2_invalid', ValidationMessages::DATE_FORMAT_INVALID);
$this->messageArguments['format'] = get_datepicker_date_format($inputDatePattern);
}
/**
* @see sfValidatorBase
*/
protected function doClean($value)
{
$date = null;
$valid = false;
$trimmedValue = trim($value);
$pattern = $this->getOption('date_format');
// If not required and empty or the format pattern, return valid.
if (!$this->getOption('required') && ($trimmedValue == '' || strcasecmp(str_replace('yyyy', 'yy', $trimmedValue), get_datepicker_date_format($pattern)) == 0)) {
return null;
}
$localizationService = new LocalizationService();
$result = $localizationService->convertPHPFormatDateToISOFormatDate($pattern, $trimmedValue);
$valid = $result == "Invalid date" ? false : true;
if (!$valid) {
throw new sfValidatorError($this, 'bad_format', array('value' => $value, 'date_format' => $this->getOption('date_format_error') ? $this->getOption('date_format_error') : get_datepicker_date_format($pattern)));
}
return $result;
}
public function render($name, $value = null, $attributes = array(), $errors = array())
{
if (array_key_exists('class', $attributes)) {
$attributes['class'] .= ' ohrm_datepicker';
} else {
$attributes['class'] = 'ohrm_datepicker';
}
$html = parent::render($name, $value, $attributes, $errors);
$html .= $this->renderTag('input', array('type' => 'button', 'id' => "{$this->attributes['id']}_Button", 'class' => 'calendarBtn', 'style' => 'float: none; display: inline; margin-left: 6px;', 'value' => ''));
$javaScript = sprintf(<<<EOF
<script type="text/javascript">
var datepickerDateFormat = '%s';
var displayDateFormat = datepickerDateFormat.replace('yy', 'yyyy');
\$(document).ready(function(){
var rDate = trim(\$("#%s").val());
if (rDate == '') {
\$("#%s").val(displayDateFormat);
}
//Bind date picker
daymarker.bindElement("#%s",
{
onSelect: function(date){
},
dateFormat : datepickerDateFormat,
onClose: function(){
\$(this).valid();
}
});
\$('#%s_Button').click(function(){
daymarker.show("#%s");
});
});
</script>
EOF
, get_datepicker_date_format(sfContext::getInstance()->getUser()->getDateFormat()), $this->attributes['id'], $this->attributes['id'], $this->attributes['id'], $this->attributes['id'], $this->attributes['id']);
return $html . $javaScript;
}
</div>
</div>
<script type="text/javascript">
var datepickerDateFormat = '<?php
echo get_datepicker_date_format($sf_user->getDateFormat());
?>
';
var displayDateFormat = '<?php
echo str_replace('yy', 'yyyy', get_datepicker_date_format($sf_user->getDateFormat()));
?>
';
var errorForInvalidFormat='<?php
echo __(ValidationMessages::DATE_FORMAT_INVALID, array('%format%' => str_replace('yy', 'yyyy', get_datepicker_date_format($sf_user->getDateFormat()))));
?>
';
var errorMsge;
var linkForGetRecords='<?php
echo url_for('attendance/getRelatedAttendanceRecords');
?>
';
var employeeId='<?php
echo $employeeId;
?>
';
var actionRecorder='<?php
echo $actionRecorder;
?>
';
";
var lang_majorMaxLength = "<?php
echo __(ValidationMessages::TEXT_LENGTH_EXCEEDS, array('%amount%' => 100));
?>
";
var lang_gpaMaxLength = "<?php
echo __(ValidationMessages::TEXT_LENGTH_EXCEEDS, array('%amount%' => 25));
?>
";
var lang_yearShouldBeNumber = "<?php
echo __('Should be a number');
?>
";
var datepickerDateFormat = '<?php
echo get_datepicker_date_format($sf_user->getDateFormat());
?>
';
//]]>
</script>
<script type="text/javascript">
//<![CDATA[
var startDate = "";
$(document).ready(function() {
//hide add section
$("#changeEducation").hide();
$("#educationRequiredNote").hide();
//hiding the data table if records are not available
<?php
$inputDatePattern = sfContext::getInstance()->getUser()->getDateFormat();
$datepickerDateFormat = get_datepicker_date_format($inputDatePattern);
?>
<table>
<tr><td style="width: 80px;"><?php
echo " " . __("Project Name") . "";
?>
</td><td><?php
echo $projectName;
?>
</td></tr>
<?php
if (!($projectDateRangeFrom == $datepickerDateFormat || $projectDateRangeFrom == "")) {
?>
<tr><td style="width: 80px;"><?php
echo " " . __("From") . " ";
?>
</td><td><?php
echo set_datepicker_date_format($projectDateRangeFrom);
?>
</td></tr><?php
}
if (!($projectDateRangeTo == $datepickerDateFormat || $projectDateRangeTo == "")) {
?>
<tr><td style="width: 80px;"><?php
echo " " . __("To") . " ";
?>
</td><td><?php
public function render($name, $value = null, $attributes = array(), $errors = array())
{
$values = array_merge(array('from' => '', 'to' => '', 'comparision' => ''), is_array($value) ? $value : array());
$html = strtr($this->translate($this->getOption('template')), array('%comparision%' => $this->getOption($this->attributes['id'] . '_' . 'comparision')->render($name . '[comparision]', $values['comparision'], array('id' => $this->attributes['id'] . '_' . 'comparision')), '%from%' => $this->getOption($this->attributes['id'] . '_' . 'from')->render($name . '[from]', $values['from'], array('id' => $this->attributes['id'] . '_' . 'from')), '%to%' => $this->getOption($this->attributes['id'] . '_' . 'to')->render($name . '[to]', $values['to'], array('id' => $this->attributes['id'] . '_' . 'to'))));
$javaScript = $javaScript = sprintf(<<<EOF
<script type="text/javascript">
\$(document).ready(function() {
var idValue = '%s';
var joinedDateFormat = '%s';
if(\$('#' + idValue + '_comparision').val() == ''){
\$('#' + idValue + '_from').hide().val('');
\$('#' + idValue + '_to').hide().val('');
\$('#' + idValue + '_from_Button').hide();
\$('#' + idValue + '_to_Button').hide();
}
\$('#' + idValue + '_comparision').change(function(){
if(\$('#' + idValue + '_comparision').val() == ''){
\$('#' + idValue + '_from').hide().val('');
\$('#' + idValue + '_from_Button').hide();
\$('#' + idValue + '_to_Button').hide();
\$('#' + idValue + '_to').hide().val('');
}else if(\$('#' + idValue + '_comparision').val() == '1'){
\$('#' + idValue + '_from').show();
\$('#' + idValue + '_to').hide().val('');
\$('#' + idValue + '_from_Button').show().css('display', 'inline');
\$('#' + idValue + '_to_Button').hide();
}else if(\$('#' + idValue + '_comparision').val() == '2'){
\$('#' + idValue + '_from').show();
\$('#' + idValue + '_to').hide().val('');
\$('#' + idValue + '_from_Button').show().css('display', 'inline');
\$('#' + idValue + '_to_Button').hide();
}else if(\$('#' + idValue + '_comparision').val() == '3'){
\$('#' + idValue + '_from').show();
\$('#' + idValue + '_to').show();
\$('#' + idValue + '_from_Button').show().css('display', 'inline');
\$('#' + idValue + '_to_Button').show().css('display', 'inline');
}
if (\$('#' + idValue + '_from').is(":visible")) {
if (\$('#' + idValue + '_from').val() == '') {
\$('#' + idValue + '_from').val(joinedDateFormat);
}
}
if (\$('#' + idValue + '_to').is(":visible")) {
if (\$('#' + idValue + '_to').val() == '') {
\$('#' + idValue + '_to').val(joinedDateFormat);
}
}
});
\$('#' + idValue + '_comparision').trigger('change');
});
</script>
EOF
, $this->attributes['id'], get_datepicker_date_format(sfContext::getInstance()->getUser()->getDateFormat()));
return $html . $javaScript;
}
/**
*
* @return array
*/
protected function getFormValidators()
{
$validators = array();
$inputDatePattern = sfContext::getInstance()->getUser()->getDateFormat();
$validators['id'] = new sfValidatorString(array('required' => false));
$validators['recurring'] = new sfValidatorString(array('required' => false));
$validators['description'] = new sfValidatorString(array('required' => true, 'max_length' => 200), array('required' => 'Holiday Name is required', 'max_length' => 'Name of Holiday length exceeded'));
$validators['date'] = new ohrmDateValidator(array('date_format' => $inputDatePattern, 'required' => true), array('required' => 'Date field is required', 'bad_format' => __(ValidationMessages::DATE_FORMAT_INVALID, array('%format%' => get_datepicker_date_format(sfContext::getInstance()->getUser()->getDateFormat())))));
$validators['length'] = new sfValidatorChoice(array('choices' => array_keys($this->getDaysLengthList())));
return $validators;
}
?>
';
var errorForInvalidFormat="<?php
echo __('Should Be a Valid Time in %format% Format', array('%format%' => 'HH:MM'));
?>
";
var errorForInvalidTimeFormat="<?php
echo __('Should Be a Valid Time in %format% Format', array('%format%' => 'HH:MM'));
?>
";
var getCurrentTimeLink='<?php
echo url_for('attendance/getCurrentTime');
?>
';
var errorForInvalidDateFormat='<?php
echo __('Should Be a Valid Date in %format% Format', array('%format%' => get_datepicker_date_format($sf_user->getDateFormat())));
?>
';
var errorForOverLappingTime="<?php
echo __('Overlapping Records Found');
?>
";
var errorForInvalidNote='<?php
echo __(ValidationMessages::TEXT_LENGTH_EXCEEDS, array('%amount%' => 250));
?>
';
var actionPunchIn='<?php
echo $actionPunchIn;
?>
';
public function render($name, $value = null, $attributes = array(), $errors = array())
{
if (array_key_exists('class', $attributes)) {
$attributes['class'] .= ' calendar';
} else {
$attributes['class'] = 'calendar';
}
if (!isset($attributes['id']) && isset($this->attributes['id'])) {
$attributes['id'] = $this->attributes['id'];
}
$html = parent::render($name, $value, $attributes, $errors);
$javaScript = sprintf(<<<EOF
<script type="text/javascript">
var datepickerDateFormat = '%s';
var displayDateFormat = datepickerDateFormat.replace('yy', 'yyyy');
\$(document).ready(function(){
var dateFieldValue = \$.trim(\$("#%s").val());
if (dateFieldValue == '') {
\$("#%s").val(displayDateFormat);
}
daymarker.bindElement("#%s",
{
showOn: "both",
dateFormat: datepickerDateFormat,
buttonImage: "%s",
buttonText:"",
buttonImageOnly: true,
changeMonth: true,
changeYear: true,
yearRange: "-100:+100",
firstDay: 1,
onClose: function() {
\$("#%s").trigger('blur');
}
});
//\$("img.ui-datepicker-trigger").addClass("editable");
\$("#%s").click(function(){
daymarker.show("#%s");
if (\$(this).val() == displayDateFormat) {
\$(this).val('');
}
});
});
</script>
EOF
, get_datepicker_date_format(sfContext::getInstance()->getUser()->getDateFormat()), $this->attributes['id'], $this->attributes['id'], $this->attributes['id'], theme_path('images/calendar.png'), $this->attributes['id'], $this->attributes['id'], $this->attributes['id']);
return $html . $javaScript;
}