public function __construct($id = "")
{
$this->DT_StartDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_EndDate = DataMember::CreateDMA(DataMember::DT_DATE);
if ($id != '') {
parent::FillObject($this, "\n\t\t\t\t\tselect c.* , t.TemplateTitle as _TemplateTitle,\n\t\t\t\t\t\tconcat_ws(' ',fname,lname,CompanyName) _PersonName\n from CNT_contracts c\n left join CNT_templates t using(TemplateID) \n\t\t\t\t\tleft join BSC_persons using(PersonID)\n\t\t\t\t\twhere c." . static::TableKey . " = :id", array(":id" => $id));
}
}
function __construct($id = '')
{
$this->DT_ReqDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_FromDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_ToDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_SurveyDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_StartTime = DataMember::CreateDMA(DataMember::DT_TIME);
$this->DT_EndTime = DataMember::CreateDMA(DataMember::DT_TIME);
parent::FillObject($this, "select t.*,concat(fname,' ',lname) _fullname,\r\n\t\t\t\tbf1.InfoDesc _GoMeanDesc,bf2.InfoDesc _ReturnMeanDesc\r\n\t\t\tfrom ATN_requests t join BSC_persons using(PersonID)\r\n\t\t\t\tleft join BaseInfo bf1 on(bf1.TypeID=21 AND bf1.InfoID=GoMean)\r\n\t\t\t\tleft join BaseInfo bf2 on(bf2.TypeID=21 AND bf2.InfoID=ReturnMean)\r\n\t\t\twhere RequestID=?", array($id));
}
function __construct($PayID = "")
{
$this->DT_PayDate = DataMember::CreateDMA(DataMember::DT_DATE);
if ($PayID != "") {
parent::FillObject($this, "select *\r\n\t\t\t\tfrom LON_payments where payID=?", array($PayID));
}
}
