/** * Adapter constructor * * @param array $config */ public function __construct($config) { $phql = $config['phql']; $bind = $config['bind']; $page = $config['page']; $limit = $config['limit']; $phql .= " LIMIT {$limit} OFFSET " . ($page - 1) * $limit; $query = new \Phalcon\Mvc\Model\Query($phql); $query->setDI($config['di']); $this->data = $query->execute($bind); }
function creatOrder(&$order_id, $raise_id, $wheel_id, $user_id, $params) { $flag = false; try { $this->di['db']->begin(); $nowtime = time(); $order = new DtbProjectInvestOrder(); $order->invest_money = $params['invest_money']; $order->equit_offered = $params['equit_offered']; $order->service_fee = $params['service_fee']; $order->raise_id = $raise_id; $order->user_id = $user_id; $order->bond = $params['bond']; $order->invite_code = $params['invite_code']; $order->real_pay_fee = $params['real_pay_fee']; //? $order->create_ts = $nowtime; $order->update_ts = $nowtime; $order->wheel_id = $wheel_id; $order->result = 0; if (!$order->create()) { foreach ($order->getMessages() as $message) { echo $message; } $this->di['db']->rollback(); return $flag; } else { $action_type = $this->di['config']->log_user->createorder; $log_ts = time(); $sql = "insert into DtbLogUser (user_id,action_type,log_ts) values('{$user_id}','{$action_type}','{$log_ts}' )"; $query = new Phalcon\Mvc\Model\Query($sql, $this->getDI()); $res1 = $query->execute(); if (!$res1) { $this->di['db']->rollback(); } else { $flag = true; $this->di['db']->commit(); $order_id = $order->getOrderId(); } return $flag; } } catch (Exception $ex) { $this->di['db']->rollback(); return $flag; } }
public function applyPerson($user_id, $params) { $flag = false; try { $this->di['db']->begin(); $invest_person = new DtbInvestorPerson(); $invest_person->user_id = $user_id; $invest_person->address = $params['address']; $invest_person->real_name = $params['real_name']; $invest_person->identity_card = isset($params['identity_card']) ? $params['identity_card'] : null; $invest_person->idc_img1 = isset($params['idc_img1']) ? $params['idc_img1'] : null; $invest_person->idc_img2 = isset($params['idc_img2']) ? $params['idc_img2'] : null; $invest_person->province = $params['province']; $invest_person->city = $params['city']; $invest_person->dist = $params['dist']; $invest_person->income_y = isset($params['income_y']) ? $params['income_y'] : 0; $invest_person->company = $params['company']; $invest_person->position = $params['position']; $invest_person->person_fund = isset($params['person_fund']) ? $params['person_fund'] : 0; $invest_person->available_extra_price = isset($params['available_extra_price']) ? $params['available_extra_price'] : 0; $invest_person->singel_invest_range = isset($params['singel_invest_range']) ? $params['singel_invest_range'] : 0; $invest_person->invest_exp = $params['invest_exp']; $invest_person->attention_direct = $params['attention_direct']; $invest_person->invest_idea = $params['invest_idea']; $invest_person->available_extra_price = $params['available_extra_price']; $invest_person->create_ts = time(); $invest_person->update_ts = time(); $invest_person->country = $params['country']; $invest_person->result = 0; if (!$invest_person->create()) { foreach ($invest_person->getMessages() as $message) { echo $message; } $this->di['db']->rollback(); return $flag; } else { $action_type = $this->di['config']->log_user->applyperson; $log_ts = time(); $sql = "insert into DtbLogUser (user_id,action_type,log_ts) values('{$user_id}','{$action_type}','{$log_ts}' )"; $query = new Phalcon\Mvc\Model\Query($sql, $this->getDI()); $res1 = $query->execute(); $sql = "update DtbUserBasic set account_type=2 where user_id={$user_id} and account_type=0"; $query = new Phalcon\Mvc\Model\Query($sql, $this->getDI()); $res2 = $query->execute(); if (!$res1) { $this->di['db']->rollback(); } else { if (!$res2) { $this->di['db']->rollback(); } else { $flag = true; $this->di['db']->commit(); } } return $flag; } } catch (Exception $ex) { $this->di['db']->rollback(); return $flag; } }
<?php // Instantiate the Query $query = new Phalcon\Mvc\Model\Query("SELECT * FROM Cars"); // Pass the DI container $query->setDI($di); // Execute the query returning a result if any $cars = $query->execute();
<?php // Instantiate the Query $query = new Phalcon\Mvc\Model\Query("SELECT * FROM Cars", $di); // Execute the query returning a result if any $cars = $query->execute();
public function getSuccessProject($limit) { $sql = "select DtbRaiseProjectBasic.company,DtbRaiseProjectBasic.company_logo,DtbRaiseProjectBasic.project_name,DtbRaiseProjectWheel.already_money,DtbRaiseProjectWheel.wheel_invested_num from DtbRaiseProjectBasic,DtbRaiseProjectWheel where DtbRaiseProjectWheel.status=1 and DtbRaiseProjectBasic.now_wheel_id=DtbRaiseProjectWheel.wheel_id order by DtbRaiseProjectWheel.end_ts,DtbRaiseProjectWheel.already_money desc limit {$limit}"; //var_dump($this->getDI()); $query = new Phalcon\Mvc\Model\Query($sql, $this->getDI()); return $res = $query->execute(); }