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;
}
