예제 #1
0
 public function getLanguage()
 {
     $this->db = Zend_Db_Table::getDefaultAdapter();
     $sql = "SELECT code from ourbank_language where active = 1";
     $result = $this->db->fetchOne($sql);
     return $result;
 }
 public function fillgridAction()
 {
     self::createModel();
     $request = $this->getRequest();
     $valid = $request->getParam('nd');
     if ($request->isXmlHttpRequest() and $valid) {
         $this->grid = $this->_helper->grid();
         $this->grid->setGridparam($request);
         $this->grid->sql = Zend_Db_Table::getDefaultAdapter()->select()->from($this->model->info('name'), array('subject_faculty.subject_code', 'subject_mode_id', 'staff_id', 'subject_department.degree_id', 'department_id', 'department_id', 'subject_department.semester_id'))->joinLeft('subject_department', '(subject_department.subject_code = subject_faculty.subject_code AND subject_department.department_id = subject_faculty.department_id)', array())->where('subject_faculty.department_id = ?', $this->department_id);
         $searchOn = $request->getParam('_search');
         if ($searchOn != 'false') {
             $sarr = $request->getParams();
             foreach ($sarr as $key => $value) {
                 switch ($key) {
                     case 'staff_id':
                         $this->grid->sql->where("{$key} LIKE ?", '%' . $value . '%');
                         break;
                     case 'subject_code':
                         $this->grid->sql->where("subject_faculty.subject_code LIKE ?", $value . '%');
                         break;
                     case 'subject_mode':
                         $this->grid->sql->where("subject_faculty.subject_mode_id LIKE ?", $value . '%');
                         break;
                     case 'semester_id':
                         $this->grid->sql->where("subject_department.semester_id = ?", $value);
                         break;
                 }
             }
         }
         self::fillgridfinal();
     } else {
         echo '<b>Oops!! </b><br/>No use of peeping like that... :)';
     }
 }
예제 #3
0
 public function getTableFields($tableName)
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $columns = $db->query("SELECT menufields FROM main_menu WHERE url = '" . $tableName . "'");
     $columnData = $columns->fetch();
     return $columnData;
 }
예제 #4
0
 /**
  * Helper para pegar as imagens do webservice
  *
  */
 public function GetDadosUsuario()
 {
     $auth = Zend_Auth::getInstance();
     $db = Zend_Db_Table::getDefaultAdapter();
     $chAction = strtolower(Zend_Controller_Front::getInstance()->getRequest()->getActionName());
     $chController = Zend_Controller_Front::getInstance()->getRequest()->getControllerName();
     $sql = 'select ';
     $sql .= '	u.*, ';
     $sql .= '	a.nm_avatar, ';
     $sql .= '	a.tp_avatar, ';
     $sql .= '	a.sz_avatar, ';
     $sql .= '	a.arquivo ';
     $sql .= 'from ';
     $sql .= '	sca_usuario u ';
     $sql .= '	left join sgg_avatar a on a.id_avatar = u.id_avatar ';
     $sql .= 'where u.st_usuario = 1 ';
     $sql .= 'and u.id_usuario = ' . $auth->getIdentity()->id_usuario;
     $result = $db->fetchRow($sql);
     if ($result) {
         if ($result['arquivo']) {
             $result['arquivo'] = "data:" . $result['tp_avatar'] . ";base64," . base64_encode($result['arquivo']);
         }
     }
     return $result;
 }
예제 #5
0
파일: Trip.php 프로젝트: rizkioa/etak6
 /**
  * Get trip paginator adapter
  * @param string $filtingField
  * @param string $filtingCriteria
  * @param string $sortingField
  * @return Zend_Paginator_Adapter_DbSelect|Zend_Paginator_Adapter_DbTableSelect
  */
 public function getTripPaginatorAdapter($filtingField, $filtingCriteria, $sortingField)
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $select = $db->select()->from(array('t' => 'trip'), array('t.trip_id', 't.departure_time', 't.arrival_time', 'fare'))->joinInner(array('r' => 'route'), 't.route_id = r.route_id', array('r.from_city', 'r.to_city'));
     if (!empty($filtingField)) {
         // switch filting field
         switch ($filtingField) {
             case 'departure_time':
             case 'arrival_time':
                 if (!empty($filtingCriteria)) {
                     $dateFormat = new Zend_Date($filtingCriteria, 'dd-MM-y HH:mm:ss');
                     $filtingCriteria = $dateFormat->toString('y-MM-dd HH:mm:ss');
                 }
                 break;
             case 'from_city':
             case 'to_city':
                 $db = Zend_Db_Table::getDefaultAdapter();
                 $select = $db->select()->from(array('t' => 'trip'), array('t.trip_id', 't.departure_time', 't.arrival_time', 'fare'))->joinInner(array('r' => 'route'), 't.route_id = r.route_id', array('r.from_city', 'r.to_city'));
                 break;
             default:
                 break;
         }
         // add filting criteria
         $select->where($filtingField . ' = ?', $filtingCriteria);
     }
     // add sorting criteria
     if (!empty($sortingField)) {
         $select->order($sortingField);
     }
     $adapter = new Zend_Paginator_Adapter_DbSelect($select);
     return $adapter;
 }
예제 #6
0
 public function checkduplicaterequestname($servicedeskid, $requestname)
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $qry = "select count(*) as count from main_sd_reqtypes sd where sd.service_request_name ='" . $requestname . "' AND sd.service_desk_id='" . $servicedeskid . "' AND sd.isactive=1 ";
     $res = $db->query($qry)->fetchAll();
     return $res;
 }
예제 #7
0
 protected function _getAuthAdapter()
 {
     $dbAdapter = Zend_Db_Table::getDefaultAdapter();
     $authAdapter = new Zend_Auth_Adapter_DbTable($dbAdapter);
     $authAdapter->setTableName('users')->setIdentityColumn('username')->setCredentialColumn('password')->setCredentialTreatment('SHA1(CONCAT(?,salt))');
     return $authAdapter;
 }
예제 #8
0
 public function loginAction()
 {
     $this->_helper->layout->disablelayout();
     $authorization = Zend_Auth::getInstance();
     $identity = $authorization->getIdentity();
     if ($authorization->hasIdentity()) {
         $this->redirect("categories/list");
     }
     if ($this->getRequest()->isPost()) {
         $data = $this->getRequest()->getParams();
         $db = Zend_Db_Table::getDefaultAdapter();
         $authAdapter = new Zend_Auth_Adapter_DbTable($db, 'users', 'username', 'password');
         $authAdapter->setIdentity($data['username']);
         $authAdapter->setCredential(md5($data['password']));
         $result = $authAdapter->authenticate();
         if ($result->isValid()) {
             $active = (new Application_Model_Users())->getUserByUsername($data['username'])[0]['active'];
             if ($active) {
                 $auth = Zend_Auth::getInstance();
                 $storage = $auth->getStorage();
                 $storage->write($authAdapter->getResultRowObject(array('f_name', 'username', 'id', 'user_type')));
                 $authorization = Zend_Auth::getInstance();
                 $identity = $authorization->getIdentity();
                 $this->view->identity = $identity;
                 $this->redirect('categories/list');
             } else {
                 $this->view->user_msg = "The page not allowed for normal user.";
                 $this->redirect("users/login");
             }
         }
     }
     $form = new Application_Form_Login();
     $this->view->form = $form;
 }
예제 #9
0
 /**
  * Gets the adapter for authentication against a database table
  *
  * @return object
  */
 protected function getAuthAdapter()
 {
     $dbAdapter = Zend_Db_Table::getDefaultAdapter();
     $authAdapter = new Zend_Auth_Adapter_DbTable($dbAdapter);
     $authAdapter->setTableName('login')->setIdentityColumn('username')->setCredentialColumn('password')->setCredentialTreatment('MD5(?)');
     return $authAdapter;
 }
예제 #10
0
 public function findForSelect()
 {
     $adapter = Zend_Db_Table::getDefaultAdapter();
     $statement = "SELECT DISTINCT p.* FROM province p INNER JOIN city c ON (p.province_id = c.province_id) WHERE c.status = 'A' ORDER BY name";
     $results = $adapter->fetchAll($statement);
     return $results;
 }
예제 #11
0
 /**
  * Get all possible classroom
  *
  * @param int $userId
  * @return array
  */
 public static function getAllByUser($userId)
 {
     $session = new Zend_Session_Namespace('data');
     $db = Zend_Db_Table::getDefaultAdapter();
     $cols = array('cr.*', 'c.*', 'c.id as id', 'cr.id as classroom_id', 'cr.name as classroom_name');
     $course = array('c' => 'course');
     $classroom = array('cr' => 'classroom');
     $classUser = array('cu' => 'classroom_user');
     $data = array();
     //by course or classroom responsible
     $select = $db->select()->from($classroom, $cols)->join($course, 'c.id = cr.course_id', array())->where('c.responsible = ? OR cr.responsible = ?', $userId)->where("cr.status = 'active' OR cr.status = 'open'");
     $responsibles = $db->fetchAll($select);
     //by registration
     $select = $db->select()->from($classroom, $cols)->join($course, 'c.id = cr.course_id', array())->join($classUser, 'cr.id = cu.classroom_id', array())->where('cu.user_id = ?', $userId)->where('cu.status = ?', 'registered')->where('cr.begin <= ?', date('Y-m-d'))->where('cr.end >= ? OR end IS NULL', date('Y-m-d'))->where("cr.status = 'active' OR cr.status = 'open'");
     $registries = $db->fetchAll($select);
     foreach ($responsibles as $responsible) {
         $data[] = $responsible;
         $session->classrooms[] = $responsible['classroom_id'];
     }
     foreach ($registries as $registry) {
         if (in_array($registry, $data)) {
             continue;
         }
         $data[] = $registry;
         $session->classrooms[] = $registry['classroom_id'];
     }
     return $data;
 }
예제 #12
0
 public function loadAppData()
 {
     $loggedInUserId = $this->getIdentityId();
     $addData = array();
     if ($loggedInUserId != null) {
         $db = Zend_Db_Table::getDefaultAdapter();
         $tagGroupsTable = new Default_Dao_TagGroup();
         $tagGroupsRows = $tagGroupsTable->fetchAll('valid is true');
         foreach ($tagGroupsRows as $tagGroupsRow) {
             $tagGroup = new Default_Dto_TagGroup();
             $tagGroup->id = $tagGroupsRow['id'];
             $tagGroup->name = $tagGroupsRow['name'];
             $tagGroup->tags = new Zend_Amf_Value_Messaging_ArrayCollection();
             $tagGroup->tags->source = array();
             $tagsTable = new Default_Dao_Tag();
             $tagsRows = $tagsTable->fetchAll($db->quoteInto('group_id = ?', $tagGroupsRow['id']));
             foreach ($tagsRows as $tagsRow) {
                 $tag = new Default_Dto_Tag();
                 $tag->id = $tagsRow['id'];
                 $tag->name = $tagsRow['name'];
                 array_push($tagGroup->tags->source, $tag);
             }
             array_push($addData, $tagGroup);
         }
     }
     $result = new Zend_Amf_Value_Messaging_ArrayCollection();
     $result->source = $addData;
     return $result;
 }
예제 #13
0
 public function indexAction()
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     if (isset($_POST['editForm'])) {
         $first_name = $_POST['editForm']['first_name'];
         $last_name = $_POST['editForm']['last_name'];
         $current_city = $_POST['editForm']['current_city'];
         $person_id = $_POST['editForm']['person_id'];
         $form = false;
     } else {
         $person_id = $this->_request->get('id');
         $select = $db->select();
         $select->from('contacts')->where('person_id = ?', $person_id);
         $contacts = $db->fetchAll($select);
         $first_name = $contacts[0]['first_name'];
         $last_name = $contacts[0]['last_name'];
         $current_city = $contacts[0]['current_city'];
         $form = true;
     }
     $this->view->first_name = $first_name;
     $this->view->last_name = $last_name;
     $this->view->current_city = $current_city;
     $this->view->person_id = $person_id;
     $this->view->form = $form;
     if (isset($_POST['editForm']) && $first_name && $last_name && $current_city) {
         $data = array('first_name' => $first_name, 'last_name' => $last_name, 'current_city' => $current_city);
         $db->update('contacts', $data, array('person_id=?' => $person_id));
         $this->renderScript('index/partials/tableRow.phtml');
     }
     if ($this->_request->isXmlHttpRequest()) {
         $this->view->layout()->setLayout('ajax');
     }
 }
예제 #14
0
 public function populate()
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $dbSelect = $db->select()->from(array('arp' => 'aclRolePrivileges'), array('aclRoleId'))->join(array('ap' => 'aclPrivileges'), 'arp.aclPrivilegeId = ap.aclPrivilegeId', array('aclPrivilegeName'))->join(array('ar' => 'aclResources'), 'ap.aclResourceId = ar.aclResourceId', array('aclResourceName'))->join(array('am' => 'aclModules'), 'ar.aclModuleId = am.aclModuleId', array('aclModuleName'));
     $roles = $db->fetchAll($dbSelect);
     foreach ($roles as $role) {
         if (!$this->has($role['aclModuleName'] . '_' . $role['aclResourceName'])) {
             $this->add(new Zend_Acl_Resource($role['aclModuleName'] . '_' . $role['aclResourceName']));
         }
         if (!$this->hasRole($role['aclRoleId'])) {
             $this->addRole(new Zend_Acl_Role($role['aclRoleId']));
         }
     }
     $defaultResources = array('default_error', 'default_login');
     // check default resource if exists; add otherwise
     foreach ($defaultResources as $def) {
         if (!$this->has($def)) {
             $this->add(new Zend_Acl_Resource($def));
         }
     }
     $this->deny();
     $this->allow(null, $defaultResources);
     foreach ($roles as $role) {
         $this->allow($role['aclRoleId'], $role['aclModuleName'] . '_' . $role['aclResourceName'], $role['aclPrivilegeName']);
     }
 }
예제 #15
0
 public function collectionsafterinsert()
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $pageId = !empty($_GET['pages_id']) ? $_GET['pages_id'] : 0;
     if ($_POST) {
         $id = 0;
         $files = $_FILES['preview'];
         //            var_dump($files);exit;
         if (!empty($files)) {
             //                $lastId = $db->lastInsertId('collections');
             //                if(strpos($_SERVER['REQUEST_URI'], 'edit') !== FALSE){
             //                    $id = $pageId;
             //                }
             //                if(strpos($_SERVER['REQUEST_URI'], 'add') !== FALSE){
             //                    $id = $lastId;
             //                }
             if (!is_dir($_SERVER['DOCUMENT_ROOT'] . '/public/uploadimg')) {
                 mkdir($_SERVER['DOCUMENT_ROOT'] . '/public/uploadimg');
             }
             //                var_dump($img);exit;
             if ($_FILES['preview']['name'] != '') {
                 $db->update('collections', array('img' => $files['name']), 'id=' . $pageId);
                 move_uploaded_file($files['tmp_name'], $_SERVER['DOCUMENT_ROOT'] . '/public/uploadimg/' . $files['name']);
             }
         }
     }
     if ($pageId != 0) {
         $sql = $db->select()->from(array('fc' => 'film_collection'))->join(array('f' => 'films'), 'f.id = fc.film_id', array('f.name'))->where('fc.collection_id =?', $pageId);
         $films = $db->query($sql)->fetchAll();
         $this->view->films = $films;
         return $films;
     }
 }
예제 #16
0
 public function empcompetencylevels($userId)
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $Data = $db->query("select c.id,c.competencylevel\n\t\t\t\t\t\t\t\tfrom main_competencylevel as c\n\t\t\t\t\t\t\t\twhere c.isactive=1 ");
     $data = $Data->fetchAll();
     return $data;
 }
예제 #17
0
 public function __construct($invoice)
 {
     // ToDo: Pass configuration options
     $this->_db = Zend_Db_Table::getDefaultAdapter();
     $this->_id = $invoice;
     $this->_initData();
 }
예제 #18
0
 public function init()
 {
     $this->setAttrib('class', 'form-horizontal');
     $login = new Zend_Form_Element_Text('login');
     $login->setRequired()->addValidator('StringLength', false, array('max' => 32))->setLabel('Nom d\'utilisateur');
     $db = Zend_Db_Table::getDefaultAdapter();
     $validator = new Zend_Validate_Db_NoRecordExists(array('adapter' => $db, 'schema' => 'twitter', 'table' => 'membre', 'field' => 'login'));
     $validator->setMessage("Le login '%value%' est déjà utilisé");
     $login->addValidator($validator);
     $pass = new Zend_Form_Element_Password('pass');
     $pass->setLabel('Mot de passe')->setRequired();
     $passConfirm = new Zend_Form_Element_Password('confirm');
     $passConfirm->setLabel('Confirmer le mot de passe');
     $validator = new Zend_Validate_Identical('pass');
     $validator->setMessage('La confirmation ne correspond pas au mot de passe');
     $passConfirm->addValidator($validator);
     //$passConfirm->addValidator('Identical', false, array('token'));
     $hash = new Zend_Form_Element_Hash('hash');
     $submit = new Zend_Form_Element_Submit('Inscription');
     $cancel = new Zend_Form_Element_Button('Annuler');
     $this->addElements(array($login, $pass, $passConfirm, $hash, $submit, $cancel));
     // add display group
     $this->addDisplayGroup(array('login', 'pass', 'confirm', 'Inscription', 'Annuler'), 'users');
     $this->getDisplayGroup('users')->setLegend('S\'inscrire');
     // set decorators
     EasyBib_Form_Decorator::setFormDecorator($this, EasyBib_Form_Decorator::BOOTSTRAP, 'Inscription', 'Annuler');
 }
예제 #19
0
파일: Auth.php 프로젝트: rossanorb/zend_acl
 public static function login($login, $senha)
 {
     $dbAdapter = Zend_Db_Table::getDefaultAdapter();
     //Inicia o adaptador Zend_Auth para banco de dados
     $authAdapter = new Zend_Auth_Adapter_DbTable($dbAdapter);
     $authAdapter->setTableName('users')->setIdentityColumn('login')->setCredentialColumn('password')->setCredentialTreatment('SHA1(?)');
     //Define os dados para processar o login
     $authAdapter->setIdentity($login)->setCredential($senha);
     //Faz inner join dos dados do perfil no SELECT do Auth_Adapter
     $select = $authAdapter->getDbSelect();
     $select->join('roles', 'roles.id_role = users.id_role', array('role_roles' => 'role', 'id_role'));
     //Efetua o login
     $auth = Zend_Auth::getInstance();
     $result = $auth->authenticate($authAdapter);
     //Verifica se o login foi efetuado com sucesso
     if ($result->isValid()) {
         //Recupera o objeto do usuário, sem a senha
         $info = $authAdapter->getResultRowObject(null, 'password');
         $usuario = new Application_Model_Users();
         $usuario->setFullName($info->nome);
         $usuario->setUserName($info->login);
         $usuario->setRoleId($info->role_roles);
         $usuario->setRoleCod($info->id_role);
         $storage = $auth->getStorage();
         $storage->write($usuario);
         return true;
     }
     throw new Exception('Nome de usuário ou senha inválida');
 }
예제 #20
0
 protected function _getAuthAdapter()
 {
     $dbAdapter = Zend_Db_Table::getDefaultAdapter();
     $authAdapter = new Zend_Auth_Adapter_DbTable($dbAdapter);
     $authAdapter->setTableName('school_staff')->setIdentityColumn('email')->setCredentialColumn('password')->setCredentialTreatment('md5(?)');
     return $authAdapter;
 }
예제 #21
0
 public function indexAction()
 {
     $form = new Application_Form_Login();
     $request = $this->getRequest();
     if ($request->isPost()) {
         //      if ($form->isValid($this->_getAllParams()))
         if ($form->isValid($request->getPost())) {
             $dbAdapter = Zend_Db_Table::getDefaultAdapter();
             $authAdapter = new Zend_Auth_Adapter_DbTable($dbAdapter);
             $authAdapter->setTableName('smo_usuario')->setIdentityColumn('usu_rut')->setCredentialColumn('usu_passwd')->setCredentialTreatment('md5(CONCAT(?,usu_passwd_salt))');
             $authAdapter->setIdentity($form->getValue('rut'))->setCredential($form->getValue('pass'));
             $auth = Zend_Auth::getInstance();
             $result = $auth->authenticate($authAdapter);
             if ($result->isValid()) {
                 // get all info about this user from the login table  // ommit only the password, we don't need that
                 $userInfo = $authAdapter->getResultRowObject(null, 'password');
                 // the default storage is a session with namespace Zend_Auth
                 $authStorage = $auth->getStorage();
                 $authStorage->write($userInfo);
                 return $this->_helper->redirector->gotoSimple('index', 'index');
                 //$this->_redirect('view/index/index');
             } else {
                 $errorMessage = "Datos Incorrectos, intente de nuevo.";
             }
         }
     }
     $this->view->form = $form;
     $this->view->errorMessage = $errorMessage;
 }
예제 #22
0
 public function __construct($node)
 {
     $time_start = microtime(true);
     $this->view = new Zend_View();
     $this->view->setScriptPath(dirname(__FILE__));
     $folderGuid = $node ? $node : 'root';
     $this->view->addHelperPath(KUTU_ROOT_DIR . '/mix_lib/Kutu/View/Helper', 'Kutu_View_Helper');
     if ($folderGuid == 'root') {
         $a = array();
         $a['totalCount'] = 0;
         $a['folderGuid'] = $folderGuid;
         $limit = 10;
         $a['limit'] = $limit;
     } else {
         $a = array();
         $a['folderGuid'] = $folderGuid;
         $db = Zend_Db_Table::getDefaultAdapter()->query("SELECT guid from KutuUser");
         //("SELECT guid from KutuCatalog, KutuCatalogFolder where guid=catalogGuid AND folderGuid='$folderGuid'");
         $rowset = $db->fetchAll(Zend_Db::FETCH_OBJ);
         $a['totalCount'] = count($rowset);
         $limit = 10;
         $a['limit'] = $limit;
     }
     $this->view->aData = $a;
     $time_end = microtime(true);
     $time = $time_end - $time_start;
     //echo'<br>WAKTU EKSEKUSI: '. $time;
 }
예제 #23
0
파일: Photo.php 프로젝트: Cydev2306/Nao-App
 public function getQuatre($last)
 {
     //retourne la suite des photos en appel ajax
     $db = Zend_Db_Table::getDefaultAdapter();
     $requete = 'SELECT * FROM photo WHERE idPhoto < ' . $last . ' ORDER BY idPhoto DESC LIMIT 0,4';
     return $db->query($requete)->fetchAll();
 }
예제 #24
0
파일: Visit.php 프로젝트: knatorski/SMS
 /**
  * @param mixed $value
  * @return booleans
  */
 public function isValid($value)
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $sql = 'SELECT
             m.id
         FROM
             meeting m LEFT JOIN event e ON (m.id_event = e.id)
         WHERE
             m.ghost = false
             AND (e.latest = true OR (e.latest IS NULL AND m.id_meeting_type = 6))
             AND m.id_meeting_type IN (3,4,6)
             AND
             (
                    (' . $db->quoteInto('m.meeting_at >= ?', $this->_objectEventAt->getValue()) . ' AND ' . $db->quoteInto('m.meeting_at + (m.length * interval \'1 minute\') <= timestamp ? + interval \'' . $this->_objectLength->getValue() . ' minutes\'', $this->_objectEventAt->getValue()) . ')
                 OR (' . $db->quoteInto('m.meeting_at <= ?', $this->_objectEventAt->getValue()) . ' AND ' . $db->quoteInto('m.meeting_at >= timestamp ?', $this->_objectEventAt->getValue()) . ')
                 OR (' . $db->quoteInto('m.meeting_at <= ?', $this->_objectEventAt->getValue()) . ' AND ' . $db->quoteInto('m.meeting_at + (m.length * interval \'1 minute\') >= timestamp ? + interval \'' . $this->_objectLength->getValue() . ' minutes\'', $this->_objectEventAt->getValue()) . ')
                 OR (' . $db->quoteInto('m.meeting_at < timestamp ? + interval \'' . $this->_objectLength->getValue() . ' minutes\'', $this->_objectEventAt->getValue()) . ' AND ' . $db->quoteInto('m.meeting_at + (m.length * interval \'1 minute\') >= timestamp ? + interval \'' . $this->_objectLength->getValue() . ' minutes\'', $this->_objectEventAt->getValue()) . ')
             )
             AND ' . $db->quoteInto('m.id_user = ?', Zend_Auth::getInstance()->getIdentity()->id) . '
             AND ' . $db->quoteInto('m.id_branch = ?', Zend_Auth::getInstance()->getIdentity()->id_branch);
     if ($this->_nextEvent !== false) {
         $sql .= ' AND ' . $db->quoteInto('m.id_event <> ?', $this->_nextEvent);
     }
     $rows = $db->query($sql);
     if ($rows->rowCount() > 0) {
         $this->_error(self::VISIT_EXISTS);
         return false;
     } else {
         return true;
     }
 }
예제 #25
0
 public function checkDuplicateQuestionName($categoryId, $question)
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $qry = "select count(*) as count from main_pa_questions aq where aq.pa_category_id =" . $categoryId . " AND aq.question='" . $question . "' AND aq.isactive=1 ";
     $res = $db->query($qry)->fetchAll();
     return $res;
 }
