public function saveItem($arrParam = null, $options = null)
{
if ($options['task'] == 'add') {
$sqlObj = new \Zend\Db\Sql\Sql($this->adapter);
$insertObj = $sqlObj->insert('service_account_register');
$insertObj->values($arrParam);
$sqlString = $sqlObj->getSqlStringForSqlObject($insertObj);
$this->adapter->query($sqlString)->execute();
}
if ($options['task'] == 'edit') {
$this->tableGateway->update($arrParam, array('id' => $arrParam['id']));
}
if ($options['task'] == 'multi-status') {
if (!empty($arrParam)) {
foreach ($arrParam['id'] as $key => $value) {
if ($arrParam['type'] == 'multi-active') {
$status = 1;
}
if ($arrParam['type'] == 'multi-in-active') {
$status = 0;
}
$data = array('id' => $value, 'status' => $status);
$this->tableGateway->update($data, array('id' => $value));
}
}
}
}
public function insert($data)
{
$insert = $this->sql->insert($this->_table);
$insert->values($data);
$result = $this->_execute($insert);
return $result->getGeneratedValue();
}
/**
* Adds a new record of the Room object in the database.
* @param Room $room - a populated object to add.
*/
public function addNew(Room $room)
{
$adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($adapter);
$insert = $sql->insert('room')->columns(array('number', 'name', 'building', 'attendant', 'posts'))->values(array('number' => $room->number, 'name' => $room->name, 'building' => $room->building, 'attendant' => $room->attendant, 'posts' => $room->posts));
$sql->prepareStatementForSqlObject($insert)->execute();
}
/**
* Saves a user to a database
*
* @param array $user
*/
public function saveUser(array $user)
{
$sql = new Sql($this->dbAdapter);
$insert = $sql->insert('users');
$insert->columns(array_keys($user))->values($user);
$sql->prepareStatementForSqlObject($insert)->execute();
}
/**
* @return bool $successfulCreate
*/
protected function create() : bool
{
$insert = $this->sql->insert($this->getTablename());
$id = $this->adapter->getDriver()->getConnection()->getLastGeneratedValue();
$this->load($id);
$success = true;
return $success;
}
public function addRole($serviceManager, $userRoleTable, $userIdField, $roleIdField, $userId, $roleId)
{
$adapter = $serviceManager->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($adapter);
$insert = $sql->insert()->into($userRoleTable)->columns(array($userIdField, $roleIdField))->values(array($userId, $roleId));
$sqlString = $sql->getSqlStringForSqlObject($insert);
$execute = $adapter->query($sqlString, $adapter::QUERY_MODE_EXECUTE);
return $execute;
}
public function insert($data)
{
$adapter = $this->adapter;
$sql = new Sql($this->adapter);
$insert = $sql->insert('item_price');
$insert->values($data);
$selectString = $sql->getSqlStringForSqlObject($insert);
return $results = $this->adapter->query($selectString, $adapter::QUERY_MODE_EXECUTE);
}
/**
*
* @param string $tableName
* @param array $data
* @return bool
*/
public function insert($tableName, array $data)
{
$sql = new Sql($this->adapter);
$insert = $sql->insert($tableName);
$insert->values($data);
$sqlString = $sql->getSqlStringForSqlObject($insert);
$results = $this->adapter->query($sqlString, Adapter::QUERY_MODE_EXECUTE);
return $results;
}
/**
* Insert
*
* @param array $set
* @return int
*/
public function insert($set)
{
if (!$this->isInitialized) {
$this->initialize();
}
$insert = $this->sql->insert();
$insert->values($set);
return $this->executeInsert($insert);
}
/**
* Insert
*
* @param array $set
* @return int
*/
public function insert($set)
{
$insert = $this->sql->insert();
$insert->values($set);
$statement = $this->sql->prepareStatementForSqlObject($insert);
$result = $statement->execute();
$this->lastInsertValue = $this->adapter->getDriver()->getConnection()->getLastGeneratedValue();
return $result->getAffectedRows();
}
public function createTransaction($data)
{
$adapter = $this->adapter;
$sql = new Sql($this->adapter);
$insert = $sql->insert('user_transaction');
$insert->values($data);
$selectString = $sql->getSqlStringForSqlObject($insert);
$results = $this->adapter->query($selectString, $adapter::QUERY_MODE_EXECUTE);
return array("trnx_id" => $results->getGeneratedValue());
}
public function create(array $data)
{
$sql = new Sql($this->adapter);
$this->adapter->getDriver()->getConnection()->beginTransaction();
$insert = $sql->insert('places');
$insert->values(['name' => $data['name'], 'latitude' => $data['latitude'], 'longitude' => $data['longitude']]);
$query = $sql->getSqlStringForSqlObject($insert);
/** @var Result $results */
$results = $this->adapter->query($query, Adapter::QUERY_MODE_EXECUTE);
$placeId = $results->getGeneratedValue();
foreach ($data['types'] as $typeId) {
$insert = $sql->insert('places_place_types');
$insert->values(['place_id' => $placeId, 'place_type_id' => $typeId]);
$q = $sql->getSqlStringForSqlObject($insert);
$this->adapter->query($q, Adapter::QUERY_MODE_EXECUTE);
}
$this->adapter->getDriver()->getConnection()->commit();
return $placeId;
}
/**
* Adds a new record of the Equipment object in the database.
* @param Equipment $equipment - a populated object to add.
*/
public function addNew(Equipment $equipment)
{
if (!$this->is_init()) {
throw new \Exception("Equipments collection uninitiated.");
}
$adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($adapter);
$insert = $sql->insert('equipment')->columns(array('cid', 'name', 'quantity', 'destiny', 'damaged', 'hire', 'adddate'))->values(array('cid' => $equipment->cid, 'name' => $equipment->name, 'quantity' => $equipment->quantity, 'destiny' => $equipment->destiny, 'damaged' => $equipment->damaged, 'hire' => $equipment->hire, 'adddate' => $equipment->adddate));
$sql->prepareStatementForSqlObject($insert)->execute();
}
public function create($id)
{
$sql = new Sql($this->getAdapter());
$insert = $sql->insert($this->getTableName());
$insert->values(['id' => (string) $id]);
$query = $sql->getSqlStringForSqlObject($insert);
/** @var Result $results */
$results = $this->adapter->query($query, Adapter::QUERY_MODE_EXECUTE);
return $results->getGeneratedValue();
}
public function saveHuntClubsHasPlayers($data)
{
$adapter = $this->tableGateway->getAdapter();
$sql = new Sql($adapter);
$insert = $sql->insert('hunt_clubs_has_players');
$insert->values($data);
$statement = $sql->prepareStatementForSqlObject($insert);
$results = $statement->execute();
$id = $adapter->getDriver()->getLastGeneratedValue();
return $id;
}
public function saveConsumables($data)
{
$dbAdapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($dbAdapter);
$insert = $sql->insert('weapon_consumables_has_players');
$insert->values($data);
$statement = $sql->prepareStatementForSqlObject($insert);
$results = $statement->execute();
$id = $dbAdapter->getDriver()->getLastGeneratedValue();
//print 'I am here !' . $id; exit();
return $id;
}
public function insert($data)
{
$adapter = $this->adapter;
$sql = new Sql($this->adapter);
$insert = $sql->insert('order_products');
$insert->values($data);
$selectString = $sql->getSqlStringForSqlObject($insert);
$results = $this->adapter->query($selectString, $adapter::QUERY_MODE_EXECUTE);
//if type package is there then reduce number of clothes and days
if ($results && $data['order_type'] == 'package') {
$this->updatePackage($data['order_id'], $data['quantity']);
}
}
/**
* Save
*
* @return integer
*/
public function save()
{
$this->initialize();
if ($this->rowExistsInDatabase()) {
// UPDATE
$data = $this->data;
$where = array();
// primary key is always an array even if its a single column
foreach ($this->primaryKeyColumn as $pkColumn) {
$where[$pkColumn] = $this->primaryKeyData[$pkColumn];
if ($data[$pkColumn] == $this->primaryKeyData[$pkColumn]) {
unset($data[$pkColumn]);
}
}
$statement = $this->sql->prepareStatementForSqlObject($this->sql->update()->set($data)->where($where));
$result = $statement->execute();
$rowsAffected = $result->getAffectedRows();
unset($statement, $result);
// cleanup
} else {
// INSERT
$insert = $this->sql->insert();
$insert->values($this->data);
$statement = $this->sql->prepareStatementForSqlObject($insert);
$result = $statement->execute();
if (($primaryKeyValue = $result->getGeneratedValue()) && count($this->primaryKeyColumn) == 1) {
$this->primaryKeyData = array($this->primaryKeyColumn[0] => $primaryKeyValue);
} else {
// make primary key data available so that $where can be complete
$this->processPrimaryKeyData();
}
$rowsAffected = $result->getAffectedRows();
unset($statement, $result);
// cleanup
$where = array();
// primary key is always an array even if its a single column
foreach ($this->primaryKeyColumn as $pkColumn) {
$where[$pkColumn] = $this->primaryKeyData[$pkColumn];
}
}
// refresh data
$statement = $this->sql->prepareStatementForSqlObject($this->sql->select()->where($where));
$result = $statement->execute();
$rowData = $result->current();
unset($statement, $result);
// cleanup
// make sure data and original data are in sync after save
$this->populate($rowData, true);
// return rows affected
return $rowsAffected;
}
public function save()
{
$sql = new Sql($this->adapter, TestRecord::TABLE);
$sqlObject = null;
if ($this->id) {
// update existing
$sqlObject = $sql->update()->set(["title" => $this->title, "created_on" => $this->created_on, "type" => $this->type])->where(["id" => $this->id]);
} else {
// insert new
$sqlObject = $sql->insert()->columns(["title", "created_on", "type"])->values(["title" => $this->title, "created_on" => $this->created_on, "type" => $this->type]);
}
$statement = $sql->prepareStatementForSqlObject($sqlObject);
$results = $statement->execute();
}
/**
* Writes the database back to the database
*/
protected function save()
{
$this->validate();
$zend_db = Database::getConnection();
$sql = new Sql($zend_db, $this->tablename);
if ($this->getId()) {
$update = $sql->update()->set($this->data)->where(array('id' => $this->getId()));
$sql->prepareStatementForSqlObject($update)->execute();
} else {
$insert = $sql->insert()->values($this->data);
$sql->prepareStatementForSqlObject($insert)->execute();
$this->data['id'] = $zend_db->getDriver()->getLastGeneratedValue();
}
}
/**
* Save
*
* @return integer
*/
public function save()
{
if (is_array($this->primaryKeyColumn)) {
// @todo compound primary keys
throw new Exception\RuntimeException('Compound primary keys are currently not supported, but are on the TODO list.');
}
if (isset($this->originalData[$this->primaryKeyColumn])) {
// UPDATE
$where = array($this->primaryKeyColumn => $this->originalData[$this->primaryKeyColumn]);
$data = $this->data;
unset($data[$this->primaryKeyColumn]);
$statement = $this->sql->prepareStatementForSqlObject($this->sql->update()->set($data)->where($where));
$result = $statement->execute();
$rowsAffected = $result->getAffectedRows();
unset($statement, $result); // cleanup
} else {
// INSERT
$insert = $this->sql->insert();
$insert->values($this->data);
$statement = $this->sql->prepareStatementForSqlObject($insert);
$result = $statement->execute();
$primaryKeyValue = $result->getGeneratedValue();
$rowsAffected = $result->getAffectedRows();
unset($statement, $result); // cleanup
$where = array($this->primaryKeyColumn => $primaryKeyValue);
}
// refresh data
$statement = $this->sql->prepareStatementForSqlObject($this->sql->select()->where($where));
$result = $statement->execute();
$rowData = $result->current();
unset($statement, $result); // cleanup
$this->populateOriginalData($rowData);
// return rows affected
return $rowsAffected;
}
/**
* 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 _insert(Servicos $servicos)
{
$adapter = $this->ConfAdapter();
$servicos = (array) $servicos;
$sql = new Sql($adapter);
if ($servicos['id'] == 0) {
$insert = $sql->insert('servicos')->values($servicos);
} else {
$insert = $sql->update('servicos')->set($servicos)->where(array('id' => $servicos['id']));
}
$sqlString = $sql->getSqlStringForSqlObject($insert);
$adapter->query($sqlString, Adapter::QUERY_MODE_EXECUTE);
$statement = $adapter->query('select id from servicos order by id desc limit 1');
$stm = $statement->execute();
foreach ($stm as $dados) {
$result = $dados['id'];
}
return $result;
}
public function refresh($user_id)
{
$adapter = $this->sm->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($adapter);
do {
//Generate new hash
$hash = Application\Model\Util::unique_id();
//Check if hash is taken
$select = $sql->select('tokens_table')->where(array('hash' => $hash));
$selectString = $sql->getSqlStringForSqlObject($select);
$results = $adapter->query($selectString, $adapter::QUERY_MODE_EXECUTE)->toArray()[0];
} while ($results);
//Disable old hashs
$update = $sql->update('tokens_table')->set(array('enabled' => 0))->where(array('user_id' => $user_id));
$selectString = $sql->getSqlStringForSqlObject($update);
$adapter->query($selectString, $adapter::QUERY_MODE_EXECUTE);
//Create new hash on table
$insert = $sql->insert('tokens_table')->values(array('user_id' => $user_id, 'hash' => $hash, 'enabled' => true));
$selectString = $sql->getSqlStringForSqlObject($insert);
$adapter->query($selectString, $adapter::QUERY_MODE_EXECUTE);
}
/**
* Store instance data in the database
*
* @throws \Thinkscape\ActiveRecord\Exception\DatabaseException
* @throws \Thinkscape\ActiveRecord\Exception\RuntimeException
* @return void
*/
public function save()
{
$db = $this->getDb();
$sql = new Sql($db);
if (!$this->id) {
// perform an INSERT operation
// Get the data
$updateData = $this->collectUpdateData();
// Prepare and execute INSERT
$insert = $sql->insert($this->getDbTable())->values($updateData);
$db->query($insert->getSqlString($db->getPlatform()), $db::QUERY_MODE_EXECUTE);
// Remember ID
if (!($this->id = $db->getDriver()->getLastGeneratedValue())) {
throw new Exception\DatabaseException(sprintf('Unable to retrieve INSERT id when trying to persist %s', get_class($this)));
}
// Store in registry
Core::storeInstanceInRegistry(get_called_class(), $this->id, $this);
} else {
// perform an UPDATE operation
if (!$this->isLoaded) {
throw new Exception\RuntimeException('Attempt to save() a record that has not been loaded');
}
// Get the data
$updateData = $this->collectUpdateData();
if (!count($updateData)) {
return;
// there is nothing to update
}
// Prepare and execute UPDATE
$insert = $sql->update($this->getDbTable())->set($updateData);
$result = $db->query($insert->getSqlString($db->getPlatform()))->execute();
// Check if successful
if ($result->getAffectedRows() == 0) {
throw new Exception\DatabaseException(sprintf('Unable to update record #%s in table %s (class %s)', $this->id, $this->getDbTable(), get_class($this)));
}
}
}
public function save($sm, $recid, $record, $where, $original = array(), $lastid = array(), $remove = array(), $centais = array(), $modifier = array())
{
/* $sm - in Controller $this->getServiceLocator();
* $recid - record ID in table
* $record - array of values to save. key: <table_name>-<field_name> value: <value>
* $where - where to save. key: <table_name>-<field_name> value: <key in $record array>
* $original - array of original form values. To check for duplicates where duplicates not alowed. Check performed if value in $original not equal to value in $record.
* key: <table_name_field_name>-<field_name> value: <value>
* $lastid - "prime record on insert" array. key: <where to use table>-<where to use field> value: <source table>-<source field>
* ! in $record's array "source" tables fields must be on top
* $remove - array of fields to delete and insert on edit action. key: <table_name>-<field_name> value: source of field value in form <table_name>-<field_name>
* $centais - array of fields to multiply by fixed values. key: <field_name> value: <fixed value>
* $modifier - if it not empty, 'modifier' and 'modified' fields are added to array of records
*
*/
$adapter = $sm->get('Zend\\Db\\Adapter\\Adapter');
$sql = new Sql($adapter);
$config = $sm->get('Config');
$tables = array();
foreach ($record as $key => $value) {
$parts = explode('-', $key);
if (isset($parts[1])) {
if (is_array($value) && !empty($value)) {
//-- if it 'enum' or 'list' field
if (isset($value[0]['id'])) {
//-- so it's 'enum'
foreach ($value as $ekey => $evalue) {
$tables[$parts[0]][$parts[1]][] = $evalue['id'];
}
} else {
//-- so it's 'list'
$tables[$parts[0]][$parts[1]] = $value['id'];
}
} else {
if (isset($centais[$parts[1]])) {
//--- if in cents array
(int) ($value = $value * $centais[$parts[1]]);
}
$tables[$parts[0]][$parts[1]] = $value;
}
}
}
if (!is_array($recid)) {
$r = array();
foreach ($tables as $key => $value) {
$r[$key] = $recid;
}
$recid = $r;
}
$removes = array();
foreach ($remove as $key => $value) {
$parts = explode('-', $key);
$vparts = explode('-', $value);
if (isset($parts[1]) && isset($vparts[1])) {
$removes[$parts[0]][$parts[1]] = $tables[$vparts[0]][$vparts[1]];
}
}
$lastids = array();
foreach ($lastid as $key => $value) {
$parts = explode('-', $key);
$vparts = explode('-', $value);
if (isset($parts[0]) && isset($vparts[1])) {
$lastids[$vparts[0]][$vparts[1]][$parts[0]] = $parts[1];
}
}
//-- to ensure that 'lastids' table in tables array goes first
if (!empty($lastids)) {
$tmp = array();
foreach ($lastids as $key => $value) {
if (array_key_exists($key, $tables)) {
$tmp[$key] = $tables[$key];
unset($tables[$key]);
}
}
foreach ($tables as $key => $value) {
$tmp[$key] = $value;
}
$tables = $tmp;
}
$wheres_orig = array();
foreach ($original as $key => $value) {
$parts = explode('-', $key);
if (isset($parts[0]) && isset($parts[1])) {
if (is_array($value)) {
//-- if that's a field of type 'list'
$value = $value['id'];
}
$wheres_orig[$parts[0]][$parts[1]] = $value;
}
}
$wheres_new = array();
foreach ($wheres_orig as $table => $array) {
foreach ($array as $key => $value) {
if (isset($tables[$table][$key])) {
$wheres_new[$table][$key] = $tables[$table][$key];
}
}
}
$wheres = array();
foreach ($where as $key => $value) {
$parts = explode('-', $key);
$vparts = explode('-', $value);
if (isset($parts[0]) && isset($parts[1]) && isset($tables[$vparts[0]][$vparts[1]])) {
$wheres[$parts[0]][$parts[1]] = $tables[$vparts[0]][$vparts[1]];
if (!empty($recid[$key])) {
unset($tables[$vparts[0]][$vparts[1]]);
}
}
}
$affectedRows = 0;
$debug_mode = false;
// $debug_mode = true; //-- uncoment if you just want to see queries in console; no writes to db performed
if ($debug_mode) {
echo "recid:\n";
print_r($recid);
echo "tables:\n";
print_r($tables);
echo "wheres:\n";
print_r($wheres);
echo "removes:\n";
print_r($removes);
echo "wheres_orig:\n";
print_r($wheres_orig);
echo "wheres_new:\n";
print_r($wheres_new);
echo "lastids:\n";
print_r($lastids);
// exit;
}
$primeids = array();
foreach ($tables as $table => $set) {
if (!empty($this->table_filter)) {
if (!isset($this->table_filter[$table])) {
continue;
}
}
if (in_array($table, $config['ACL_TABLES'])) {
$table_ident = new TableIdentifier($table, $config['ACL_DB']);
} else {
$table_ident = $table;
}
//-- non standart modifier and modified field names handling
if (!empty($modifier)) {
if (is_array($modifier)) {
if (isset($modifier[$table]['modifier_name'])) {
$set[$modifier[$table]['modifier_name']] = $modifier[$table]['modifier'];
}
if (isset($modifier[$table]['modified_name'])) {
$set[$modifier[$table]['modified_name']] = new Expression('NOW()');
}
} else {
$modifier = $sm->get('Zend\\Authentication\\AuthenticationService')->getIdentity()->id;
$set['modifier'] = $modifier;
$set['modified'] = new Expression('NOW()');
}
}
if (!$recid[$table] || isset($wheres_new[$table])) {
//-- so it is insert or edit with possibly changed required unicue fields
if (isset($wheres_orig[$table]) && $wheres_orig[$table] != $wheres_new[$table]) {
if ($this->duplicated($sm, $table_ident, $wheres_new[$table])) {
end($wheres_new[$table]);
$dataset = array('status' => 'success', 'validate' => array($table . '-' . key($wheres_new[$table]) => _('Record exists')));
return $dataset;
}
}
if ($recid[$table]) {
//-- if that is edit anyway
$dbobj = $sql->update($table_ident);
$dbobj->set($set);
foreach ($wheres[$table] as $where => $value) {
if (isset($wheres_orig[$table][$where])) {
$dbobj->where(array($where => $wheres_orig[$table][$where]));
} else {
$dbobj->where(array($where => $value));
}
}
} else {
//-- if to insert
$dbobj = $sql->insert($table_ident);
if (isset($primeids[$table])) {
$current = current($set);
foreach ($primeids[$table] as $key => $value) {
if (empty($value) && !empty($tables[$table][$key])) {
$value = $tables[$table][$key];
}
if (is_array($current)) {
foreach ($current as $cvalue) {
$set = array(key($set) => $cvalue, $key => $value);
$dbobj->values($set);
$query = $sql->getSqlStringForSqlObject($dbobj);
if (!$debug_mode) {
$result = $adapter->query($query, $adapter::QUERY_MODE_EXECUTE);
} else {
echo "*1* {$query}\n";
}
}
} else {
if (!array_filter($set)) {
continue;
}
$set[$key] = $value;
$dbobj->values($set);
$query = $sql->getSqlStringForSqlObject($dbobj);
if (!$debug_mode) {
$result = $adapter->query($query, $adapter::QUERY_MODE_EXECUTE);
} else {
echo "*2* {$query}\n";
}
}
}
continue;
}
$dbobj->values($set);
}
$query = $sql->getSqlStringForSqlObject($dbobj);
if (!$debug_mode) {
$result = $adapter->query($query, $adapter::QUERY_MODE_EXECUTE);
$affectedRows += $result->count();
} else {
echo "*3* {$query}\n";
}
if (isset($lastids[$table])) {
$lastId = $adapter->getDriver()->getLastGeneratedValue();
foreach ($lastids[$table] as $key => $value) {
foreach ($value as $key => $value) {
$primeids[$key][$value] = $lastId;
}
}
}
if (!$debug_mode) {
$affectedRows += $result->count();
}
} else {
//-- edit
if (isset($removes[$table])) {
//-- if have to delete existing records
$adapter->getDriver()->getConnection()->beginTransaction();
$insert_set = array();
$delete = $sql->delete($table_ident);
foreach ($removes[$table] as $where => $value) {
$insert_set[$where] = $value;
$delete->where("{$where} = '{$value}'");
}
$query = $sql->getSqlStringForSqlObject($delete);
if (!$debug_mode) {
$result = $adapter->query($query, $adapter::QUERY_MODE_EXECUTE);
$affectedRows += $result->count();
} else {
echo "*4* {$query}\n";
}
//-- so that's insert
foreach ($tables[$table] as $key => $set) {
if (empty($set)) {
continue;
}
if (!is_array($set)) {
//-- not an enum type field
$dbobj = $sql->insert($table_ident);
$dbobj->values(array_merge($tables[$table], $insert_set));
$query = $sql->getSqlStringForSqlObject($dbobj);
if (!$debug_mode) {
$result = $adapter->query($query, $adapter::QUERY_MODE_EXECUTE);
} else {
echo "*5* {$query}\n";
}
break;
} else {
foreach ($set as $ivalue) {
$dbobj = $sql->insert($table_ident);
$dbobj->values(array_merge(array($key => $ivalue), $insert_set));
$query = $sql->getSqlStringForSqlObject($dbobj);
if (!$debug_mode) {
$result = $adapter->query($query, $adapter::QUERY_MODE_EXECUTE);
} else {
echo "*6* {$query}\n";
}
}
}
}
$adapter->getDriver()->getConnection()->commit();
continue;
}
$update = $sql->update($table_ident);
$update->set($set);
foreach ($wheres[$table] as $where => $value) {
$update->where(array($where => $value));
}
$query = $sql->getSqlStringForSqlObject($update);
if (!$debug_mode) {
$result = $adapter->query($query, $adapter::QUERY_MODE_EXECUTE);
$affectedRows += $result->count();
} else {
echo "*7* {$query}\n";
}
}
}
$dataset = array('status' => 'success', 'message' => _('Affected rows: ') . $affectedRows);
if (!empty($lastId)) {
$dataset['last_id'] = $lastId;
}
return $dataset;
}
public function saveItem($arrParam = null, $options = null)
{
if ($options['task'] == 'user_send') {
$data = array('user_id_receive' => $arrParam['user_id_nhan'], 'name' => $arrParam['name'], 'content' => $arrParam['content'], 'date_time' => $arrParam['date_time'], 'user_id_send' => $arrParam['user_id_send']);
$sqlObj = new \Zend\Db\Sql\Sql($this->adapter);
$insertObj = $sqlObj->insert('message_send');
$insertObj->values($data);
$sqlString = $sqlObj->getSqlStringForSqlObject($insertObj);
$this->adapter->query($sqlString)->execute();
}
if ($options['task'] == 'user_receive') {
$data = array('user_id_send' => $arrParam['user_id_send'], 'name' => $arrParam['name'], 'content' => $arrParam['content'], 'date_time' => $arrParam['date_time'], 'user_id_receive' => $arrParam['user_id_nhan']);
$sqlObj = new \Zend\Db\Sql\Sql($this->adapter);
$insertObj = $sqlObj->insert('message_receive');
$insertObj->values($data);
$sqlString = $sqlObj->getSqlStringForSqlObject($insertObj);
$this->adapter->query($sqlString)->execute();
}
}
/**
* Insert entity data into the database
*
* @param string $class Class name of object being created
* @param array $data The data to insert
* @return int The ID of newly inserted record
*/
protected function injectDbWithEntityData($class, $data = [])
{
$table = $class::getStaticDbTable();
$adapter = $this->adapter;
$sql = new Sql($adapter);
$select = $sql->insert($table)->values($data);
$result = $adapter->query($select->getSqlString($adapter->getPlatform()))->execute();
$this->assertNotNull($result->getAffectedRows());
$id = $adapter->getDriver()->getLastGeneratedValue();
$this->assertTrue(is_numeric($id));
return (int) $id;
}
public function saveItem($arrParam = null, $options = null)
{
if ($options['task'] == 'add') {
$this->tableGateway->insert($arrParam);
return $this->tableGateway->lastInsertValue;
}
if ($options['task'] == 'edit') {
$this->tableGateway->update($arrParam, array('id' => $arrParam['id']));
}
if ($options['task'] == 'contact-me') {
$sqlObj = new Sql($this->adapter);
$insertObj = $sqlObj->insert('contact_real_estate');
$insertObj->values($arrParam);
$sqlString = $sqlObj->getSqlStringForSqlObject($insertObj);
$this->adapter->query($sqlString)->execute();
}
if ($options['task'] == 'save-real-estate-favorite') {
$sqlObj = new Sql($this->adapter);
$insertObj = $sqlObj->insert('favorite_real_estate');
$insertObj->values($arrParam);
$sqlString = $sqlObj->getSqlStringForSqlObject($insertObj);
$this->adapter->query($sqlString)->execute();
}
if ($options['task'] == 'multi-status') {
if (!empty($arrParam)) {
foreach ($arrParam['id'] as $key => $value) {
if ($arrParam['type'] == 'multi-active') {
$status = 1;
}
if ($arrParam['type'] == 'multi-in-active') {
$status = 0;
}
$data = array('id' => $value, 'status' => $status);
$this->tableGateway->update($data, array('id' => $value));
}
}
}
}
/**
* Method add migration to schema table
*
* @param string $module Module name
* @param string $migration Migration name
* @return $this
*/
protected function pushMigration($module, $migration)
{
if (null === $module) {
$module = '';
}
try {
$sql = new Sql($this->db);
$insert = $sql->insert($this->getMigrationsSchemaTable());
$insert->values(array('module' => $module, 'migration' => $migration));
$selectString = $sql->getSqlStringForSqlObject($insert);
$this->db->query($selectString, Adapter::QUERY_MODE_EXECUTE);
} catch (\Exception $e) {
// table is not exist
}
return $this;
}
