public function getRegisterCLBalance(&$rsltObject, $loginid, $roleid)
{
$rsltObject->cl_balance = 0;
//SELECT op_balance FROM registers WHERE DATE(created_at) = DATE(NOW()) ORDER BY id ASC LIMIT 1
$criteria=new CDbCriteria;
$criteria->order = 'id DESC';
$criteria->limit = '1';
if(!empty($date))
{
$condition = " DATE(created_at) = DATE('". $date . "')";
}
else
{
$condition = "DATE(created_at) = DATE(NOW())";
}
$criteria->addCondition($condition);
$condition = "login_id = " . $loginid;
$condition .= " AND role_id = " . $roleid;
$criteria->addCondition($condition);
$result = Register::model()->findAll($criteria);
foreach($result as $row)
{
$rsltObject->cl_balance = $row->cl_balance;
break;
}
}
public function getDefaultObject($rolename)
{
$model = new Person;
$rolename = (!empty($rolename)?$rolename:'');
$model->role_id = Role::model()->getRoleId( $rolename , true );
$model->rolename = $rolename;
$model->enablelogin = false;
$model->register_id = Register::model()->getDefaultRegisterId();
$this->setrelationalModels($model);
$this->setPeopleConfigs($model);
return $model;
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model=Register::model()->findByPk($id);
if($model===null)
throw new CHttpException(404,'The requested page does not exist.');
return $model;
}
public function setRegister($record)
{
if(strtolower($record->role->role)
=== strtolower(Helper::CONST_Sales))
{
$loginid = $record->login->id;
$roleid = $record->role->id;
$criteria=new CDbCriteria;
$criteria->addCondition('login_id = :loginid AND role_id=:roleid
AND DATE(salesdate) = DATE(NOW())
AND open_time IS NOT NULL
AND close_time IS NULL');
$criteria->params = array(':loginid' => $loginid, ':roleid' => $roleid, );
$result = Register::model()->findAll($criteria);
if(empty($result))
{
$result = null;
$register = new Register;
$register->login_id = $loginid;
$register->role_id = $roleid;
$register->salesdate = date(Yii::app()->controller->datetimemysqlformatYMD);
$register->op_balance = null;
$rtn = $register->save();
if($rtn)
{
$result = $register;
}
}
else
{
$result = $result[0];
}
$this->setState('register',$result);
}
else
{
$this->setState('register',null);
}
}
