public function LoginAuth(Gyuser_Model_Operator $obj)
{
$table = $this->getDbTable();
$select = $table->select($table, array('id', 'name', 'last_name', 'email', 'type'))->where('email = ?', $obj->getEmail())->where('password = ?', md5($obj->getPassword()))->where('status = ?', true);
$result = $table->fetchRow($select);
$entry = new Gyuser_Model_Operator();
if (@$result->id) {
$entry->setId($result->id);
$entry->setName($result->name);
$entry->setLast_name($result->last_name);
$entry->setEmail($result->email);
$entry->setType($result->type);
}
return $entry;
}
public function operatordeleteajaxAction()
{
$request = $this->getRequest();
if ($this->getRequest()->isPost()) {
$mapper = new Gyuser_Model_OperatorDataMapper();
$Obj = new Gyuser_Model_Operator();
$Obj->setId($request->id);
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender();
$result = $mapper->delete($Obj);
if ($result) {
echo $result;
} else {
echo 'f';
}
}
}
public function ValidateCUIT(Gyuser_Model_User $obj)
{
$id = (int) $obj->getId();
$business_CUIT = $obj->getBusiness_CUIT();
if (trim($business_CUIT) == '') {
return true;
}
if (!$id) {
$query = "SELECT count(business_CUIT) as business_CUIT_count,id FROM clients WHERE business_CUIT = '{$business_CUIT}' and status = 1 ";
} else {
$query = "SELECT count(business_CUIT) as business_CUIT_count,id FROM clients WHERE business_CUIT = '{$business_CUIT}' and status = 1 and id != {$id}";
}
$db = Zend_Db_Table::getDefaultAdapter();
$stmt = $db->query($query);
$row = $stmt->fetchAll();
$count = $row[0]['business_CUIT_count'];
if ($count) {
$cObj = new Gyuser_Model_Operator();
$cId = $row[0]['id'];
$cObj->setId($cId);
$cObj = $this->findClientNames($cObj);
$First_name = $cObj->getFirst_name();
$Last_name = $cObj->getLast_name();
$rArr = array('f_name' => $First_name, 'l_name' => $Last_name);
return $rArr;
} else {
return true;
}
}
