/** * Count items * @return int */ public function countAll($criteria = array()) { $select = $this->content->getTable()->getSql()->select()->columns(array(new \Zend\Db\Sql\Expression('COUNT(*)'))); $select = $this->setFilter($select, $criteria); $statement = $this->content->getTable()->getSql()->prepareStatementForSqlObject($select); $results = $statement->execute(); $resultSet = new \Zend\Db\ResultSet\ResultSet(); $resultSet->initialize($results); $data = $resultSet->current()->getArrayCopy(); return intval(array_pop($data)); }
/** * Count items * @return int */ public function countAll($criteria = array()) { $select = $this->content->getTable()->getSql()->select()->columns(array(new \Zend\Db\Sql\Expression('COUNT(*)'))); if (array_key_exists('filter', $criteria) && is_array($criteria['filter'])) { foreach ($criteria['filter'] as $field => $word) { if (is_string($word)) { $select->where($field . ' LIKE"' . addslashes($word) . '%"'); } } } $select = $this->setFilter($select, $criteria); $statement = $this->content->getTable()->getSql()->prepareStatementForSqlObject($select); $results = $statement->execute(); $resultSet = new \Zend\Db\ResultSet\ResultSet(); $resultSet->initialize($results); $data = $resultSet->current()->getArrayCopy(); return intval(array_pop($data)); }
<?php require __DIR__ . '/../include/pageboot.php'; $fName = 'php://stdout'; if (is_array($argv) && array_key_exists('1', $argv)) { $fName = $argv[1]; } $fh = fopen($fName, 'w'); $statement = $GLOBALS['db']->query(' SELECT * FROM `person_to_person` WHERE or_codFisc <> "" AND codFisc <> ""'); $resultSet = new \Zend\Db\ResultSet\ResultSet(); $resultSet->initialize($statement->execute()); fwrite($fh, '"OR","DEST"' . PHP_EOL); while ($resultSet->valid()) { $row = $resultSet->current(); fwrite($fh, '"' . $row['or_codFisc'] . '","' . $row['codFisc'] . '"' . PHP_EOL); $resultSet->next(); } fclose($fh);
<?php require __DIR__ . '/../include/pageboot.php'; $fName = 'php://stdout'; if (is_array($argv) && array_key_exists('1', $argv)) { $fName = $argv[1]; } $fh = fopen($fName, 'w'); $statement = $GLOBALS['db']->query(' SELECT * FROM `company_to_company` WHERE or_partIVA <> 0 AND dest_partIVA != ""'); $resultSet = new \Zend\Db\ResultSet\ResultSet(); $resultSet->initialize($statement->execute()); fwrite($fh, '"OR","DEST"' . PHP_EOL); while ($resultSet->valid()) { $row = $resultSet->current(); if (is_array($argv) && array_key_exists('2', $argv)) { $statement1 = $GLOBALS['db']->query(' SELECT COUNT(*) FROM `company` WHERE ( partIVA = "' . $row['or_partIVA'] . '" OR partIVA = "' . $row['dest_partIVA'] . '" ) AND ' . $argv[2]); $resultSet1 = new \Zend\Db\ResultSet\ResultSet(); $resultSet1->initialize($statement1->execute()); $c = $resultSet1->current(); if (current($c) == 0) { $resultSet->next(); continue; } } fwrite($fh, '"' . $row['or_partIVA'] . '","' . $row['dest_partIVA'] . '"' . PHP_EOL); $resultSet->next(); } fclose($fh);