public function getDatesBetween($dStart, $dEnd)
{
if ($dStart > $dEnd) {
$var = $dStart;
$dStart = $dEnd;
$dEnd = $var;
}
$iStart = strtotime($dStart);
$iEnd = strtotime($dEnd);
if (false === $iStart || false === $iEnd) {
return false;
}
$aStart = explode('-', $dStart);
$aEnd = explode('-', $dEnd);
if (count($aStart) !== 3 || count($aEnd) !== 3) {
return false;
}
if (false === checkdate($aStart[1], $aStart[2], $aStart[0]) || false === checkdate($aEnd[1], $aEnd[2], $aEnd[0]) || $iEnd < $iStart) {
return false;
}
for ($i = $iStart; $i < $iEnd + 86400; $i = strtotime('+1 day', $i)) {
$sDateToArr = strftime('%Y-%m-%d', $i);
$sYear = substr($sDateToArr, 0, 4);
$sMonth = substr($sDateToArr, 5, 2);
//$aDates[$sYear][$sMonth][]=$sDateToArr;
$aDates[] = $sDateToArr;
}
if (isset($aDates) && !empty($aDates)) {
return $aDates;
} else {
return false;
}
}
function get_pasien_check($val) {
$val[tgl_periksa_tgl_start] = empty($val[tgl_periksa_tgl_start])?1:$val[tgl_periksa_tgl_start];
$val[tgl_periksa_bln_start] = empty($val[tgl_periksa_bln_start])?1:$val[tgl_periksa_bln_start];
$val[tgl_periksa_tgl_end] = empty($val[tgl_periksa_tgl_end])?1:$val[tgl_periksa_tgl_end];
$val[tgl_periksa_bln_end] = empty($val[tgl_periksa_bln_end])?1:$val[tgl_periksa_bln_end];
$objResponse = new xajaxResponse;
$tgl_start = strtotime($val[tgl_periksa_thn_start] . "-" . $val[tgl_periksa_bln_start] . "-" . $val[tgl_periksa_tgl_start]);
$tgl_end = strtotime($val[tgl_periksa_thn_end] . "-" . $val[tgl_periksa_bln_end] . "-" . $val[tgl_periksa_tgl_end]);
if(!checkdate($val[tgl_periksa_bln_start], $val[tgl_periksa_tgl_start], $val[tgl_periksa_thn_start])) {
$objResponse->addAlert("Tanggal Awal Tidak Valid");
$objResponse->addScriptCall("fokus", "tgl_periksa_tgl_start");
} elseif(!checkdate($val[tgl_periksa_bln_end], $val[tgl_periksa_tgl_end], $val[tgl_periksa_thn_end])) {
$objResponse->addAlert("Tanggal Akhir Tidak Valid");
$objResponse->addScriptCall("fokus", "tgl_periksa_tgl_start");
} elseif($tgl_start > $tgl_end) {
$objResponse->addAlert("Tanggal Awal Harus Kurang Dari Tanggal Akhir");
$objResponse->addScriptCall("fokus", "tgl_periksa_tgl_start");
} else {
$objResponse->addScriptCall("xajax_get_pasien", $val);
}
return $objResponse;
}
function printStk($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($fday, "num", 1, 2, "Invalid from Date day.");
$v->isOk($fmon, "num", 1, 2, "Invalid from Date month.");
$v->isOk($fyear, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($today, "num", 1, 2, "Invalid to Date day.");
$v->isOk($tomon, "num", 1, 2, "Invalid to Date month.");
$v->isOk($toyear, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $fyear . "-" . $fmon . "-" . $fday;
$todate = $toyear . "-" . $tomon . "-" . $today;
if (!checkdate($fmon, $fday, $fyear)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($tomon, $today, $toyear)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class=err>-" . $e["msg"] . "<br>";
}
return $confirm;
}
# connect to database
db_connect();
// Layout
$report = "\n\t<h3>Non-Stock Sales Report</h3>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n <tr><th>Invoice no.</th><th>Date</th><th>Vat</th><th>SubTotal</th><th>Total</th></tr>";
# Get all relevant records
db_connect();
$sql = "SELECT * FROM salesrec WHERE edate >= '{$fromdate}' AND edate <= '{$todate}' AND typ = 'non' AND div = '" . USER_DIV . "'";
$recRslt = db_exec($sql) or errDie("Unable to access databse.", SELF);
$i = 0;
$tot = 0;
$totvat = 0;
$totexc = 0;
while ($rec = pg_fetch_array($recRslt)) {
# Calculate profit
$tot += $rec['total'];
$totvat += $rec['vat'];
$excvat = sprint($rec['total'] - $rec['vat']);
$totexc += $excvat;
$report .= "<tr class='" . bg_class() . "'><td>{$rec['invnum']}</td><td>{$rec['edate']}</td><td>" . CUR . " {$rec['vat']}</td><td>" . CUR . " {$excvat}</td><td>" . CUR . " {$rec['total']}</td></tr>";
$i++;
}
$tot = sprint($tot);
$totvat = sprint($totvat);
$totexc = sprint($totexc);
$report .= "<tr class='bg-even'><td colspan=2><b>Totals</b></td><td>" . CUR . " {$totvat}</td><td>" . CUR . " {$totexc}</td><td>" . CUR . " {$tot}</td></tr>\n\t</table>\n <p>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width=15%>\n <tr><td><br></td></tr>\n <tr><th>Quick Links</th></tr>\n\t\t<tr class='bg-odd'><td><a href='sales-reports.php'>Sales Reports</a></td></tr>\n\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t</table>";
return $report;
}
function process_date_time(&$d, $field, $type = "")
{
$month = $d["{$field}" . "_month"];
$day = $d["{$field}" . "_day"];
$year = $d["{$field}" . "_year"];
$hour = $d["{$field}" . "_hour"];
$minute = $d["{$field}" . "_minute"];
$use = $d["{$field}" . "_use"];
$valid = true;
/* If user unchecked "Use date and time" then time = 0 */
if (!$use) {
$d[$field] = 0;
return true;
}
if (!checkdate($month, $day, $year)) {
$d["error"] .= "ERROR: {$type} date is invalid.";
$valid = false;
}
if (!$hour and !$minute) {
$hour = 0;
$minute = 0;
} elseif ($hour < 0 or $hour > 23 or $minute < 0 or $minute > 59) {
$d["error"] .= "ERROR: {$type} time is invalid.";
$valid = false;
}
if ($valid) {
$d[$field] = mktime($hour, $minute, 0, $month, $day, $year);
}
return $valid;
}
public function isValid()
{
if ($this->year < 0 || $this->year > 9999)
return false;
return checkdate($this->month, $this->day, $this->year);
}
/**
* Validate a date.
*
* <code>
* $date = "01-01-2020";
*
* $validator = new Prism\Validator\Date($date);
*
* if (!$validator->isValid()) {
* ...
* }
*
* </code>
*
* @return bool
*/
public function isValid()
{
// Check for default SQL values.
$defaultDates = array('0000-00-00', '1000-01-01');
if (in_array($this->date, $defaultDates, true)) {
return false;
}
$string = trim($this->date);
if ($string === '') {
return false;
}
if (is_numeric($string)) {
$string = (int) $string;
if ($string === 0) {
return false;
}
$string = '@' . $string;
}
try {
$date = new \DateTime($string);
} catch (\Exception $e) {
return false;
}
$month = $date->format('m');
$day = $date->format('d');
$year = $date->format('Y');
if (checkdate($month, $day, $year)) {
return true;
} else {
return false;
}
}
function VerifyTransactionDate($TranDate, $i, $Errors, $db)
{
$sql = "SELECT confvalue FROM config WHERE confname='" . DefaultDateFormat . "'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_array($result);
$DateFormat = $myrow[0];
if (mb_strpos($TranDate, '/') > 0) {
$DateArray = explode('/', $TranDate);
} elseif (mb_strpos($TranDate, '.') > 0) {
$DateArray = explode('.', $TranDate);
}
if ($DateFormat == 'd/m/Y') {
$Day = $DateArray[0];
$Month = $DateArray[1];
$Year = $DateArray[2];
} elseif ($DateFormat == 'm/d/Y') {
$Day = $DateArray[1];
$Month = $DateArray[0];
$Year = $DateArray[2];
} elseif ($DateFormat == 'Y/m/d') {
$Day = $DateArray[2];
$Month = $DateArray[1];
$Year = $DateArray[0];
} elseif ($DateFormat == 'd.m.Y') {
$Day = $DateArray[0];
$Month = $DateArray[1];
$Year = $DateArray[2];
}
if (!checkdate(intval($Month), intval($Day), intval($Year))) {
$Errors[$i] = InvalidCurCostDate;
}
return $Errors;
}
function cektgl($tanggal)
{
$tgl = substr($tanggal, 0, 2);
$bln = substr($tanggal, 3, 2);
$thn = substr($tanggal, 6, 4);
return checkdate($bln, $tgl, $thn);
}
/**
* {@inheritdoc}
*/
public function reverseTransform($rfc3339)
{
if (!is_string($rfc3339)) {
throw new TransformationFailedException('Expected a string.');
}
if ('' === $rfc3339) {
return;
}
try {
$dateTime = new \DateTime($rfc3339);
} catch (\Exception $e) {
throw new TransformationFailedException($e->getMessage(), $e->getCode(), $e);
}
if ($this->outputTimezone !== $dateTime->getTimezone()->getName()) {
try {
$dateTime->setTimezone(new \DateTimeZone($this->inputTimezone));
} catch (\Exception $e) {
throw new TransformationFailedException($e->getMessage(), $e->getCode(), $e);
}
}
if (preg_match('/(\\d{4})-(\\d{2})-(\\d{2})/', $rfc3339, $matches)) {
if (!checkdate($matches[2], $matches[3], $matches[1])) {
throw new TransformationFailedException(sprintf('The date "%s-%s-%s" is not a valid date.', $matches[1], $matches[2], $matches[3]));
}
}
return $dateTime;
}
public function save(Gyuser_Model_BankAccounts $bank)
{
if (trim($bank->getOpening_date()) == '') {
$opening_date = null;
} else {
$dateArr = explode('/', $bank->getOpening_date());
if (checkdate($dateArr[1], $dateArr[0], $dateArr[2])) {
$stampeddate = mktime(12, 0, 0, $dateArr[1], $dateArr[0], $dateArr[2]);
$opening_date = date("Y-m-d", $stampeddate);
} elseif (checkdate($dateArr[0], '01', $dateArr[1])) {
//in case they have entered only month and year format ex: 02/1993
$stampeddate = mktime(12, 0, 0, $dateArr[0], '01', $dateArr[1]);
$opening_date = date("Y-m-d", $stampeddate);
} else {
throw Exception('The bank opening date is invalid.');
}
}
$data = array("user_id" => $bank->getUser_id(), "bank_name" => $bank->getBank_name(), "account_n" => $bank->getAccount_n(), "branch" => $bank->getBranch(), "opening_date" => $opening_date, "zip_code" => $bank->getZip_code(), "location_capital" => $bank->getLocation_capital());
if (null === ($id = $bank->getId())) {
unset($data['id']);
$id = $this->getDbTable()->insert($data);
return $id;
} else {
unset($data['user_id']);
$id = $this->getDbTable()->update($data, array('id = ?' => $id));
return $id;
}
}
private function validDate()
{
if (checkdate($this->month, $this->day, $this->year)) {
return true;
}
return false;
}
function is_date($value, $format = 'dd.mm.yyyy')
{
if (strlen($value) >= 6 && strlen($format) == 10) {
// find separator. Remove all other characters from $format
$separator_only = str_replace(array('m', 'd', 'y'), '', $format);
$separator = $separator_only[0];
// separator is first character
if ($separator && strlen($separator_only) == 2) {
// make regex
$regexp = str_replace('mm', '(0?[1-9]|1[0-2])', $format);
$regexp = str_replace('dd', '(0?[1-9]|[1-2][0-9]|3[0-1])', $regexp);
$regexp = str_replace('yyyy', '(19|20)?[0-9][0-9]', $regexp);
$regexp = str_replace($separator, "\\" . $separator, $regexp);
if ($regexp != $value && preg_match('/' . $regexp . '\\z/', $value)) {
// check date
$arr = explode($separator, $value);
$day = $arr[0];
$month = $arr[1];
$year = $arr[2];
if (@checkdate($month, $day, $year)) {
return true;
}
}
}
}
return false;
}
/**
* {@inheritDoc}
*/
public function validate($value)
{
if (!preg_match('!(\\d+)-(\\d+)-(\\d+)!', $value, $matches)) {
return false;
}
return checkdate($matches[2], $matches[3], $matches[1]);
}
/**
* Will check if input date in format YYYY-MM-DD is valid.
*
* @param string $input Date string in format YYYY-MM-DD
* @return boolean TRUE if date is valid
*/
public static function isDate($input)
{
// split input date into params
list($year, $month, $day) = preg_split('/[-\\.\\/ ]/', $input);
// check date using builtin function
return checkdate($month, $day, $year);
}
public function isValid($value)
{
if (!is_string($value) && !is_int($value) && !is_float($value) && !is_array($value) && !$value instanceof Zend_Date) {
$this->_error(self::INVALID);
return false;
}
$this->_setValue($value);
if ($this->_format !== null || $this->_locale !== null || is_array($value) || $value instanceof Zend_Date) {
if (!Date::isDate($value, $this->_format, $this->_locale)) {
if ($this->_checkFormat($value) === false) {
$this->_error(self::FALSEFORMAT);
} else {
$this->_error(self::INVALID_DATE);
}
return false;
}
} else {
if (!preg_match('/^\\d{4}-\\d{2}-\\d{2}$/', $value)) {
$this->_format = 'yyyy-MM-dd';
$this->_error(self::FALSEFORMAT);
$this->_format = null;
return false;
}
list($year, $month, $day) = sscanf($value, '%d-%d-%d');
if (!checkdate($month, $day, $year)) {
$this->_error(self::INVALID_DATE);
return false;
} else {
}
}
return true;
}
function is_gregorian_date($date)
{
$year = substr($date, 0, 4);
$month = substr($date, 5, 2);
$day = substr($date, 8, 2);
return checkdate($month, $day, $year);
}
/**
*
* Validate a date
*
* @param string $date
* @param string format
* @return bool
*
*/
function validateDate($date, $format = 'YYYY-MM-DD')
{
switch ($format) {
case 'YYYY/MM/DD':
case 'YYYY-MM-DD':
list($y, $m, $d) = preg_split('/[-\\.\\/ ]/', $date);
break;
case 'YYYY/DD/MM':
case 'YYYY-DD-MM':
list($y, $d, $m) = preg_split('/[-\\.\\/ ]/', $date);
break;
case 'DD-MM-YYYY':
case 'DD/MM/YYYY':
list($d, $m, $y) = preg_split('/[-\\.\\/ ]/', $date);
break;
case 'MM-DD-YYYY':
case 'MM/DD/YYYY':
list($m, $d, $y) = preg_split('/[-\\.\\/ ]/', $date);
break;
case 'YYYYMMDD':
$y = substr($date, 0, 4);
$m = substr($date, 4, 2);
$d = substr($date, 6, 2);
break;
case 'YYYYDDMM':
$y = substr($date, 0, 4);
$d = substr($date, 4, 2);
$m = substr($date, 6, 2);
break;
default:
throw new Exception("Formato de data inválido");
}
return @checkdate($m, $d, $y);
}
public static function execute(ApplicationAbstract $application)
{
$OSCOM_MessageStack = Registry::get('MessageStack');
$data = array();
if (DISPLAY_PRIVACY_CONDITIONS == '1') {
if (isset($_POST['privacy_conditions']) === false || isset($_POST['privacy_conditions']) && $_POST['privacy_conditions'] != '1') {
$OSCOM_MessageStack->add('Create', OSCOM::getDef('error_privacy_statement_not_accepted'));
}
}
if (ACCOUNT_GENDER >= 0) {
if (isset($_POST['gender']) && ($_POST['gender'] == 'm' || $_POST['gender'] == 'f')) {
$data['gender'] = $_POST['gender'];
} else {
$OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_gender_error'));
}
}
if (isset($_POST['firstname']) && strlen(trim($_POST['firstname'])) >= ACCOUNT_FIRST_NAME) {
$data['firstname'] = $_POST['firstname'];
} else {
$OSCOM_MessageStack->add('Create', sprintf(OSCOM::getDef('field_customer_first_name_error'), ACCOUNT_FIRST_NAME));
}
if (isset($_POST['lastname']) && strlen(trim($_POST['lastname'])) >= ACCOUNT_LAST_NAME) {
$data['lastname'] = $_POST['lastname'];
} else {
$OSCOM_MessageStack->add('Create', sprintf(OSCOM::getDef('field_customer_last_name_error'), ACCOUNT_LAST_NAME));
}
if (ACCOUNT_DATE_OF_BIRTH == '1') {
if (isset($_POST['dob_days']) && isset($_POST['dob_months']) && isset($_POST['dob_years']) && checkdate($_POST['dob_months'], $_POST['dob_days'], $_POST['dob_years'])) {
$data['dob'] = mktime(0, 0, 0, $_POST['dob_months'], $_POST['dob_days'], $_POST['dob_years']);
} else {
$OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_date_of_birth_error'));
}
}
if (isset($_POST['email_address']) && strlen(trim($_POST['email_address'])) >= ACCOUNT_EMAIL_ADDRESS) {
if (filter_var($_POST['email_address'], FILTER_VALIDATE_EMAIL)) {
if (Account::checkEntry($_POST['email_address']) === false) {
$data['email_address'] = $_POST['email_address'];
} else {
$OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_email_address_exists_error'));
}
} else {
$OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_email_address_check_error'));
}
} else {
$OSCOM_MessageStack->add('Create', sprintf(OSCOM::getDef('field_customer_email_address_error'), ACCOUNT_EMAIL_ADDRESS));
}
if (isset($_POST['password']) === false || isset($_POST['password']) && strlen(trim($_POST['password'])) < ACCOUNT_PASSWORD) {
$OSCOM_MessageStack->add('Create', sprintf(OSCOM::getDef('field_customer_password_error'), ACCOUNT_PASSWORD));
} elseif (isset($_POST['confirmation']) === false || isset($_POST['confirmation']) && trim($_POST['password']) != trim($_POST['confirmation'])) {
$OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_password_mismatch_with_confirmation'));
} else {
$data['password'] = $_POST['password'];
}
if ($OSCOM_MessageStack->size('Create') === 0) {
if (Account::createEntry($data)) {
$OSCOM_MessageStack->add('Create', OSCOM::getDef('success_account_updated'), 'success');
}
OSCOM::redirect(OSCOM::getLink(null, null, 'Create&Success', 'SSL'));
}
}
function updateUser($data)
{
global $db_con;
if (checkdate(intval($data['month']), intval($data['day']), intval($data['year']))) {
$date = $data['year'] . '-' . $data['month'] . '-' . $data['day'];
} else {
$date = '0000-00-00';
}
if (!empty($_POST['photo'])) {
if (!empty($_POST['photo_updated'])) {
if (copy('js/file-uploading/server/php/files/' . $_POST['photo'], 'uploads/avatars/' . $_POST['photo']) && copy('js/file-uploading/server/php/files/thumbnail/' . $_POST['photo'], 'uploads/avatars/thumbs/' . $_POST['photo'])) {
$photo = $_POST['photo'];
unlink('js/file-uploading/server/php/files/' . $_POST['photo']);
unlink('js/file-uploading/server/php/files/thumbnail/' . $_POST['photo']);
} else {
$photo = '';
}
} else {
$photo = $_POST['photo'];
}
} else {
$photo = '';
}
$q = "UPDATE `users` SET\n\t\t`first_name` = '" . $db_con->escape($data['first_name']) . "',\n\t\t`last_name` = '" . $db_con->escape($data['last_name']) . "',\n\t\t`birthday` = '" . $date . "',\n\t\t`gender` = " . $data['gender'] . ",\n\t\t`college` = '" . $db_con->escape($data['college']) . "',\n\t\t`high_school` = '" . $db_con->escape($data['high_school']) . "',\n\t\t`school` = '" . $db_con->escape($data['school']) . "',\n\t\t`company_name` = '" . $db_con->escape($data['company_name']) . "',\n\t\t`position` = '" . $db_con->escape($data['position']) . "',\n\t\t`location` = '" . $db_con->escape($data['location']) . "',\n\t\t`hometown` = '" . $db_con->escape($data['hometown']) . "',\n\t\t`mailing_address` = '" . $db_con->escape($data['mailing_address']) . "',\n\t\t`alt_email` = '" . $db_con->escape($data['alt_email']) . "',\n\t\t`social_network` = '" . $db_con->escape($data['social_network']) . "',\n\t\t`phone` = '" . $db_con->escape($data['phone']) . "',\n\t\t`quotes` = '" . $db_con->escape($data['quotes']) . "',\n\t\t`about_me` = '" . $db_con->escape($data['about_me']) . "',\n\t\t`photo` = '" . $photo . "'\n\t\t WHERE `user_id` = " . $data['user_id'];
return $db_con->query($q);
}
public function testBirthNumber()
{
$faker = new Generator();
$faker->addProvider(new Person($faker));
$faker->addProvider(new Miscellaneous($faker));
for ($i = 0; $i < 1000; $i++) {
$birthNumber = $faker->birthNumber();
$birthNumber = str_replace('/', '', $birthNumber);
// check date
$year = intval(substr($birthNumber, 0, 2), 10);
$month = intval(substr($birthNumber, 2, 2), 10);
$day = intval(substr($birthNumber, 4, 2), 10);
// make 4 digit year from 2 digit representation
$year += $year < 54 ? 2000 : 1900;
// adjust special cases for month
if ($month > 50) {
$month -= 50;
}
if ($year >= 2004 && $month > 20) {
$month -= 20;
}
$this->assertTrue(checkdate($month, $day, $year), "Birth number {$birthNumber}: date {$year}/{$month}/{$day} is invalid.");
// check CRC if presented
if (strlen($birthNumber) == 10) {
$crc = intval(substr($birthNumber, -1), 10);
$refCrc = intval(substr($birthNumber, 0, -1), 10) % 11;
if ($refCrc == 10) {
$refCrc = 0;
}
$this->assertEquals($crc, $refCrc, "Birth number {$birthNumber}: checksum {$crc} doesn't match expected {$refCrc}.");
}
}
}
public function convertPHPFormatDateToISOFormatDate($inputPHPFormat, $date)
{
$dateFormat = new sfDateFormat();
try {
$symfonyPattern = $this->__getSymfonyDateFormatPattern($inputPHPFormat);
$dateParts = $dateFormat->getDate($date, $symfonyPattern);
if (is_array($dateParts) && isset($dateParts['year']) && isset($dateParts['mon']) && isset($dateParts['mday'])) {
$day = $dateParts['mday'];
$month = $dateParts['mon'];
$year = $dateParts['year'];
// Additional check done for 3 digit years, or more than 4 digit years
if (checkdate($month, $day, $year) && $year >= 1000 && $year <= 9999) {
$dateTime = new DateTime();
$dateTime->setTimezone(new DateTimeZone(date_default_timezone_get()));
$dateTime->setDate($year, $month, $day);
$date = $dateTime->format('Y-m-d');
return $date;
} else {
return "Invalid date";
}
}
} catch (Exception $e) {
return "Invalid date";
}
return null;
}
function attribute($name)
{
switch ($name) {
case "day":
return $this->Day;
break;
case "month":
return $this->Month;
break;
case "year":
return $this->Year;
break;
case "has_content":
case "is_valid":
return checkdate($this->Month, $this->Day, $this->Year);
break;
case "zodiac_no":
case "zodiac_nr":
return $this->Zodiac_No;
break;
case "zodiac_name":
return $this->Zodiac_Name;
break;
case "days_on_earth":
return $this->Days_On_Earth;
break;
}
}
/**
* Validate value, validates as SQL date or SQL date
* @see \Phramework\Validate\ValidateResult for ValidateResult object
* @param mixed $value Value to validate
* @return ValidateResult
* @todo set errorObject
*/
public function validate($value)
{
//Use string's validator
$return = parent::validate($value);
//Apply additional rules
if ($return->status === true && preg_match('/^(\\d{4})-(\\d{2})-(\\d{2})$/', $value, $matches)) {
if (checkdate($matches[2], $matches[3], $matches[1])) {
$timestamp = strtotime($value);
//validate formatMinimum
if ($this->formatMinimum !== null && $timestamp < strtotime($this->formatMinimum)) {
$failure = 'formatMinimum';
goto error;
}
//validate formatMaximum
if ($this->formatMaximum !== null && $timestamp > strtotime($this->formatMaximum)) {
$failure = 'formatMaximum';
goto error;
}
//Set status to success
$return->status = true;
return $return;
}
}
$failure = 'failure';
error:
$return->status = false;
$return->errorObject = new IncorrectParametersException([['type' => static::getType(), 'failure' => $failure]]);
return $return;
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$em = $this->getContainer()->get('doctrine')->getManager();
$scheduler = $this->getContainer()->get('scheduler');
$campaignId = $input->getArgument('campaignId');
$deliveryTime = new \DateTime($input->getArgument('deliverytime'));
$month = $input->getArgument('month');
$year = $input->getArgument('year');
$date = $input->getArgument('date');
// The date at which the job is to be run
$dateParts = explode('-', $date);
if (!checkdate($dateParts[1], $dateParts[2], $dateParts[0])) {
$output->writeLn("<error>Invalid date or format. Correct format is Y-m-d</error>");
return;
}
$now = new \DateTime();
$output->writeln("<comment>Scheduling recommendations email started on {$now->format('Y-m-d H:i:s')}</comment>");
// Get All Users
$qb = $em->createQueryBuilder();
$qb->add('select', 'DISTINCT u.id')->add('from', 'ClassCentralSiteBundle:User u')->join('u.userPreferences', 'up')->join('u.follows', 'uf')->andWhere('uf is NOT NULL')->andWhere("up.value = 1")->andWhere('u.isverified = 1')->andWhere("up.type=" . UserPreference::USER_PREFERENCE_PERSONALIZED_COURSE_RECOMMENDATIONS);
$users = $qb->getQuery()->getArrayResult();
$scheduled = 0;
$dt = new \DateTime($date);
$deliveryTime = $deliveryTime->format(\DateTime::RFC2822);
foreach ($users as $user) {
$id = $scheduler->schedule($dt, RecommendationEmailJob::RECOMMENDATION_EMAIL_JOB_TYPE, 'ClassCentral\\MOOCTrackerBundle\\Job\\RecommendationEmailJob', array('campaignId' => $campaignId, 'deliveryTime' => $deliveryTime, 'month' => $month, 'year' => $year), $user['id']);
if ($id) {
$scheduled++;
}
}
$output->writeln("<info>{$scheduled} recommendation emails jobs scheduled</info>");
}
/**
* @param AttributeInterface $attribute
* @param string $data
*/
protected function validateDateFormat(AttributeInterface $attribute, $data)
{
$dateValues = explode('-', $data);
if (count($dateValues) !== 3 || (!is_numeric($dateValues[0]) || !is_numeric($dateValues[1]) || !is_numeric($dateValues[2])) || !checkdate($dateValues[1], $dateValues[2], $dateValues[0])) {
throw InvalidArgumentException::expected($attribute->getCode(), 'a string with the format yyyy-mm-dd', 'setter', 'date', gettype($data), $data);
}
}
public function importMarried($scope)
{
if (BasePrimitive::import($scope) && isset($scope[$this->name][self::DAY], $scope[$this->name][self::MONTH], $scope[$this->name][self::YEAR], $scope[$this->name][self::HOURS], $scope[$this->name][self::MINUTES], $scope[$this->name][self::SECONDS], $scope[$this->name][self::ZONE]) && is_array($scope[$this->name])) {
if ($this->isEmpty($scope)) {
return !$this->isRequired();
}
$zone = $scope[$this->name][self::ZONE];
$hours = (int) $scope[$this->name][self::HOURS];
$minutes = (int) $scope[$this->name][self::MINUTES];
$seconds = (int) $scope[$this->name][self::SECONDS];
$year = (int) $scope[$this->name][self::YEAR];
$month = (int) $scope[$this->name][self::MONTH];
$day = (int) $scope[$this->name][self::DAY];
if (!checkdate($month, $day, $year)) {
return false;
}
try {
$stamp = new TimestampTZ($year . '-' . $month . '-' . $day . ' ' . $hours . ':' . $minutes . ':' . $seconds . ' ' . $zone);
} catch (WrongArgumentException $e) {
return false;
}
if ($this->checkRanges($stamp)) {
$this->value = $stamp;
return true;
}
}
return false;
}
private function calc($account_type)
{
$accounts = Accounts::find()->where(['type' => $account_type])->All();
$sum = 0;
$data = array();
$stime = "00:00:01";
$etime = "23:59:59";
$from_date = "{$this->year}-01-01 {$stime}";
$to_date = "{$this->year}-12-31 {$etime}";
foreach ($accounts as $account) {
$sum = $account->getTotal($from_date, $to_date);
if ($sum != 0) {
$accounty = array('id' => $account->id, 'name' => $account->name, 'sum' => $sum, 'id6111' => $account->id6111);
for ($x = 1; $x <= 12; $x++) {
if ($x <= 9) {
$a = "0{$x}";
} else {
$a = $x;
}
$last = 31;
while (!checkdate($x, $last, $this->year)) {
$last--;
}
$accounty[$x] = $account->getTotal("{$this->year}-{$a}-01 {$stime}", "{$this->year}-{$a}-{$last} {$etime}");
}
$data[] = $accounty;
}
}
return $data;
}
function grava($ID, $dia, $mes, $ano, $local, $descricao)
{
$temerro = 0;
$x = 0;
if (empty($local)) {
echo "<tr><td>Informe o local do evento </td></tr>" . "\n";
$temerro = 1;
}
if (!checkdate($mes, $dia, $ano)) {
echo "<tr><td>Data do evento inválida !</td></tr>" . "\n";
$temerro = 1;
}
if (empty($descricao)) {
echo "<tr><td>Descreva o evento </td></tr>" . "\n";
$temerro = 1;
}
if ($temerro == 1) {
include "volta.php";
} else {
$eve = new Evento($ID);
$eve->setLocal($local);
$eve->setDescricao($descricao);
$eve->setData($ano . "/" . $mes . "/" . $dia);
$eve->Grava();
echo '<tr><td><br></td></tr>' . "\n";
echo "<tr><td>Evento gravado com sucesso !</td></tr>\n";
echo '<tr><td><br></td></tr>' . "\n";
echo '<tr><td><br></td></tr>' . "\n";
echo '<tr><td><a href="lst_cadeventos.php">OK</a></td></tr>' . "\n";
}
}
/**
* Return count of donations grouped by status.
*
* @global WPDB $wpdb
* @param array $args
* @return array
* @access public
* @static
* @since 1.0.0
*/
public static function count_by_status($args = array())
{
global $wpdb;
$defaults = array('s' => null, 'start_date' => null, 'end_date' => null);
$args = wp_parse_args($args, $defaults);
$where_clause = "post_type = 'donation'";
if (!empty($args['s'])) {
$where_clause .= "AND ((p.post_title LIKE '%{$args['s']}%') OR (p.post_content LIKE '%{$args['s']}%'))";
}
if (!empty($args['start_date'])) {
$year = $args['start_date']['year'];
$month = $args['start_date']['month'];
$day = $args['start_date']['day'];
if (false !== checkdate($month, $day, $year)) {
$where_clause .= $wpdb->prepare(" AND post_date >= '%s'", date('Y-m-d', mktime(0, 0, 0, $month, $day, $year)));
}
}
if (!empty($args['end_date'])) {
$year = $args['end_date']['year'];
$month = $args['end_date']['month'];
$day = $args['end_date']['day'];
if (false !== checkdate($month, $day, $year)) {
$where_clause .= $wpdb->prepare(" AND post_date <= '%s'", date('Y-m-d', mktime(0, 0, 0, $month, $day, $year)));
}
}
$sql = "SELECT post_status, COUNT( * ) AS num_donations\n\t\t\t\tFROM {$wpdb->posts}\t\n\t\t\t\tWHERE {$where_clause}\n\t\t\t\tGROUP BY post_status";
return $wpdb->get_results($sql, OBJECT_K);
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$em = $this->getContainer()->get('doctrine')->getManager();
$scheduler = $this->getContainer()->get('scheduler');
$subject = $input->getArgument('subject');
$template = $input->getArgument('template');
$campaignId = $input->getArgument('campaignId');
$deliveryTime = new \DateTime($input->getArgument('deliverytime'));
$date = $input->getArgument('date');
// The date at which the job is to be run
$dateParts = explode('-', $date);
if (!checkdate($dateParts[1], $dateParts[2], $dateParts[0])) {
$output->writeLn("<error>Invalid date or format. Correct format is Y-m-d</error>");
return;
}
$now = new \DateTime();
$output->writeln("<comment>Scheduling announcement email started on {$now->format('Y-m-d H:i:s')}</comment>");
// Get All Users
$qb = $em->createQueryBuilder();
$qb->add('select', 'u.id')->add('from', 'ClassCentralSiteBundle:User u')->join('u.userPreferences', 'up')->andWhere("up.value = 1")->andWhere("up.type=" . UserPreference::USER_PREFERENCE_FOLLOW_UP_EMAILs);
$users = $qb->getQuery()->getArrayResult();
$scheduled = 0;
foreach ($users as $user) {
$id = $scheduler->schedule(new \DateTime($date), AnnouncementEmailJob::ANNOUNCEMENT_EMAIL_JOB_TYPE, 'ClassCentral\\MOOCTrackerBundle\\Job\\AnnouncementEmailJob', array('template' => $template, 'subject' => $subject, 'campaignId' => $campaignId, 'deliveryTime' => $deliveryTime->format(\DateTime::RFC2822)), $user['id']);
if ($id) {
$scheduled++;
}
}
$output->writeln("<info>{$scheduled} jobs scheduled</info>");
}
