/** * 将数据添加到数据库 * @return boolean */ public function insertAction() { /** * 记录日志 */ $log = "游戏类别添加入库\n\nServerIp:\n" . $this->request->getServer('SERVER_ADDR') . "\n\nGET:\n" . var_export($_GET, true) . "\n\nPOST:\n" . var_export($_POST, true); $this->oLogManager->push('log', $log); //检查权限 $this->manager->checkMenuPermission($this->sign, Widget_Manager::MENU_PURVIEW_INSERT); $params = $this->request->from('name', 'desc'); if (empty($params['name'])) { $response = array('errno' => 1); echo json_encode($response); return false; } if ($this->oClass->nameExists($params['name'])) { $response = array('errno' => 2); echo json_encode($response); return false; } $res = $this->oClass->insert($params); $response = $res ? array('errno' => 0) : array('errno' => 9); echo json_encode($response); return true; }
/** * Test role synchronisation */ public function testRoleSynchronisation() { // create a first test ACL role $query = $this->model->insert()->into('acl_role')->values(['name' => 'test role 1']); $statement = $this->model->prepareStatementForSqlObject($query); $statement->execute(); $this->aclRolesIds[] = $this->model->getAdapter()->getDriver()->getLastGeneratedValue(); // create a test user $query = $this->model->insert()->into('user_list')->values(['nick_name' => Rand::getString(32), 'email' => Rand::getString(32), 'role' => $this->aclRolesIds[0]]); $statement = $this->model->prepareStatementForSqlObject($query); $statement->execute(); $this->usersIds[] = $this->model->getAdapter()->getDriver()->getLastGeneratedValue(); // delete the created ACL role $query = $this->model->delete()->from('acl_role')->where(['id' => $this->aclRolesIds[0]]); $statement = $this->model->prepareStatementForSqlObject($query); $statement->execute(); // fire the delete ACL role event AclEvent::fireDeleteAclRoleEvent($this->aclRolesIds[0]); // check the created test user's role $select = $this->model->select(); $select->from('user_list')->columns(['role'])->where(['user_id' => $this->usersIds[0]]); $statement = $this->model->prepareStatementForSqlObject($select); $resultSet = new ResultSet(); $result = $resultSet->initialize($statement->execute()); // user must be a default member $this->assertEquals($result->current()['role'], AclBaseModel::DEFAULT_ROLE_MEMBER); }
public function create($insert_array) { try { $this->db->insert("`" . $this->table . "`", $insert_array); return $this->db->lastInsertId(); } catch (Exception $e) { return false; } }
public function insertAction() { $bind = $this->request->from('name', 'currency_rate', 'is_abroad'); $bind['is_abroad'] = $bind['is_abroad'] ? $bind['is_abroad'] : 1; $res = $this->oArea->insert($bind); $response = $res ? array('errno' => 0) : array('errno' => 9); echo json_encode($response); return true; }
/** * Saves user data into the users table * @param $data * @return bool */ public function saveData($data) { try { $this->tableGateway->insert($data); return true; } catch (\Exception $e) { return false; } }
public function insertAction() { $bind = $this->request->from('ResearchName', 'ResearchContent'); if ($bind['ResearchName'] == '') { $response = array('errno' => 3); } else { $res = $this->oResearch->insert($bind); $response = $res ? array('errno' => 0) : array('errno' => 9); } echo json_encode($response); return true; }
/** * This function update and insert user record * @param \Music\Model\User $user * @throws \Exception */ public function saveUser(User $user, $user_id) { $data = array('username' => $user->getUsername(), 'password' => md5($user->getPassword()), 'role' => $user->getRole(), 'fullname' => $user->getFullName()); $user_id = (int) $user->getUserId(); if (!$user_id) { $this->tableGateway->insert($data); } else { if ($user_id) { $this->tableGateway->update($data, array('user_id' => $user_id)); } else { throw new \Exception('Form id does not exist'); } } }
public function insertAction() { //检查权限 $this->manager->checkMenuPermission($this->sign, Widget_Manager::MENU_PURVIEW_INSERT); $bind = $this->request->from('name', 'SourceTypeId'); if ($bind['name'] == '') { $response = array('errno' => 2); } else { $res = $this->oSourceType->insert($bind); $response = $res ? array('errno' => 0) : array('errno' => 9); } echo json_encode($response); return true; }
/** * Returns the template bit * * @access public * @return string */ public function getTemplate() { //----------------------------------------- // Clear old //----------------------------------------- $this->_clearSessions($this->member->ip_address); //----------------------------------------- // Create new ID //----------------------------------------- $captcha_unique_id = md5(uniqid(time())); $captcha_string = ""; //----------------------------------------- // Create new string //----------------------------------------- /** * Array of characters * Removed: 0, o, O, 1, l, I, i, L (because they're hard to differentiate) */ $array_of_chars = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'j', 'k', 'm', 'n', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'J', 'K', 'M', 'N', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '2', '3', '4', '5', '6', '7', '8', '9'); /* Get 6 random characters */ for ($i = 0; $i < 6; $i++) { $idx = mt_rand(0, count($array_of_chars) - 1); $captcha_string .= $array_of_chars[$idx]; } //----------------------------------------- // Add to the DB //----------------------------------------- $this->DB->insert('captcha', array('captcha_unique_id' => $captcha_unique_id, 'captcha_string' => $captcha_string, 'captcha_ipaddress' => $this->member->ip_address, 'captcha_date' => time())); /* Make available */ $this->captchaKey = $captcha_unique_id; //----------------------------------------- // Return Template Bit //----------------------------------------- return $this->registry->output->getTemplate('global_other')->captchaGD($captcha_unique_id); }
/** * Populate the donation stats for every day of the current fundraiser * * Note that if you are running more than one fundraiser at once, you'll want to use * populateDays instead of updateDays. * Note that these summaries exclude amounts that are not between the mimumum and maximum * donation amounts. This is because every once in a while we have to condense multiple * donations that may span several days into a single donation for CiviCRM consumption. */ public function updateDays() { global $egFundraiserStatisticsFundraisers, $egFundraiserStatisticsMinimum, $egFundraiserStatisticsMaximum; $mostRecentFundraiser = end($egFundraiserStatisticsFundraisers); $start = $mostRecentFundraiser['start']; $end = $mostRecentFundraiser['end']; $begin = time(); $records = 0; $insertArray = array(); $this->output("Writing data to public_reporting_days...\n"); $conditions = array('received >= ' . $this->dbpr->addQuotes(wfTimestamp(TS_UNIX, strtotime($start))), 'received <= ' . $this->dbpr->addQuotes(wfTimestamp(TS_UNIX, strtotime($end) + 24 * 60 * 60)), 'converted_amount >= ' . $egFundraiserStatisticsMinimum, 'converted_amount <= ' . $egFundraiserStatisticsMaximum); // Get the data for a fundraiser $result = $this->dbpr->select('public_reporting', array("DATE_FORMAT( FROM_UNIXTIME( received ),'%Y-%m-%d' ) AS date", 'sum( converted_amount ) AS total', 'count( * ) AS number', 'avg( converted_amount ) AS average', 'max( converted_amount ) AS maximum'), $conditions, __METHOD__, array('ORDER BY' => 'received', 'GROUP BY' => "DATE_FORMAT( FROM_UNIXTIME( received ),'%Y-%m-%d' )")); while ($row = $this->dbpr->fetchRow($result)) { // Add it to the insert array $insertArray[] = array('prd_date' => $row['date'], 'prd_total' => $row['total'], 'prd_number' => $row['number'], 'prd_average' => $row['average'], 'prd_maximum' => $row['maximum'], 'prd_insert_timestamp' => time()); $records++; } if ($records > 0) { // Empty the table of previous totals for this fundraiser $res = $this->dbw->delete('public_reporting_days', array('prd_date >= ' . $this->dbpr->addQuotes(wfTimestamp(TS_DB, strtotime($start))), 'prd_date <= ' . $this->dbpr->addQuotes(wfTimestamp(TS_DB, strtotime($end))))); // Insert the new totals $res = $this->dbw->insert('public_reporting_days', $insertArray, __METHOD__); // Wait for the databases to sync wfWaitForSlaves(); } $lag = time() - $begin; $this->output("Updated " . $records . " rows. ({$lag} seconds)\n"); $this->output("Done.\n"); }
/** * Add a new element in the tree near element with number id. * * @param integer $ID Number of a parental element * @param array $condition Array structure: array('and' => array('id = 0', 'id2 >= 3'), 'or' => array('sec = \'www\'', 'sec2 <> \'erere\'')), etc where array key - condition (AND, OR, etc), value - condition string * @param array $data Contains parameters for additional fields of a tree (if is): array('filed name' => 'importance', etc) * @return integer Inserted element id */ function InsertNear($ID, $condition = '', $data = array()) { $node_info = $this->GetNodeInfo($ID); if (FALSE === $node_info) { return FALSE; } list($leftId, $rightId, $level, $parent) = $node_info; $data[$this->table_left] = $rightId + 1; $data[$this->table_right] = $rightId + 2; $data[$this->table_level] = $level; $data[$this->table_parent] = $section_id; if (!empty($condition)) { $condition = $this->_PrepareCondition($condition); } $sql = 'UPDATE ' . $this->table . ' SET ' . $this->table_left . ' = CASE WHEN ' . $this->table_left . ' > ' . $rightId . ' THEN ' . $this->table_left . ' + 2 ELSE ' . $this->table_left . ' END, ' . $this->table_right . ' = CASE WHEN ' . $this->table_right . '> ' . $rightId . ' THEN ' . $this->table_right . ' + 2 ELSE ' . $this->table_right . ' END, ' . $this->table_parent . ' = ' . $parent . 'WHERE ' . $this->table_right . ' > ' . $rightId; $sql .= $condition; //$this->db->beginTransaction(); //try{ $res = $db->query($sql); $this->db->insert($this->table, $data); $id = $this->db->lastInsertId(); //$this->db->commit(); return $id; //} //catch (Exception $e){ //$this->db->rollBack(); //} }
/** * private method that handles creating new default templates * * @param string $template_pack This corresponds to a template pack class reference which will contain information about where to obtain the templates. * @return mixed (array|bool) success array or false. */ private function _create_new_templates($template_pack) { $this->_set_templates($template_pack); //necessary properties are set, let's save the default templates if (empty($this->_GRP_ID)) { $main_template_data = array('MTP_messenger' => $this->_messenger->name, 'MTP_message_type' => $this->_message_type->name, 'MTP_is_override' => 0, 'MTP_deleted' => 0, 'MTP_is_global' => 1, 'MTP_user_id' => EEH_Activation::get_default_creator_id(), 'MTP_is_active' => 1); //let's insert the above and get our GRP_ID, then reset the template data array to just include the GRP_ID $grp_id = $this->_EEM_data->insert($main_template_data); if (empty($grp_id)) { return $grp_id; } $this->_GRP_ID = $grp_id; } $template_data = array('GRP_ID' => $this->_GRP_ID); foreach ($this->_contexts as $context => $details) { foreach ($this->_fields as $field => $field_type) { if ($field != 'extra') { $template_data['MTP_context'] = $context; $template_data['MTP_template_field'] = $field; $template_data['MTP_content'] = $this->_templates[$context][$field]; $MTP = EEM_Message_Template::instance()->insert($template_data); if (!$MTP) { EE_Error::add_error(sprintf(__('There was an error in saving new template data for %s messenger, %s message type, %s context and %s template field.', 'event_espresso'), $this->_messenger->name, $this->_message_type->name, $context, $field), __FILE__, __FUNCTION__, __LINE__); return false; } } } } $success_array = array('GRP_ID' => $this->_GRP_ID, 'MTP_context' => key($this->_contexts)); return $success_array; }
/** * insert a new config in the database * * @param object &$config reference to the {@link XoopsConfigItem} */ function insertConfig(&$config) { if (!$this->_cHandler->insert($config)) { return false; } $options =& $config->getConfOptions(); $count = count($options); $conf_id = $config->getVar('conf_id'); for ($i = 0; $i < $count; $i++) { $options[$i]->setVar('conf_id', $conf_id); if (!$this->_oHandler->insert($options[$i])) { foreach ($options[$i]->getErrors() as $msg) { $config->setErrors($msg); } } } if (!empty($this->_cachedConfigs[$config->getVar('conf_modid')][$config->getVar('conf_catid')])) { unset($this->_cachedConfigs[$config->getVar('conf_modid')][$config->getVar('conf_catid')]); } xoops_load("cache"); $key = "config_" . intval($config->getVar('conf_modid')) . "_" . intval($config->getVar('conf_catid')); if (XoopsCache::read($key)) { XoopsCache::delete($key); } return true; }
/** * Save news object to data source * * @param integer $id news identifier * @param array $data news data * @param string $file_name file name of news image upload * @param string $video_name file name of news video upload * @return integer */ public function save_news($id, $data, $file_name = "", $video_name = "") { if (empty($id)) { if (empty($data["date_add"])) { $data["date_add"] = date("Y-m-d H:i:s"); } $this->DB->insert(NEWS_TABLE, $data); $id = $this->DB->insert_id(); } else { $this->DB->where('id', $id); $this->DB->update(NEWS_TABLE, $data); } if (!empty($file_name) && !empty($id) && isset($_FILES[$file_name]) && is_array($_FILES[$file_name]) && is_uploaded_file($_FILES[$file_name]["tmp_name"])) { $news_data = $this->get_news_by_id($id); $news_data = $this->format_single_news($news_data); $this->CI->load->model("Uploads_model"); $img_return = $this->CI->Uploads_model->upload($this->upload_config_id, $news_data["prefix"], $file_name); if (empty($img_return["errors"])) { $img_data["img"] = $img_return["file"]; $this->save_news($id, $img_data); } } if (!empty($video_name) && !empty($id) && isset($_FILES[$video_name]) && is_array($_FILES[$video_name]) && is_uploaded_file($_FILES[$video_name]["tmp_name"])) { if (!isset($news_data)) { $news_data = $this->get_news_by_id($id); $news_data = $this->format_single_news($news_data); } $this->CI->load->model("Video_uploads_model"); $video_data = array("name" => $news_data["name"], "description" => $news_data["annotation"]); $video_return = $this->CI->Video_uploads_model->upload($this->video_config_id, $news_data["prefix"], $video_name, $id, $video_data); } return $id; }
/** * Save alert * @param array $data * @return boolean */ public function save_alert($id, $data) { if (!$id) { $data["date_add"] = date("Y-m-d H:i:s"); $this->DB->insert(SPAM_ALERTS_TABLE, $data); $id = $this->DB->insert_id(); $type = $this->Spam_type_model->get_type_by_id($data['id_type']); $save_data['obj_count'] = $type["obj_count"] + 1; $save_data['obj_need_approve'] = $type["obj_need_approve"] + 1; $this->CI->Spam_type_model->save_type($type['id'], $save_data); } else { $fields = array_flip($this->fields); foreach ($data as $key => $value) { if (!isset($fields[$key])) { unset($data[$key]); } } if (empty($data)) { return false; } $this->DB->where("id", $id); $this->DB->update(SPAM_ALERTS_TABLE, $data); } return $id; }
/** * 将数据入库 * @return unknown_type */ public function insertAction() { /** * 记录日志 */ $log = "合作商添加入库\n\nServerIp:\n" . $this->request->getServer('SERVER_ADDR') . "\n\nGET:\n" . var_export($_GET, true) . "\n\nPOST:\n" . var_export($_POST, true); $this->oLogManager->push('log', $log); //检查权限 $this->manager->checkMenuPermission($this->sign, Widget_Manager::MENU_PURVIEW_INSERT); $bind = $this->request->from('name', 'notes'); if (!empty($this->request->newid)) { $bind['PartnerId'] = $this->request->newid; } if (!empty($bind['notes'])) { $bind['notes'] = json_encode($bind['notes']); } if (empty($bind['name'])) { $response = array('errno' => 2); echo json_encode($response); return false; } $res = $this->oPartner->insert($bind); if ($res) { $response = array('errno' => 0); $this->oPartner->reBuildPartnerConfig(); } else { $response = array('errno' => 9); } echo json_encode($response); return true; }
/** * Save promo object to data source * * @param integer $id_lang language identifier * @param array $data promo data * @param string $img_file photo upload * @param string $flash_file flash upload * @return */ public function save_promo($id_lang, $data, $img_file = '', $flash_file = '') { if (!$id_lang) { return false; } $data['id_lang'] = $id_lang; if (!$this->exists_promo($id_lang)) { $this->DB->insert(CONTENT_PROMO_TABLE, $data); } else { $this->DB->where('id_lang', $id_lang); $this->DB->update(CONTENT_PROMO_TABLE, $data); } if (!empty($img_file) && isset($_FILES[$img_file]) && is_array($_FILES[$img_file]) && is_uploaded_file($_FILES[$img_file]["tmp_name"])) { $this->CI->load->model("Uploads_model"); $img_return = $this->CI->Uploads_model->upload($this->upload_gid, $id_lang . "/", $img_file); if (empty($img_return["errors"])) { $img_data["promo_image"] = $img_return["file"]; $this->save_promo($id_lang, $img_data); } } if (!empty($flash_file) && isset($_FILES[$flash_file]) && is_array($_FILES[$flash_file]) && is_uploaded_file($_FILES[$flash_file]["tmp_name"])) { $this->CI->load->model("File_uploads_model"); $flash_return = $this->CI->File_uploads_model->upload($this->file_upload_gid, $id_lang . "/", $flash_file); if (empty($flash_return["errors"])) { $flash_data["promo_flash"] = $flash_return["file"]; $this->save_promo($id_lang, $flash_data); } } return true; }
/** * Add link * @param string $type_gid * @param integer $link_1 * @param integer $link_2 */ public function add_link($type_gid, $link_1, $link_2) { $link_1 = intval($link_1); $link_2 = intval($link_2); if (!$link_1 || !$link_2) { return false; } $type = $this->get_linker_type_by_gid($type_gid); if (!$type) { return false; } if ($type["unique_type"] != 'no') { //// need to get links count, if links are unique $link_count = $this->get_links_simple_count($type_gid, $link_1, $link_2); } if ($type["unique_type"] == 'no' || $link_count == 0) { $data = array('id_link_1' => $link_1, 'id_link_2' => $link_2, 'date_add' => date("Y-m-d H:i:s")); if (!$type["separated"]) { $data["id_type"] = $type["id"]; } $this->DB->insert($type["table_name"], $data); } elseif ($type["unique_type"] == 'update') { if (!$type["separated"]) { $this->DB->where('id_type', $type["id"]); } $this->DB->where('id_link_1', $link_1); $this->DB->where('id_link_2', $link_2); $data = array('date_add' => date("Y-m-d H:i:s")); $this->DB->update($type["table_name"], $data); } return; }
/** * Test acl by date */ public function testAclByDate() { $role = AclModelBase::DEFAULT_ROLE_MEMBER; $testResources = ['test_application_settings_administration', 'test_application_modules_administration']; $this->addAclResources($testResources, true, $role); $currentTime = time(); // add acl resources connections settings foreach ($this->aclResourcesConnections as $connectId) { $query = $this->aclModelBase->insert()->into('acl_resource_connection_setting')->values(['connection_id' => $connectId, 'user_id' => $this->userId, 'date_start' => $currentTime, 'date_end' => $currentTime + 1]); $statement = $this->aclModelBase->prepareStatementForSqlObject($query); $statement->execute(); } $this->initAcl($role); // all created acl resources must be active foreach ($testResources as $resource) { $this->assertTrue(AclService::checkPermission($resource)); } // wait two seconds and check acl resources again sleep(2); $this->initAcl($role); // now all created acl resources must be expired foreach ($testResources as $resource) { $this->assertFalse(AclService::checkPermission($resource)); } }
/** * 新增数据 * * @author liu21st <*****@*****.**> * @lastmodify 2013-01-21 14:47:00 by mrmsl * * @param mixed $data 数据 * @param array $options 参数表达式 * @param boolean $replace 是否replace * * @return bool|int 新增成功,返回true或自增id,否则返回false */ public function add($data = '', $options = array(), $replace = false) { if (empty($data)) { if (!empty($this->_data)) { //没有传递数据,获取当前数据对象的值 $data = $this->_data; $this->_data = array(); //重置数据 } else { $this->_error = L('_DATA_TYPE_INVALID_'); return false; } } $options = $this->_parseOptions($options); //分析表达式 $data = $this->_facade($data); //数据处理 if (false === $this->_beforeInsert($data, $options)) { return false; } $result = $this->_db->insert($data, $options, $replace); //写入数据到数据库 if (false !== $result && ($insert_id = $this->getLastInsertID())) { //自增主键返回插入ID $data[$this->getPk()] = $insert_id; $this->_afterInsert($data, $options); return $insert_id; } return $result; }
public function insert($table, array $cols) { if (empty($this->_database)) { return false; } return $this->_database->insert($table, $cols); }
/** * Write * * Writes (create / update) session data * * @param string $session_id Session ID * @param string $session_data Serialized session data * @return bool */ public function write($session_id, $session_data) { // Was the ID regenerated? if ($session_id !== $this->_session_id) { if (!$this->_release_lock() or !$this->_get_lock($session_id)) { return FALSE; } $this->_row_exists = FALSE; $this->_session_id = $session_id; } elseif ($this->_lock === FALSE) { return FALSE; } if ($this->_row_exists === FALSE) { $insert_data = array('id' => $session_id, 'ip_address' => $_SERVER['REMOTE_ADDR'], 'timestamp' => time(), 'data' => $this->_platform === 'postgre' ? base64_encode($session_data) : $session_data); if ($this->_db->insert($this->_config['save_path'], $insert_data)) { $this->_fingerprint = md5($session_data); return $this->_row_exists = TRUE; } return FALSE; } $this->_db->where('id', $session_id); if ($this->_config['match_ip']) { $this->_db->where('ip_address', $_SERVER['REMOTE_ADDR']); } $update_data = array('timestamp' => time()); if ($this->_fingerprint !== md5($session_data)) { $update_data['data'] = $this->_platform === 'postgre' ? base64_encode($session_data) : $session_data; } if ($this->_db->update($this->_config['save_path'], $update_data)) { $this->_fingerprint = md5($session_data); return TRUE; } return FALSE; }
/** * Save type * @param array $data * @return boolean */ public function save_type($id, $data) { if (!$id) { if (!isset($data["gid"]) || !$data["gid"]) { return false; } $data["gid"] = preg_replace("/[^a-z_]/", "", strtolower($data["gid"])); $type = $this->get_type_by_id($data["gid"]); if ($type) { return $type["id"]; } $this->DB->insert(SPAM_TYPES_TABLE, $data); $id = $this->DB->insert_id(); } else { $fields = array_flip($this->fields); foreach ($data as $key => $value) { if (!isset($fields[$key])) { unset($data[$key]); } } if (empty($data)) { return false; } $this->DB->where("id", $id); $this->DB->update(SPAM_TYPES_TABLE, $data); } return $id; }
/** * Inserts data to the database * * @param string $table * @param array $data * @return int */ function save($table, $data) { //remove csrf unset($data['csrf']); $this->db->insert($table, $data); return $this->db->lastInsertId(); }
public function insert($data) { $sql = self::$db->insert($this->_tableName, array_merge($data, $this->_autoData)); // echo $sql;die; $this->_reset_write(); return self::$db->query($sql)->insert_id(); }
/** * Table insert method * * @param object A KDatabaseRow object * @return bool|integer Returns the number of rows inserted, or FALSE if insert query was not executed. */ public function insert(KDatabaseRowInterface $row) { //Create commandchain context $context = $this->getCommandContext(); $context->operation = KDatabase::OPERATION_INSERT; $context->data = $row; $context->table = $this->getBase(); $context->query = null; if ($this->getCommandChain()->run('before.insert', $context) !== false) { //Filter the data and remove unwanted columns $data = $this->filter($context->data->getData(), true); //Get the data and apply the column mappings $data = $this->mapColumns($data); //Execute the insert query $context->insert_id = $this->_database->insert($context->table, $data); if ($context->insert_id !== false) { $data[$this->getIdentityColumn()] = $context->insert_id; //Reverse apply the column mappings and set the data in the row $context->data->setData($this->mapColumns($data, true), false); //Set the row status $context->data->setStatus(KDatabase::STATUS_INSERTED); } else { $context->data->setStatus(KDatabase::STATUS_FAILED); } $this->getCommandChain()->run('after.insert', $context); } return $context->insert_id; }
public function insertAction() { //检查权限 $this->manager->checkMenuPermission($this->sign, Widget_Manager::MENU_PURVIEW_INSERT); $bind = $this->request->from('CageCode', 'Comment', 'Depot', 'Current', 'Size', 'X'); //echo "<pre>"; //print_r($bind); $bind['DepotId'] = $bind['Depot']; unset($bind['Depot']); $bind['CageCode'] = trim($bind['CageCode']); $bind['Comment'] = trim($bind['Comment']); $bind['Current'] = sprintf("%.2f", $bind['Current']); $bind['ActualCurrent'] = 0; $bind['Size'] = intval($bind['Size']); $bind['X'] = trim($bind['X']); $bind['Y'] = 0; $bind['Udate'] = time(); if ($bind['CageCode'] == '') { $response = array('errno' => 2); } elseif ($this->oCage->getRowByCageCode($bind['CageCode'])) { $response = array('errno' => 6); } elseif (!$bind['DepotId']) { $response = array('errno' => 3); } elseif (!$bind['Current']) { $response = array('errno' => 4); } elseif (!$bind['Size']) { $response = array('errno' => 5); } else { $res = $this->oCage->insert($bind); $response = $res ? array('errno' => 0) : array('errno' => 9); } echo json_encode($response); return true; }
/** * Insert node * * @param integer $level * @param integer $nearKey * @param array $data * @param array $filter * @param boolean $useTransaction * @return integer|string */ protected function insertNode($level, $nearKey, array $data, array $filter = [], $useTransaction = true) { $insertId = 0; try { if ($useTransaction) { $this->tableGateway->getAdapter()->getDriver()->getConnection()->beginTransaction(); } $this->tableGateway->update([$this->left => new Expression('IF (' . $this->left . ' > ?, ' . $this->left . ' + 2, ' . $this->left . ')', [$nearKey]), $this->right => new Expression('IF (' . $this->right . ' > ?, ' . $this->right . ' + 2, ' . $this->right . ')', [$nearKey])], [(new Predicate())->greaterThanOrEqualTo($this->right, $nearKey)] + $filter); $leftKey = $nearKey + 1; $rightKey = $nearKey + 2; $level = $level + 1; // insert a new node $this->tableGateway->insert([$this->left => $leftKey, $this->right => $rightKey, $this->level => $level] + $data); $insertId = $this->tableGateway->getLastInsertValue(); // update parent info if (false !== ($parent = $this->getParentNode($leftKey, $rightKey, $level, $filter))) { $this->tableGateway->update([$this->parent => $parent[$this->nodeId]], [$this->nodeId => $insertId]); } if ($useTransaction) { $this->tableGateway->getAdapter()->getDriver()->getConnection()->commit(); } } catch (Exception $e) { if ($useTransaction) { $this->tableGateway->getAdapter()->getDriver()->getConnection()->rollback(); } ApplicationErrorLogger::log($e); return $e->getMessage(); } return $insertId; }
/** * Add setting * * @param string * @param array $settingValues * @param integer $moduleId * @return void */ protected function addSetting($setting, array $settingValues = [], $moduleId = 1) { $settingData = ['name' => $setting, 'module' => $moduleId]; $query = $this->settingModel->insert()->into('application_setting')->values($settingData); $statement = $this->settingModel->prepareStatementForSqlObject($query); $statement->execute(); $settingId = $this->settingModel->getAdapter()->getDriver()->getLastGeneratedValue(); // add setting values if ($settingValues) { foreach ($settingValues as $settingValue) { // insert setting value $query = $this->settingModel->insert()->into('application_setting_value')->values(array_merge($settingValue, ['setting_id' => $settingId])); $statement = $this->settingModel->prepareStatementForSqlObject($query); $statement->execute(); } } }
/** * Event: new_faq * Triggered after FAQ addition * @param xhelpTicket $ticket Ticket used as base for FAQ * @param xhelpFaq $faq FAQ that was added */ function new_faq($ticket, $faq) { global $xoopsUser; $logMessage =& $this->_hLog->create(); $logMessage->setVar('uid', $xoopsUser->getVar('uid')); $logMessage->setVar('ticketid', $ticket->getVar('id')); $logMessage->setVar('action', sprintf(_XHELP_LOG_NEWFAQ, $faq->getVar('subject'))); return $this->_hLog->insert($logMessage, true); }