Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function val_md_day($col,$val,$row, $instanceName)
- {
- // Delete image file if it already existed
- $query = "select md_day from ess where md_day = :md_day";
- $queryParams = array('md_day' => $val);
- $stmt = $this->Editor->doQuery($query,$queryParams);
- if($row = $stmt->fetch(PDO::FETCH_ASSOC))
- {
- $not_found = 1;
- $n = 1;
- $check_date = $val;
- while($not_found)
- {
- $check_date = date('Y-m-d', strtotime('-1 day', strtotime($check_date)));
- $query1 = "SELECT md_day FROM ess WHERE md_day = :md_day ";
- $queryParams1 = array('md_day' => $check_date);
- $stmt1 = $this->Editor->doQuery($query1,$queryParams1);
- if($row1 = $stmt1->fetch(PDO::FETCH_ASSOC))
- {
- $not_found = 1;
- }
- else
- {
- $not_found = 0;
- $this->Editor->showDefaultValidationMsg = false;
- $this->Editor->addTooltipMsg('Available Date is : ' . $check_date );
- return false;
- }
- }
- }
- else
- {
- return true;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement