public function indexAction() { $session = new Container('admin'); if ($session->offsetExists('email')) { //Prepare statistique information pour la vue Index ->des statistiques $adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $sql1 = "select * from pro_product_bdma"; $statement1 = $adapter->query($sql1); $results1 = $statement1->execute(); $row1 = $results1->current(); //tester si les variables rouX ont bien remplis if (!$row1) { //redirection vers l'index avec un message GET var $this->redirect()->toRoute('product', array('action' => 'index'), array('query' => array('status' => 'erreur_fetching_view_data'))); } else { // 2 preparation des donnees result sett , retourne un mass d'information if ($results1 instanceof ResultInterface && $results1->isQueryResult()) { //instanciation de la class result set pour l'enregistrement des information fournis par la BD $resultSet = new ResultSet(); $resultSet->initialize($results1); // redirection vers la vue index avec les information des statistiques return new ViewModel(array('data' => $resultSet)); } } } else { $this->redirect()->toRoute('admin', array('action' => 'login'), array('query' => array('status' => 'u_login'))); } }
public function indexAction() { // instansiation d'une session d'admin (duré = 30 Jrs) $session = new Container('useradmin'); // tester si une session 'email existe ' if ($session->offsetExists('uid') && $session->offsetExists('ucomp') && $session->offsetGet('user') == 'user') { //Prepare statistique information pour la vue Index ->des statistiques $adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $cmpny = $session->offsetGet('ucomp'); $sql1 = "select `id`, `gender`,`company`, `name`, `firstname`, `email`, `lang`, `phone`, `gsm` from pro_user where company='" . $cmpny . "' and active=1"; $statement1 = $adapter->query($sql1); $results1 = $statement1->execute(); $row1 = $results1->current(); //tester si les variables rouX ont bien remplis if (!$row1) { //redirection vers l'index avec un message GET var $this->redirect()->toRoute('useradmin', array('action' => 'index'), array('query' => array('status' => 'erreur_fetching_view_data'))); } else { // 2 preparation des donnees result sett , retourne un mass d'information if ($results1 instanceof ResultInterface && $results1->isQueryResult()) { //instanciation de la class result set pour l'enregistrement des information fournis par la BD $resultSet = new ResultSet(); $resultSet->initialize($results1); // redirection vers la vue index avec les information des statistiques return new ViewModel(array('data' => $resultSet)); } } } else { //si la session n'existe pas ,, donc la redirection vers login page pour l'authentification avec un petit message $this->redirect()->toRoute('useradmin', array('action' => 'loginuser'), array('query' => array('status' => 'u_login'))); } }
public function usersAction() { $session = new Container('admin'); if (!$session->offsetExists('email') || !isset($_GET['idcmp'])) { $this->redirect()->toRoute('admin', array('action' => 'login'), array('query' => array('status' => 'u_login'))); } $idcmp = $_GET['idcmp']; if (!$idcmp) { return $this->redirect()->toRoute('company'); } $adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $sql1 = "select * from pro_user where company=" . $_GET['idcmp']; $statement1 = $adapter->query($sql1); $results1 = $statement1->execute(); //tester si les variables rouX ont bien remplis if ($results1->count() <= 0) { //redirection vers l'index avec un message GET var $this->redirect()->toRoute('company', array('action' => 'index'), array('query' => array('status' => 'nouser'))); } else { // 2 preparation des donnees result sett , retourne un mass d'information if ($results1 instanceof ResultInterface && $results1->isQueryResult()) { //instanciation de la class result set pour l'enregistrement des information fournis par la BD $resultSet = new ResultSet(); $resultSet->initialize($results1); // redirection vers la vue index avec les information des statistiques return new ViewModel(array('data' => $resultSet)); } } }
/** * Get menu * * @return array */ public function getMenu() { // generate cache name $cacheName = CacheUtility::getCacheName(self::CACHE_ADMIN_MENU); // check data in cache if (null === ($menu = $this->staticCacheInstance->getItem($cacheName))) { $select = $this->select(); $select->from(['a' => 'application_admin_menu'])->columns(['name', 'controller', 'action'])->join(['b' => 'application_admin_menu_category'], 'a.category = b.id', ['category' => 'name', 'category_icon' => 'icon'])->join(['c' => 'application_admin_menu_part'], 'a.part = c.id', ['part' => 'name', 'part_icon' => 'icon'])->join(['d' => 'application_module'], new Expression('c.module = d.id and d.status = ?', [self::MODULE_STATUS_ACTIVE]), ['part_module' => 'name'])->join(['i' => 'application_module'], new Expression('b.module = i.id and i.status = ?', [self::MODULE_STATUS_ACTIVE]), ['category_module' => 'name'])->order('order'); $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); // process admin menu foreach ($resultSet as $menuItem) { if (!isset($menu[$menuItem['part']])) { $menu[$menuItem['part']] = ['part' => $menuItem['part'], 'icon' => $menuItem['part_icon'], 'module' => $menuItem['part_module'], 'items' => [0 => ['name' => $menuItem['name'], 'controller' => $menuItem['controller'], 'action' => $menuItem['action'], 'category' => $menuItem['category'], 'category_icon' => $menuItem['category_icon'], 'category_module' => $menuItem['category_module']]]]; } else { $menu[$menuItem['part']]['items'][] = ['name' => $menuItem['name'], 'controller' => $menuItem['controller'], 'action' => $menuItem['action'], 'category' => $menuItem['category'], 'category_icon' => $menuItem['category_icon'], 'category_module' => $menuItem['category_module']]; } } // save data in cache $this->staticCacheInstance->setItem($cacheName, $menu); $this->staticCacheInstance->setTags($cacheName, [self::CACHE_ADMIN_MENU_DATA_TAG]); } return $menu; }
protected function setUp() { $bootstrap = \Zend\Mvc\Application::init(include 'config/application.config.php'); $categoryData = array('id_category' => 1, 'name' => 'Project Manager'); $category = new Category(); $category->exchangeArray($categoryData); $resultSetCategory = new ResultSet(); $resultSetCategory->setArrayObjectPrototype(new Category()); $resultSetCategory->initialize(array($category)); $mockCategoryTableGateway = $this->getMock('Zend\\Db\\TableGateway\\TableGateway', array('select'), array(), '', false); $mockCategoryTableGateway->expects($this->any())->method('select')->with()->will($this->returnValue($resultSetCategory)); $categoryTable = new CategoryTable($mockCategoryTableGateway); $jobData = array('id_job' => 1, 'id_category' => 1, 'type' => 'typeTest', 'company' => 'companyTest', 'logo' => 'logoTest', 'url' => 'urlTest', 'position' => 'positionTest', 'location' => 'locaitonTest', 'description' => 'descriptionTest', 'how_to_play' => 'hotToPlayTest', 'is_public' => 1, 'is_activated' => 1, 'email' => 'emailTest', 'created_at' => '2012-01-01 00:00:00', 'updated_at' => '2012-01-01 00:00:00'); $job = new Job(); $job->exchangeArray($jobData); $resultSetJob = new ResultSet(); $resultSetJob->setArrayObjectPrototype(new Job()); $resultSetJob->initialize(array($job)); $mockJobTableGateway = $this->getMock('Zend\\Db\\TableGateway\\TableGateway', array('select'), array(), '', false); $mockJobTableGateway->expects($this->any())->method('select')->with(array('id_category' => 1))->will($this->returnValue($resultSetJob)); $jobTable = new JobTable($mockJobTableGateway); $this->controller = new IndexController($categoryTable, $jobTable); $this->request = new Request(); $this->routeMatch = new RouteMatch(array('controller' => 'index')); $this->event = $bootstrap->getMvcEvent(); $this->event->setRouteMatch($this->routeMatch); $this->controller->setEvent($this->event); $this->controller->setEventManager($bootstrap->getEventManager()); $this->controller->setServiceLocator($bootstrap->getServiceManager()); }
/** * Get time zones * * @return array */ public function getTimeZones() { // check data in a memory if (null !== self::$timeZones) { return self::$timeZones; } // generate a cache name $cacheName = CacheUtility::getCacheName(self::CACHE_TIME_ZONES); // check data in cache if (null === ($timeZones = $this->staticCacheInstance->getItem($cacheName))) { $select = $this->select(); $select->from('application_time_zone')->columns(['id', 'name'])->order('name'); $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); foreach ($resultSet as $timeZone) { $timeZones[$timeZone->id] = $timeZone->name; } // save data in cache $this->staticCacheInstance->setItem($cacheName, $timeZones); $this->staticCacheInstance->setTags($cacheName, [self::CACHE_TIME_ZONES_DATA_TAG]); } self::$timeZones = $timeZones; return $timeZones; }
public function testCallingBufferAfterIterationThrowsException() { $this->resultSet->initialize($this->getMock('Zend\\Db\\Adapter\\Driver\\ResultInterface')); $this->resultSet->current(); $this->setExpectedException('Zend\\Db\\ResultSet\\Exception\\RuntimeException', 'Buffering must be enabled before iteration is started'); $this->resultSet->buffer(); }
public function fetchAll() { # use a closure to manipulate the Select object /* $active = 1; $resultSet = $this->tableGateway->select( function (Select $select) use ($active) { //$select->columns(array('id', 'name', 'type')); $select->order('id DESC'); //$select->where(array('active'=> $active)); }); */ // return $resultSet; $adapter = $this->tableGateway->getAdapter(); $sql = new Sql($adapter); $select = $sql->select(); $select->from('pages'); $select->order('id DESC'); //$select->join('advertisement_type', 'advertisement.advertisement_type_id = advertisement_type.id ' , array('adType'=> 'name'),$type = self::JOIN_LEFT); $statement = $sql->prepareStatementForSqlObject($select); $rowset = $statement->execute(); $resultSet = new ResultSet(); $resultSet->initialize($rowset); return $resultSet; }
public function testToArrayCreatesArrayOfArraysRepresentingRows() { $count = rand(3, 75); $dataSource = $this->getArrayDataSource($count); $this->resultSet->initialize($dataSource); $test = $this->resultSet->toArray(); $this->assertEquals($dataSource->getArrayCopy(), $test, var_export($test, 1)); }
public function getMockAdapterWithResult($returnValue) { $resultSet = new ResultSet(); $resultSet->initialize($returnValue); $mockAdapter = $this->getMockAdapter(); $mockAdapter->expects($this->once())->method('query')->will($this->returnValue($resultSet)); return $mockAdapter; }
public function indexAction() { // instansiation d'une session d'admin (duré = 30 Jrs) $session = new Container('admin'); // tester si une session 'email existe ' if ($session->offsetExists('email') && $session->offsetGet('user') == 'admin') { //Prepare statistique information pour la vue Index ->des statistiques $adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $sql1 = "select COUNT(pro_user.id) AS 'a' FROM pro_user"; $sql2 = "select COUNT(pro_company.id) AS 'b' FROM pro_company"; $sql3 = "select COUNT(pro_invoice.id) AS 'c' FROM pro_invoice"; $sql4 = "select COUNT(pro_paid.id) AS 'd' FROM pro_paid"; $sql5 = "select COUNT(pro_product.id) AS 'e' FROM pro_product"; $sql6 = "select COUNT(pro_product_bdma.id_product_bdma) AS 'f' FROM pro_product_bdma"; $sql7 = "select * FROM product_bdma_price_history"; $statement1 = $adapter->query($sql1); $statement2 = $adapter->query($sql2); $statement3 = $adapter->query($sql3); $statement4 = $adapter->query($sql4); $statement5 = $adapter->query($sql5); $statement6 = $adapter->query($sql6); $statement7 = $adapter->query($sql7); $results1 = $statement1->execute(); $results2 = $statement2->execute(); $results3 = $statement3->execute(); $results4 = $statement4->execute(); $results5 = $statement5->execute(); $results6 = $statement6->execute(); $results7 = $statement7->execute(); $row1 = $results1->current(); $row2 = $results2->current(); $row3 = $results3->current(); $row4 = $results4->current(); $row5 = $results5->current(); $row6 = $results6->current(); // resultset7 vas être déclaré ci dessous pour plus de manipulation //tester si les variables rouX ont bien remplis if (!$row1 || !$row2 || !$row3 || !$row4 || !$row5 || !$row6) { //redirection vers l'index avec un message GET var $this->redirect()->toRoute('admin', array('action' => 'index'), array('query' => array('status' => 'erreur_fetching_statis_data'))); } else { // 1 preparation des données array list $statisticData = array('user' => $row1['a'], 'company' => $row2['b'], 'invoice' => $row3['c'], 'paid' => $row4['d'], 'product' => $row5['e'], 'productav' => $row6['f']); // 2 preparation des donnees result sett , retourne un mass d'information if ($results7 instanceof ResultInterface && $results7->isQueryResult()) { //instanciation de la class result set pour l'enregistrement des information fournis par la BD $resultSet = new ResultSet(); $resultSet->initialize($results7); // redirection vers la vue index avec les information des statistiques return new ViewModel(array('statistic' => $statisticData, 'history' => $resultSet)); } } } else { //si la session n'existe pas ,, donc la redirection vers login page pour l'authentification avec un petit message $this->redirect()->toRoute('admin', array('action' => 'login'), array('query' => array('status' => 'u_login'))); } }
/** * Check activation code * * @param integer $userId * @param string $activationCode * @return boolean */ public function checkActivationCode($userId, $activationCode) { $select = $this->select(); $select->from('user_list')->columns(['user_id'])->where(['user_id' => $userId, 'activation_code' => $activationCode]); $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); return $resultSet->current() ? true : false; }
/** * Get activated actions * * @return \Zend\Db\ResultSet\ResultSet */ public function getActivatedActions() { $select = $this->select(); $select->from(['a' => 'action_tracker_connection'])->columns(['action_id'])->join(['b' => 'application_event'], 'a.action_id = b.id', ['name'])->join(['c' => 'application_module'], new Expression('b.module = c.id and c.status = ?', [self::MODULE_STATUS_ACTIVE]), []); $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); return $resultSet; }
/** * Get images * * @param integer $category * @return \Zend\Db\ResultSet\ResultSet */ public function getImages($category) { $select = $this->select(); $select->from('slideshow_image')->columns(['id', 'description', 'image', 'url'])->where(['category_id' => $category])->order('order'); $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); return $resultSet; }
/** * Get messages * * @param integer $limit * @return \Zend\Db\ResultSet\ResultSet */ public function getMessages($limit) { $select = $this->select(); $select->from('application_email_queue')->columns(['id', 'email', 'title', 'message'])->limit($limit)->order('id'); $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); return $resultSet; }
/** * Get all empty transactions * * @param integer $limit * @return array */ public function getEmptyTransactions($limit) { $predicate = new Predicate(); $select = $this->select(); $select->from(['a' => 'payment_transaction_list'])->columns(['id', 'slug'])->join(['b' => 'payment_transaction_item'], 'a.id = b.transaction_id', [], 'left')->where([$predicate->isNull('b.transaction_id')])->group('a.id')->limit($limit); $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); return $resultSet->toArray(); }
/** * Get all expired memberships connections * * @param integer $limit * @return array */ public function getExpiredMembershipsConnections($limit) { $predicate = new Predicate(); $select = $this->select(); $select->from(['a' => 'membership_level_connection'])->columns(['id', 'user_id'])->join(['b' => 'membership_level'], 'a.membership_id = b.id', ['role_id'], 'left')->join(['c' => 'user_list'], 'a.user_id = c.user_id', ['nick_name', 'email', 'language'])->join(['d' => 'acl_role'], 'd.id = b.role_id', ['role_name' => 'name'], 'left')->limit($limit)->where(['a.active' => self::MEMBERSHIP_LEVEL_CONNECTION_ACTIVE, $predicate->lessThanOrEqualTo('a.expire_date', time())])->where->or->equalTo('a.active', self::MEMBERSHIP_LEVEL_CONNECTION_ACTIVE)->and->isNull('a.membership_id'); $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); return $resultSet->toArray(); }
protected function sequence($sequence) { return $this->generateCode(function () use($sequence) { $query = $this->getTableGateway()->adapter->getDriver()->createStatement("SELECT currval('{$sequence}') AS retorno")->execute(); $resultSet = new ResultSet(); $resultSet->initialize($query); $retorno = $resultSet->toArray(); return $retorno[0]['retorno']; }); }
public function getRegions() { $sql = $this->tableGateway->getSql(); $select = $sql->select(); $select->columns(array('region')); $statement = $sql->prepareStatementForSqlObject($select); $results = $statement->execute(); $rowset = new ResultSet(); return $rowset->initialize($results); }
/** * Get joined products * * @return ResultSet contains ProductJoinedRow */ public function getProductJoinedRows() { $pt = $this->getJoinedTable('ProductTable')->getTable(); $pdt = $this->getJoinedTable('ProductDescriptionTable')->getTable(); $select = $this->sql->select()->from("{$pt}")->columns(array("*"))->join($pdt, "{$pt}.product_id = {$pdt}.product_id", array('description'), Select::JOIN_LEFT)->order("{$pt}.product_id DESC"); $statement = $this->sql->prepareStatementForSqlObject($select); $resultSet = new ResultSet(ResultSet::TYPE_ARRAYOBJECT, new ProductJoinedRow()); $resultSet->initialize($statement->execute()); return $resultSet; }
public function getLinkArr() { $select = $this->sql->select(); $select->order(array('sort_order ASC')); //echo "<br><br>".$select->getSqlString($this->dbAdapter->getPlatform()); $statement = $this->sql->prepareStatementForSqlObject($select); $results = $statement->execute(); $rows = new ResultSet(); $arr = $rows->initialize($results)->toArray(); return $arr; }
public function select($where = null, $join = null, $cond = null, $cols = null, $order = "id ASC") { $select = $this->tableGateway->getSql()->select()->where($where)->order($order); if ($join != null) { $select->join($join, $cond, $cols); } $result = $this->tableGateway->getSql()->prepareStatementForSqlObject($select)->execute(); $rs = new ResultSet(); $rs->initialize($result); return $rs; }
/** * Is a role's name free * * @param string $roleName * @param integer $roleId * @return boolean */ public function isRoleNameFree($roleName, $roleId = 0) { $select = $this->select(); $select->from('acl_role')->columns(['id'])->where(['name' => $roleName]); if ($roleId) { $select->where([new NotInPredicate('id', [$roleId])]); } $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); return $resultSet->current() ? false : true; }
public function getIntitulesConditionReglement($sm) { $query = "SELECT intitule_condition_reglement\n FROM condition_reglement"; $statement = $sm->get('Zend\\Db\\Adapter\\Adapter')->query($query); $results = $statement->execute(); if ($results->isQueryResult()) { $resultSet = new ResultSet(); $resultSet->initialize($results); return $resultSet->toArray(); } return array(); }
public function testGet() { $mock = Mockery::mock('Zend\\Db\\TableGateway\\TableGateway'); $result = array(array('ISIN' => 'mc5B4ac9', 'trading_market' => 'Frankfurt', 'currency' => 'EUR', 'issuer' => 'Microsoft', 'issuing_price' => 20.0, 'current_price' => 25.0, 'type' => 1)); $resultSet = new ResultSet(); $resultSet->initialize($result); $mock->shouldReceive('select')->with(array('ISIN' => 'mc5B4ac9'))->once()->andReturn($resultSet); $table = new CertificateTable($mock); $realResult = $table->get('mc5B4ac9'); $this->assertInstanceOf('Application\\Model\\Certificate', $realResult); $this->assertEquals($realResult->getArrayCopy(), $result[0]); }
public function testgetUsuarioByItsId() { $usuario = new Usuario(); $usuario->exchangeArray(array('in_id' => 132, 'va_nombre' => 'kevin', 'va_apellidos' => 'castillo', 'va_email' => '*****@*****.**', 'va_contrasenia' => '123456', 'en_estado' => 'activo', 'Ta_rol_in_id' => 2)); $resultSet = new ResultSet(); $resultSet->setArrayObjectPrototype(new Usuario()); $resultSet->initialize(array($usuario)); $mockTableGateway = $this->getMock('Zend\\Db\\TableGateway\\TableGateway', array('select'), array(), '', false); $mockTableGateway->expects($this->once())->method('select')->with(array('in_id' => 132))->will($this->returnValue($resultSet)); $albumTable = new UsuarioTable($mockTableGateway); $this->assertSame($usuario, $albumTable->getUsuario(132)); }
/** * Is question free * * @param string $question * @param integer $questionId * @return boolean */ public function isQuestionFree($question, $questionId = 0) { $select = $this->select(); $select->from('poll_question')->columns(['id'])->where(['question' => $question, 'language' => $this->getCurrentLanguage()]); if ($questionId) { $select->where([new NotInPredicate('id', [$questionId])]); } $statement = $this->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $resultSet->initialize($statement->execute()); return $resultSet->current() ? false : true; }
public function fetchAll() { $adapter = $this->tableGateway->getAdapter(); $sql = new Sql($adapter); $select = $sql->select(); $select->from('interview_video'); $select->order('created_on DESC'); $statement = $sql->prepareStatementForSqlObject($select); $rowset = $statement->execute(); $resultSet = new ResultSet(); $resultSet->initialize($rowset); return $resultSet; }
public function fetchVendaTotal($id) { $sql = "select vt.total, \n\t\tvt.imposto \n\t\tfrom venda_total as vt \n\t\twhere vt.venda_id = ?"; $stmt = $this->adapter->createStatement($sql, array($id)); $stmt->prepare(); $result = $stmt->execute(); if ($result instanceof ResultInterface) { $resultSet = new ResultSet(); $resultSet->initialize($result); return $resultSet; } return false; }
public function fetchTotalizaByVenda($id) { $sql = "select iv.venda_id as venda_id,\n\t\t sum(iv.total) as total,\n\t\t sum(iv.imposto) as imposto\n\t\tfrom item_venda as iv\n\t\tinner join item it\n\t\ton it.id = iv.item_id\n\t\tinner join tipo ti\n\t\ton it.tipo_id = ti.id\n\t\tinner join imposto im\n\t\ton ti.imposto_id = im.id\n\t\twhere iv.venda_id = ?"; $stmt = $this->adapter->createStatement($sql, array($id)); $stmt->prepare(); $result = $stmt->execute(); if ($result instanceof ResultInterface && $result->isQueryResult()) { $resultSet = new ResultSet(); $resultSet->initialize($result); return $resultSet; } return false; }