/**
* @covers Zend\Db\Sql\Sql::delete
*/
public function testDelete()
{
$delete = $this->sql->delete();
$this->assertInstanceOf('Zend\\Db\\Sql\\Delete', $delete);
$this->assertSame('foo', $delete->getRawState('table'));
$this->setExpectedException('Zend\\Db\\Sql\\Exception\\InvalidArgumentException', 'This Sql object is intended to work with only the table "foo" provided at construction time.');
$this->sql->delete('bar');
}
/**
* @return $successfulArchive
*/
public function archive() : bool
{
if ($this->isArchivedTable()) {
// @todo: Replace pseudo code
$archived = !$this->sql->create($this->getArchivedTablename());
if ($archived) {
$archived = $archived && $this->delete();
if ($archived) {
$duplicate = false;
} else {
$duplicate = !$this->sql->delete($this->getArchivedTablename());
}
}
} else {
$archived = false;
}
if ($success) {
$this->record('arc_suc', RecordService::INFO, 'Archived entity successfully.', $this->data);
} elseif ($duplicate) {
$this->record('arc_err', RecordService::ERROR, 'Archiving ended up with duplicate data sets. ', $this->data);
} else {
$this->record('arc_fai', RecordService::ERROR, 'Archiving failed.', $this->data);
}
return (bool) $success;
}
/**
* Delete a record by predicate
*
* @param Where|\Closure|string|array|Predicate\PredicateInterface $predicate
* @param string $combination One of the OP_* constants from Predicate\PredicateSet
*
* @return integer the number of affected rows (can be be influenced by triggers or cascade)
*/
public function deleteBy($predicate, $combination = Predicate\PredicateSet::OP_AND)
{
$delete = $this->sql->delete($this->prefixed_table)->where($predicate, $combination);
$statement = $this->sql->prepareStatementForSqlObject($delete);
$result = $statement->execute();
return $result->getAffectedRows();
}
public function indexAction()
{
date_default_timezone_set('Asia/Dubai');
$auth = new AuthenticationService();
$container = new Container('username');
$sm = $this->getServiceLocator();
$dba = $sm->get($container->adapter);
$secsql = "SELECT * FROM section";
$secstatement = $dba->query($secsql, array(5));
$section = new ResultSet();
$section->initialize($secstatement);
$teasql = "SELECT * FROM teacher";
$teastatement = $dba->query($teasql, array(5));
$teacher = new ResultSet();
$teacher->initialize($teastatement);
if ($auth->hasIdentity() && $container->type == 0) {
if ($this->getRequest()->getPost('submit-update')) {
$count = (int) $this->getRequest()->getPost('rcount');
for ($i = 1; $i <= $count; $i++) {
$id = $this->getRequest()->getPost('rid' . $i);
$att = $this->getRequest()->getPost('rattendance' . $i);
$com = $this->getRequest()->getPost('rcomment' . $i);
$stup = $this->getRequest()->getPost('status-update' . $i);
if ($stup != 0) {
$data = array('counted' => $att, 'comment' => $com, 'Abs_value' => $stup);
$sql = new Sql($dba);
$update = $sql->update();
$update->table('attendance');
$update->set($data);
$update->where(array('Att_id' => $id));
$statement = $sql->prepareStatementForSqlObject($update);
$statement->execute();
} else {
$id = $this->getRequest()->getPost('rid' . $i);
$sql = new Sql($dba);
$delete = $sql->delete('attendance')->where(array('Att_id' => $id));
$statement = $sql->prepareStatementForSqlObject($delete);
$statement->execute();
}
}
$sday = $this->getRequest()->getPost('sdate-filter');
$eday = $this->getRequest()->getPost('edate-filter');
$syour_date = date("Y-m-d", strtotime($sday));
$eyour_date = date("Y-m-d", strtotime($eday));
return new ViewModel(array('attendance' => $this->getRepport($syour_date, $eyour_date, $this->getRequest()->getPost('stid-filter'), $this->getRequest()->getPost('tea-filter'), $this->getRequest()->getPost('sec-filter'), $this->getRequest()->getPost('p-filter'), $this->getRequest()->getPost('status-filter')), 'sections' => $section, 'teachers' => $teacher, 'message' => "Attendance report updated", 'sday' => $sday, 'eday' => $eday, 'stid' => $this->getRequest()->getPost('stid-filter'), 'tid' => $this->getRequest()->getPost('tea-filter'), 'secid' => $this->getRequest()->getPost('sec-filter'), 'pid' => $this->getRequest()->getPost('p-filter'), 'status' => $this->getRequest()->getPost('status-filter'), 'filter' => "Attendance report for " . $this->getRequest()->getPost('stid-filter') . " from " . date("l jS \\of F Y ", strtotime($sday)) . " to " . date("l jS \\of F Y ", strtotime($eday))));
} else {
if ($this->getRequest()->getPost('submit-date')) {
$sday = $this->getRequest()->getPost('sdate-filter');
$eday = $this->getRequest()->getPost('edate-filter');
$syour_date = date("Y-m-d", strtotime($sday));
$eyour_date = date("Y-m-d", strtotime($eday));
return new ViewModel(array('attendance' => $this->getRepport($syour_date, $eyour_date, $this->getRequest()->getPost('stid-filter'), $this->getRequest()->getPost('tea-filter'), $this->getRequest()->getPost('sec-filter'), $this->getRequest()->getPost('p-filter'), $this->getRequest()->getPost('status-filter')), 'sections' => $section, 'teachers' => $teacher, 'message' => "", 'sday' => $sday, 'eday' => $eday, 'stid' => $this->getRequest()->getPost('stid-filter'), 'tid' => $this->getRequest()->getPost('tea-filter'), 'secid' => $this->getRequest()->getPost('sec-filter'), 'pid' => $this->getRequest()->getPost('p-filter'), 'status' => $this->getRequest()->getPost('status-filter'), 'filter' => "Attendance report for " . $this->getRequest()->getPost('stid-filter') . " from " . date("l jS \\of F Y ", strtotime($sday)) . " to " . date("l jS \\of F Y ", strtotime($eday))));
} else {
return new ViewModel(array('attendance' => $this->getRepport(date('Y-m-d'), date('Y-m-d'), "", 0, 0, 0, 0), 'sections' => $section, 'teachers' => $teacher, 'message' => "", 'sday' => date('m/d/Y'), 'eday' => date('m/d/Y'), 'stid' => "", 'tid' => 0, 'secid' => 0, 'pid' => 0, 'status' => 0, 'filter' => "Attendance report for " . date("l jS \\of F Y ", strtotime(date('m/d/Y')))));
}
}
} else {
return $this->redirect()->toRoute('login', array('controller' => 'index', 'action' => 'login'));
}
}
/**
* Removes this record from the database
*/
protected function delete()
{
if ($this->getId()) {
$sql = new Sql(Database::getConnection(), $this->tablename);
$delete = $sql->delete()->where(['id' => $this->getId()]);
$sql->prepareStatementForSqlObject($delete)->execute();
}
}
public function cleanPriorForgotRequests($userId)
{
$sql = new Sql($this->getDbAdapter(), $this->tableName);
$delete = $sql->delete();
$delete->where->equalTo($this->userField, $userId);
$statement = $sql->prepareStatementForSqlObject($delete);
$statement->execute();
return true;
}
/**
* Delete
*
* @param Entity $entity Entity
*
* @return void
*/
public function delete(Entity $entity)
{
$delete = $this->_sql->delete();
$delete->from($entity->getTableName());
if ($entity->getPrimaryKey() && $entity->getId()) {
$delete->where([$entity->getPrimaryKey() => $entity->getId()]);
}
$this->_executeSql($this->_sql, $delete);
}
public function delete($where)
{
$delete = $this->sql->delete($this->_table);
$delete->where($where);
$result = $this->_execute($delete);
if ($result) {
return true;
}
return false;
}
/**
* Deletes a record.
* @param $id
* @throws Exception if no records are deleted
* @return $this
*/
public function delete($id)
{
$adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($adapter);
$delete = $sql->delete('room')->where(array('id' => $id));
$res = $sql->prepareStatementForSqlObject($delete)->execute();
if ($res->getAffectedRows() < 1) {
throw new \Exeption('Room not deleted: DB affected rows count=0.');
}
}
public function deleteById($cartItemId)
{
$sql = new Sql($this->getDbAdapter(), $this->tableName);
$where = new Where();
$where->equalTo($this->itemIdField, $cartItemId);
$delete = $sql->delete();
$delete->where($where);
$statement = $sql->prepareStatementForSqlObject($delete);
$result = $statement->execute();
return $result->getAffectedRows();
}
/**
* Delete
*
* @param Closure $where
* @return int
*/
public function delete($where)
{
$delete = $this->sql->delete();
if ($where instanceof \Closure) {
$where($delete);
} else {
$delete->where($where);
}
$statement = $this->sql->prepareStatementForSqlObject($delete);
$result = $statement->execute();
return $result->getAffectedRows();
}
/**
* Delete current Match for cancelation
* @param Integer $id
* @return array
*/
public function cancelMatch($id)
{
$sql = new Sql($this->dbAdapter);
$delete = $sql->delete('tblmatch');
$delete->where(array('matchID = ?' => $id));
$stmt = $sql->prepareStatementForSqlObject($delete);
$result = $stmt->execute();
if ($result instanceof ResultInterface) {
return array('canceled' => true);
}
return array('canceled' => false);
}
/**
* Delete
*
* @param Where|\Closure|string|array $where
* @return int
*/
public function delete($where)
{
if (!$this->isInitialized) {
$this->initialize();
}
$delete = $this->sql->delete();
if ($where instanceof \Closure) {
$where($delete);
} else {
$delete->where($where);
}
return $this->executeDelete($delete);
}
public function expireAction()
{
$verbose = $this->params()->fromRoute('verbose');
$db = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($db);
$delete = $sql->delete();
$delete->from('sessions')->where('expires < NOW()');
$statement = $sql->prepareStatementForSqlObject($delete);
$result = $statement->execute();
if ($result && $verbose) {
echo "Deleted " . number_format($result->count()) . " session(s)\n";
}
exit;
}
public function delete($id)
{
$adapter = $this->adapter;
$sql = new Sql($this->adapter);
$delete = $sql->delete('user_address');
$delete->from('user_address');
$delete->where(array('addr_id' => $id));
$statement = $sql->prepareStatementForSqlObject($delete);
try {
$affectedRows = $statement->execute()->getAffectedRows();
} catch (\Exception $e) {
die('Error: ' . $e->getMessage());
}
return true;
}
/**
* Delete
*
* @return int
*/
public function delete()
{
$this->initialize();
$where = array();
// primary key is always an array even if its a single column
foreach ($this->primaryKeyColumn as $pkColumn) {
$where[$pkColumn] = $this->primaryKeyData[$pkColumn];
}
// @todo determine if we need to do a select to ensure 1 row will be affected
$statement = $this->sql->prepareStatementForSqlObject($this->sql->delete()->where($where));
$result = $statement->execute();
if ($result->getAffectedRows() == 1) {
// detach from database
$this->primaryKeyData = null;
}
}
/**
* Grant right
*
* @param \Zend\Db\Sql\Sql $sql
* @param array $data
* @param bool $grant
* @return int
*/
private function grant(Sql\Sql $sql, array $data, $grant = true)
{
if ($grant) {
$select = $sql->select()->where($data);
$result = $sql->prepareStatementForSqlObject($select)->execute();
if ($result->getAffectedRows()) {
return 0;
} else {
$insert = $sql->insert()->values($data);
$result = $sql->prepareStatementForSqlObject($insert)->execute();
return $result->getAffectedRows();
}
} else {
$delete = $sql->delete()->where($data);
$result = $sql->prepareStatementForSqlObject($delete)->execute();
return $result->getAffectedRows();
}
}
public function deleteItem($arrParam = null, $options = null)
{
if ($options['task'] == 'list-images') {
return $this->tableGateway->select(function (Select $select) use($arrParam) {
$select->columns(array('id', 'avatar'));
$select->where(array('id' => $arrParam));
});
}
if ($options['task'] == 'delete-item') {
$this->tableGateway->delete(array('id' => $arrParam['id']));
}
if ($options['task'] == 'multi-delete-item') {
if (!empty($arrParam)) {
foreach ($arrParam as $key => $value) {
$this->tableGateway->delete(array('id' => $value));
}
}
}
if ($options['task'] == 'delete-real-estate-favorite') {
$sqlObj = new Sql($this->adapter);
$deleteObj = $sqlObj->delete('favorite_real_estate');
$deleteObj->where(new \Zend\Db\Sql\Predicate\In('id', array($arrParam['id'])));
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
}
}
/**
* Method remove migration from schema table
*
* @param string $module Module name
* @param string $migration Migration name
* @return $this
*/
protected function pullMigration($module, $migration)
{
if (null === $module) {
$module = '';
}
try {
$sql = new Sql($this->db);
$delete = $sql->delete($this->getMigrationsSchemaTable());
$delete->where(array('module' => $module, 'migration' => $migration));
$selectString = $sql->getSqlStringForSqlObject($delete);
$this->db->query($selectString, Adapter::QUERY_MODE_EXECUTE);
} catch (\Exception $e) {
// table is not exist
}
return $this;
}
/**
* Deletes a node plus it's children.
*/
public function deleteBranch($id)
{
if (!sizeof($row = $this->fetchRow(array('id' => $id)))) {
return false;
}
$sql = new Sql($this->getAdapter());
$delete = $sql->delete('resource');
$delete->where->between('left_id', $row->left_id, $row->right_id);
$statement = $sql->prepareStatementForSqlObject($delete);
$result = $statement->execute();
$result->getAffectedRows();
$update = $sql->update();
$update->table('resource');
$update->set(array('left_id' => new Expression("left_id - ROUND(" . $row->right_id . " - " . $row->left_id . " + 1)")));
$update->where->greaterThan('left_id', $row->right_id);
$statement = $sql->prepareStatementForSqlObject($update);
$result = $statement->execute();
$result->getAffectedRows();
$update = $sql->update();
$update->table('resource');
$update->set(array('right_id' => new Expression("right_id - ROUND(" . $row->right_id . " - " . $row->left_id . " + 1)")));
$update->where->greaterThan('right_id', $row->right_id);
$statement = $sql->prepareStatementForSqlObject($update);
$result = $statement->execute();
$result->getAffectedRows();
return true;
}
/**
* Deletes table rows based on a WHERE clause.
*
* @param mixed $table The table to update.
* @param mixed $where DELETE WHERE clause(s).
* @return int The number of affected rows.
*/
public function delete($table, $where = '')
{
$sql = new Sql($this);
$delete = $sql->delete($this->_getTableName($table));
$delete->where($where);
$sqlString = $sql->getSqlStringForSqlObject($delete);
$result = $this->query($sqlString);
return $result->count();
}
public function deleteItem($arrParam = null, $options = null)
{
if ($options['task'] == 'delete-item') {
$this->tableGateway->delete(array('id' => $arrParam['id']));
//Xóa xã, phường của quận. huyện
$sqlObj = new Sql($this->adapter);
$select = $sqlObj->select();
$select->from('city_district')->where('city_id = ' . $arrParam['id']);
$result = \ZendVN\Db\Sql\Result::toArray($select, $this->adapter);
foreach ($result as $value) {
$deleteObj = $sqlObj->delete('city_district_ward');
$deleteObj->where(new \Zend\Db\Sql\Predicate\In('district_id', array($value['id'])));
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
}
//Xóa quận, huyện của thành phố
$sqlObj = new Sql($this->adapter);
$deleteObj = $sqlObj->delete('city_district');
$deleteObj->where(new \Zend\Db\Sql\Predicate\In('city_id', array($arrParam['id'])));
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
}
if ($options['task'] == 'delete-item-ward') {
$sqlObj = new Sql($this->adapter);
$deleteObj = $sqlObj->delete('city_district_ward');
$deleteObj->where(new \Zend\Db\Sql\Predicate\In('id', array($arrParam['id'])));
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
}
if ($options['task'] == 'delete-item-district') {
$sqlObj = new Sql($this->adapter);
$deleteObj = $sqlObj->delete('city_district');
$deleteObj->where(new \Zend\Db\Sql\Predicate\In('id', array($arrParam['id'])));
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
//Xóa xã, phường của quận. huyện
$deleteObj = $sqlObj->delete('city_district_ward');
$deleteObj->where(new \Zend\Db\Sql\Predicate\In('district_id', array($arrParam['id'])));
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
}
}
public function deleteItem($arrParam = null, $options = null)
{
if ($options['task'] == 'list-images') {
return $this->tableGateway->select(function (Select $select) use($arrParam) {
$select->columns(array('id', 'logo'));
$select->where(array('id' => $arrParam));
});
}
if ($options['task'] == 'delete-folder') {
$this->tableGateway->delete(array('id' => $arrParam['id']));
$sqlObj = new Sql($this->adapter);
$deleteObj = $sqlObj->delete('manager_file');
$deleteObj->where('folder_id IN(' . $arrParam['id'] . ')');
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
}
if ($options['task'] == 'multi-delete-item-file') {
$sqlObj = new Sql($this->adapter);
$deleteObj = $sqlObj->delete('manager_file');
$deleteObj->where('id IN(' . $arrParam['id'] . ')');
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
}
if ($options['task'] == 'list-file') {
$sqlObj = new Sql($this->adapter);
$select = $sqlObj->select();
$select->from(array('mfile' => 'manager_file'))->join(array('mfolder' => 'manager_folder'), 'mfolder.id = mfile.folder_id', array('name_folder' => 'name'), $select::JOIN_LEFT);
$select->where('mfile.id IN(' . $arrParam['id'] . ')');
$sqlString = $sqlObj->getSqlStringForSqlObject($select);
$result = $this->adapter->query($sqlString)->execute();
return $result;
}
}
public function statementDeleteQuery()
{
$retorno = false;
/*
* VERIFICA SE O PARAMETRO FROM DA QUERY FOI DEFINIDO
*/
if (!empty(self::$varSqlFrom)) {
/*
* INICIALIZA A QUERY PELO ZEND_DB
*/
$sql = new Sql($this->getAdapter($this->varConfigAdapter));
$delete = $sql->delete();
/*
* VERIFICA E DEFINE O PARAMETRO WHERE DA QUERY
*/
if (!empty(self::$varSqlWhere) and count(self::$varSqlWhere) > 0) {
$arrayWhere = array();
foreach (self::$varSqlWhere as $key => $value) {
$arrayWhere[] = self::$varSqlWhere[$key]['where'];
}
$delete->where($arrayWhere);
}
/*
* DEFINE O PARAMETRO FROM DA QUERY
*/
foreach (self::$varSqlFrom as $key => $value) {
if (isset($value['alias']) and !empty($value['alias'])) {
$delete->from(array($value['alias'] => $value['table']));
} else {
$delete->from($value['table']);
}
}
/*
* MONTA QUERY PARA DEBUG
*/
$queryString = $sql->getSqlStringForSqlObject($delete);
if (self::$varDebug) {
$this->debugQuery($queryString);
} elseif (self::$varExplan) {
$this->explainQuery($queryString);
}
try {
$retorno = $sql->prepareStatementForSqlObject($delete);
} catch (\Zend\Db\Exception $exc) {
$this->closeConnection();
throw new \Exception('Não foi possivel executar o comando DELETE no banco de dados!<br /><br />' . $exc->getMessage(), 500);
}
} else {
$this->closeConnection();
throw new \Exception('O comando DELETE não foi definido corretamente!', 500);
}
$this->closeConnection();
self::freeMemory();
if ($this->varExecuteLog) {
$this->geraLogSistema($queryString, 'delete');
}
return $retorno;
}
/**
* Destroy Session - remove data from resource for
* given session id
*
* @param string $id
*/
public function destroy($id)
{
$sql = new Sql($this->getDb());
$delete = $sql->delete('sessions');
$delete->where(array('sessionID' => $id));
$statement = $sql->prepareStatementForSqlObject($delete);
$statement->execute();
}
/**
* Remove item by key
* @param string $normalizedKey
* @return bool
*/
protected function internalRemoveItem(&$normalizedKey)
{
$tableOptions = $this->getOptions()->getTable();
$sql = new Sql($this->getAdapter());
$delete = $sql->delete()->from($tableOptions->name)->where([$tableOptions->mapping['key'] => $this->getKey($normalizedKey)]);
$stmt = $sql->prepareStatementForSqlObject($delete);
return (bool) $stmt->execute();
}
public function deleteItem($arrParam = null, $options = null)
{
if ($options['task'] == 'delete-item') {
$this->tableGateway->delete(array('id' => $arrParam['id']));
}
if ($options['task'] == 'multi-delete-item-message-send') {
if (!empty($arrParam)) {
foreach ($arrParam as $key => $value) {
$sqlObj = new \Zend\Db\Sql\Sql($this->adapter);
$deleteObj = $sqlObj->delete('message_send');
$deleteObj->where(new \Zend\Db\Sql\Predicate\In('id', array($value)));
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
}
}
}
if ($options['task'] == 'multi-delete-item-message-receive') {
if (!empty($arrParam)) {
foreach ($arrParam as $key => $value) {
$sqlObj = new \Zend\Db\Sql\Sql($this->adapter);
$deleteObj = $sqlObj->delete('message_receive');
$deleteObj->where(new \Zend\Db\Sql\Predicate\In('id', array($value)));
$sqlString = $sqlObj->getSqlStringForSqlObject($deleteObj);
$this->adapter->query($sqlString)->execute();
}
}
}
}
public function deleteStudent($id)
{
$sql = new Sql($this->dbAdapter);
$insert = $sql->delete('students');
$insert->where(array('id =?' => $id));
$selectString = $sql->getSqlStringForSqlObject($insert);
return $this->dbAdapter->query($selectString, Adapter::QUERY_MODE_EXECUTE);
}
public function delete($adapter = array(), $table = '', $selected = array(), $where = '')
{
$sql = new Sql($adapter);
$debug_mode = false;
// $debug_mode = true;
$delete = $sql->delete($table);
if (is_array($where)) {
$delete->where($where);
} else {
$delete->where(array($where => $selected));
}
$affectedRows = 0;
$query = $sql->getSqlStringForSqlObject($delete);
if (!$debug_mode) {
$result = $adapter->query($query, $adapter::QUERY_MODE_EXECUTE);
$affectedRows += $result->count();
} else {
echo "*8* {$query}\n";
}
if (is_numeric($affectedRows)) {
$status = "success";
} else {
$status = "error";
$affectedRows = print_r($affectedRows, true);
}
$dataset = array('status' => $status, 'message' => _('Affected rows: ') . $affectedRows);
return $dataset;
}
/**
* Delete the instance presence from the database
*
* @throws \Thinkscape\ActiveRecord\Exception\RuntimeException
* @throws \Thinkscape\ActiveRecord\Exception\DatabaseException
* @return mixed
*/
public function delete()
{
// Check for ID
if (!$this->id) {
throw new Exception\RuntimeException('Attempt to reload() a record without an ID');
}
$db = $this->getDb();
$sql = new Sql($db);
// Prepare delete and run it
$delete = $sql->delete($this->getDbTable())->where(array('id' => $this->id));
$result = $db->query($delete->getSqlString($db->getPlatform()))->execute();
// Check if successful
if ($result->getAffectedRows() == 0) {
throw new Exception\DatabaseException(sprintf('Unable to delete record #%s in table %s (class %s)', $this->id, $this->getDbTable(), get_class($this)));
}
// Reset instance state
$this->isLoaded = false;
}
