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