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