public static function GetContractItems($ContractID) { $CntObj = new CNT_contracts($ContractID); $res_cnt = array(array("TemplateItemID" => 1, "ItemValue" => $CntObj->StartDate), array("TemplateItemID" => 2, "ItemValue" => $CntObj->EndDate), array("TemplateItemID" => 3, "ItemValue" => $CntObj->_PersonName)); $res = parent::runquery("select * from " . static::TableName . " where ContractID=:ContractID", array(":ContractID" => $ContractID)); // echo PdoDataAccess::GetLatestQueryString(); return array_merge($res_cnt, $res); }
function Remove($pdo = null) { $dt = parent::runquery("select * from PLN_Elements where GroupID=?", array($this->GroupID)); if (count($dt) > 0) { return false; } parent::Remove($pdo); }
public function Remove($pdo = null) { $res = parent::runquery("select count(*) from CNT_ContractItems where TemplateItemID = ? limit 1", array($this->TemplateItemID), $pdo); if ($res[0]['count(*)'] > 0) { throw new Exception(self::UsedTemplateItem); /*parent::PushException("UsedTemplateItem"); return false;*/ } return parent::Remove($pdo); }
public function Remove($pdo = null) { $dt = parent::runquery("select * from BSC_persons where PostID=?", array($this->PostID), $pdo); if (count($dt) > 0) { ExceptionHandler::PushException("این پست به فردی نسبت داده شده است و قابل حذف نمی باشد"); return false; } $this->IsActive = "NO"; return $this->Edit($pdo); }
function PackNoIsValid() { $dt = parent::runquery("select PackageID from DMS_packages \r\n\t\t\twhere BranchID=? AND PackNo=? AND PackageID<>?", array($this->BranchID, $this->PackNo, $this->PackageID)); return count($dt) == 0; }
static function GetShiftOfDate($PersonID, $date) { $query = "select s.*\t\t\t\r\n\t\t\tfrom ATN_PersonShifts ps\r\n\t\t\tjoin ATN_shifts s on(ps.ShiftID=s.ShiftID)\r\n\t\t\twhere ps.IsActive='YES' AND ps.PersonID=? AND ? between FromDate AND ToDate"; $dt = parent::runquery($query, array($PersonID, $date)); return count($dt) > 0 ? $dt[0] : null; }
function CheckPartAmount() { $dt = parent::runquery("select ifnull(sum(PayAmount),0) from LON_payments \r\n\t\t\twhere RequestID=? AND PayID<>?", array($this->RequestID, $this->PayID)); $PartObj = LON_ReqParts::GetValidPartObj($this->RequestID); if ($dt[0][0] * 1 + $this->PayAmount * 1 > $PartObj->PartAmount * 1) { ExceptionHandler::PushException("مبالغ وارد شده از سقف مبلغ وام تجاوز می کند"); return false; } return true; }