예제 #26
0
 public function insertGroup($param)
 {
     $dbAdapter = Zend_Db_Table::getDefaultAdapter();
     $dbAdapter->insert('AGroup', array('name' => $param));
     $insertid = $dbAdapter->lastInsertId();
     return $insertid;
 }
예제 #27
0
 public function fillgridAction()
 {
     $request = $this->getRequest();
     $valid = $request->getParam('nd');
     if ($valid) {
         $this->grid = $this->_helper->grid();
         $this->grid->sql = Zend_Db_Table::getDefaultAdapter()->select()->from('opac_issue_return', array('acc_no', 'member_id', 'title', 'author', 'edition', 'issue_date', 'return_date', 'isbn_id', 'status', 'issued_by', 'accepted_by'));
         $searchOn = $request->getParam('_search');
         if ($searchOn != 'false') {
             $sarr = $request->getParams();
             foreach ($sarr as $key => $value) {
                 switch ($key) {
                     case 'isbn_id':
                     case 'acc_no':
                     case 'edition':
                     case 'status':
                     case 'member_id':
                     case 'issued_by':
                     case 'accepted_by':
                         $this->grid->sql->where("{$key} = ?", $value);
                         break;
                     case 'title':
                     case 'author':
                     case 'issue_date':
                     case 'return_date':
                         $this->grid->sql->where("{$key} LIKE ?", '%' . $value . '%');
                         break;
                 }
             }
         }
         self::fillgridfinal();
     } else {
         echo '<b>Oops!! </b><br/>No use of peeping like that.. :)';
     }
 }
예제 #28
0
 public function getempmedicalclaimtypes($userId)
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $Data = $db->query('select if(injury_type = 1, "paternity",if(injury_type = 2 , "maternity",if (injury_type = 3,"disability","injury"))) as injuryType from main_empmedicalclaims where isactive =1 and user_id =' . $userId);
     $data = $Data->fetchAll();
     return $data;
 }
 protected function initLog()
 {
     $db = Zend_Db_Table::getDefaultAdapter();
     $columns = $this->parseColumns();
     $writer = new Zend_Log_Writer_Db($db, 'historico', $columns);
     $this->setLogger(new Zend_Log($writer));
 }
예제 #30
0
 /**
  * Executes a SQL query
  *
  * @param string $sqlString SQL query
  * @return bool
  */
 public static function executeSQLCode($sqlString)
 {
     $result = true;
     $lines = explode(chr(10), $sqlString);
     foreach ($lines as $key => $line) {
         if (substr(ltrim($line), 0, 2) == '--' || ltrim($line) == '') {
             unset($lines[$key]);
         }
     }
     //$sqlString = implode(chr(10), $lines);
     if (strpos($sqlString, chr(13)) > 0) {
         $sqlQueries = explode(";" . chr(13), $sqlString);
     } else {
         $sqlQueries = explode(";" . chr(10), $sqlString);
     }
     if (count($sqlQueries) > 0) {
         $db = Zend_Db_Table::getDefaultAdapter();
         foreach ($sqlQueries as $sql) {
             $sql = trim($sql);
             if ($sql !== "") {
                 $sqlResult = $db->query($sql);
                 $result = $result && $sqlResult;
             }
         }
     }
     return $result;
 }