Returns an object to represent a database expression in a query. Expression objects
are not sanitized or escaped.
public expression ( string $expression ) : stdClass | ||
$expression | string | An arbitrary SQL expression to be inserted into a query. |
return | stdClass | An object representing a database expression to be used in a query |
public function add() { //var_dump($this->request->data); $this->loadModel('User'); $us = $this->User->find('all'); //var_dump($us['0']); if (!empty($this->data)) { $this->loadModel('User'); $this->User->create(); //$this->request->data['User']['ip'] = $this->request->clientIp(); $m = $this->request->data['User']['dob']['month']; $d = $this->request->data['User']['dob']['day']; $y = $this->request->data['User']['dob']['year']; $dob = $m . '-' . $d . '-' . $y; //$mem = $this->request->data['User']['member']; //var_dump($mem); $this->request->data['User']['dob'] = $dob; //$this->request->data['User']['mem'] = 'User'; //$this->request->data['login_attempt']['login_times'] = 1; $this->request->data['User']['register_date'] = DboSource::expression('NOW()'); if ($this->User->save($this->request->data)) { //echo "<div id='footer_a_link'>"; $this->Session->setFlash('You are registered successfully. Please log in.'); // $this->redirect(array('action' => 'login', 'controller' => 'Users')); } else { $this->Session->setFlash('Not Registered'); } } }
public function create_concert() { $this->loadModel('Taste'); $load_taste = $this->Taste->find('all'); $this->set(compact('load_taste', 'load_taste')); //var_dump($this->request->data); $this->loadModel('Band'); $load_band = $this->Band->find('all'); $this->set(compact('load_band', 'load_band')); $this->loadModel('Concert'); //var_dump($this->request->data); if (!empty($this->data)) { $this->Concert->create(); //$this->request->data['User']['ip'] = $this->request->clientIp(); $this->request->data['Concert']['concert_name'] = $this->request->data['Concerts']['concert_name']; $this->request->data['Concert']['concert_place'] = $this->request->data['Concerts']['concert_place']; $this->request->data['Concert']['concert_time'] = $this->request->data['Concerts']['concert_time']; $this->request->data['Concert']['concert_ticket_price'] = $this->request->data['Concerts']['concert_ticket_price']; $this->request->data['Concert']['concert_band'] = $this->request->data['concert_band'] + 1; $this->request->data['Concert']['concert_taste'] = $this->request->data['concert_taste'] + 1; //$this->request->data['Concert']['band_name'] = $this->request->data['Bands']['band_name']; //$this->request->data['login_attempt']['login_times'] = 1; $this->request->data['Concert']['concert_creation_date'] = DboSource::expression('NOW()'); if ($this->Concert->save($this->request->data)) { //echo "<div id='footer_a_link'>"; $this->Session->setFlash('Concert has been registered successfully.'); //$this->redirect(array('action' => 'index', 'controller' => 'Bands')); } else { $this->Session->setFlash('Not Registered'); } } }
public function process() { $c = new CakeEmail('default'); //grab 50 emails $emails = $this->EmailMessage->find("all", array("conditions" => array("EmailMessage.processed" => 0, "EmailMessage.to !=" => '', "NOT" => array("EmailMessage.to" => null)), "contain" => array())); $total_emails = count($emails); $this->out("emails to processes: " . $total_emails); SysMsg::add(array("category" => "Emailer", "from" => "MailerShell", "crontab" => 1, "title" => "Emails to processes: " . $total_emails)); foreach ($emails as $email) { $e = $email['EmailMessage']; $c->reset(); $c->config('default'); $c->to($e['to']); $c->subject($e['subject']); $c->template($e['template']); $c->viewVars(array("msg" => $email)); if ($c->send()) { $this->EmailMessage->create(); $this->EmailMessage->id = $e['id']; $this->EmailMessage->save(array("processed" => 1, "sent_date" => DboSource::expression('NOW()'))); $total_emails--; $this->out("Email:" . $e['to'] . " Template: " . $e['template']); } else { $this->out("Email failed: " . $e['id']); SysMsg::add(array("category" => "Emailer", "from" => "MailerShell", "crontab" => 1, "title" => "Email Failed: " . $e['id'])); } } }
public function delete($id = null) { if (!$id) { $this->Session - setFlash('Tarea inválida'); $this->redirect(array('action' => 'index', 'pendiente'), null, true); } $this->Tarea->id = $id; $this->request->data['Tarea']['estado'] = 1; $this->request->data['Tarea']['finalizado'] = DboSource::expression('NOW()'); if ($this->Tarea->save($this->request->data)) { $this->Session->setFlash('Tarea #' . $id . ' Terminada'); $this->redirect(array('action' => 'index', 'pendiente'), null, true); } }
public function beforeSave($options = array()) { $key = $this->alias; $update_time = @DboSource::expression('NOW()'); //update columns if (empty($this->id)) { if (empty($this->data[$key]['created'])) { $this->data[$key]['created'] = $update_time; } } if (empty($this->data[$key]['modified'])) { $this->data[$key]['modified'] = $update_time; } return true; }
function admin_add() { if (!empty($this->request->data) && $this->request->is('post')) { $this->User->create(); $this->request->data['User']['user_added_date'] = @DboSource::expression('NOW()'); $this->request->data['User']['password'] = md5($this->request->data['User']['password']); if ($this->User->save($this->request->data)) { $this->Session->setFlash(__('The user added successfully', true), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index')); } else { $this->Session->setFlash(__('The user could not be saved. Please, try again.', true), 'default', array('class' => 'error')); } } $roles = $this->UserRole->find('all', array('conditions' => array('status' => 'Active'), 'order' => array('role_name' => 'asc'))); $this->set('Roles', $roles); }
public function admin_edit($id = null) { $this->Cmse->id = $id; if (!$this->Cmse->exists()) { throw new NotFoundException(__('Invalid Page')); } if ($this->request->is('post') || $this->request->is('put')) { $this->request->data['Cmse']['page_modified_date'] = DboSource::expression('now()'); if ($this->Cmse->save($this->request->data)) { $this->Session->setFlash(__('The page has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index')); } else { $this->Session->setFlash(__('The page could not be saved. Please, try again.'), 'default', array('class' => 'error')); } } else { $this->request->data = $this->Cmse->read(null, $id); } }
public function assignUserACoupon($forUser, $couponType = 1, $parameters = []) { $fields = ['presenter_id' => null, 'start_date' => date('Y-m-d H:i:s'), 'end_date' => '0000-00-00 00:00:00', 'max_redemptions' => '-1', 'discount_percentage' => 50, 'discount_flat' => '0.00', 'discount_sku' => null, 'reference_id' => null, 'user_visible' => true, 'expiration_date' => DboSource::expression('DATE_ADD(NOW(),INTERVAL 1 YEAR)')]; $data = array_merge($fields, $parameters); $coupon = $this->CouponPresenter->getPresenterCoupon($data['presenter_id'], $couponType); if (empty($coupon)) { $success = $this->CouponPresenter->saveCreate(array("presenter_id" => $data['presenter_id'], "coupon_id" => $couponType, "start_date" => $data['start_date'], "end_date" => $data['end_date'], "max_redemptions" => $data['max_redemptions'], "discount_percentage" => $data['discount_percentage'], "discount_flat" => $data['discount_flat'], "discount_sku" => $data['discount_sku'], "expiration_date" => $data['expiration_date'])); if ($success) { $coupon = $this->CouponPresenter->getPresenterCoupon($data['presenter_id'], $couponType); } } //Coupon should be assigned now if (!empty($coupon)) { $this->create(); $return = $this->save(array("coupon_presenter_id" => $coupon['CouponPresenter']['id'], "user_id" => $forUser, "reference_id" => $data['reference_id'], "user_visible" => $data['user_visible'], "date_added" => date('Y-m-d H:i:s'), "redemption_reference_id" => '', "redemption_amount" => '0.00', "expiration_date" => $data['expiration_date'])); } else { $return = NULL; } return $return; }
function admin_verify_login() { if (!empty($this->data)) { $rs = $this->Login->verifyLogin($this->data); if ($rs) { $this->Session->write('User', $rs); $this->Session->write('LoginStatus', 1); /*-save last login details-*/ $arrData = array('User' => array('last_login_ip' => $this->request->clientIp(), 'last_login_date' => @DboSource::expression('NOW()'))); $this->User->validation = null; $this->User->id = $rs['Login']['id']; $this->User->save($arrData, false); //print_r($rs['Login']['id']);die; /*-[end]save last login details-*/ $this->redirect('/admin/users/index'); } else { $this->Session->setFlash("Invalid Email or Password"); $this->redirect(array('action' => 'index')); } } }
/** * testCalculations method * * @return void */ public function testCalculations() { $this->Model = new TestModel(); $result = $this->Dbo->calculate($this->Model, 'count'); $this->assertEquals('COUNT(*) AS `count`', $result); $result = $this->Dbo->calculate($this->Model, 'count', array('id')); $this->assertEquals('COUNT(`id`) AS `count`', $result); $result = $this->Dbo->calculate($this->Model, 'count', array($this->Dbo->expression('DISTINCT id'))); $this->assertEquals('COUNT(DISTINCT id) AS `count`', $result); $result = $this->Dbo->calculate($this->Model, 'count', array('id', 'id_count')); $this->assertEquals('COUNT(`id`) AS `id_count`', $result); $result = $this->Dbo->calculate($this->Model, 'count', array('Model.id', 'id_count')); $this->assertEquals('COUNT(`Model`.`id`) AS `id_count`', $result); $result = $this->Dbo->calculate($this->Model, 'max', array('id')); $this->assertEquals('MAX(`id`) AS `id`', $result); $result = $this->Dbo->calculate($this->Model, 'max', array('Model.id', 'id')); $this->assertEquals('MAX(`Model`.`id`) AS `id`', $result); $result = $this->Dbo->calculate($this->Model, 'max', array('`Model`.`id`', 'id')); $this->assertEquals('MAX(`Model`.`id`) AS `id`', $result); $result = $this->Dbo->calculate($this->Model, 'min', array('`Model`.`id`', 'id')); $this->assertEquals('MIN(`Model`.`id`) AS `id`', $result); $result = $this->Dbo->calculate($this->Model, 'min', 'left'); $this->assertEquals('MIN(`left`) AS `left`', $result); }
/** * Data flow 5 - N2Y * @see DataFlowFiveTask */ public function dataFlow5_archived() { $this->Orders = ClassRegistry::init('Orders'); $this->OrderShipmentPackage = ClassRegistry::init('OrderShipmentPackage'); $folder = "dataflow5"; $files = $this->NetSuite->download(AWS_NETSUITE_RECEIVING_BUCKET, $folder); $email = '*****@*****.**'; $this->out('Files found: ' . count($files), 1, Shell::VERBOSE); foreach ($files as $file) { $packages = $file['data']; $this->out('File: ' . $packages['file'], 1, Shell::VERBOSE); foreach ($packages as $package_data) { if (strlen($package_data->order_id) >= 13 && substr($package_data->order_id, 0, 13) == "Sales Order #") { $order_id = substr($package_data->order_id, 13); } elseif (substr($package_data->order_id, 0, 2) == "SO") { $order_id = substr($package_data->order_id, 2); } else { $order_id = $package_data->order_id; } $this->out('Order updating: ' . $order_id, 1, Shell::VERBOSE); $OrderShipmentId = $package_data->shipment_id; $DateShipped = date("Y-m-d H:i:s", strtotime($package_data->ship_date)); $TrackingNumber = $package_data->tracking_numbers; $Carrier = $package_data->shipping_carrier; $ShipMethod = $package_data->shipping_method; $updating = array('order_shipment_id' => $OrderShipmentId, 'date_shipped' => $DateShipped, 'shipping_method' => $ShipMethod, 'tracking_number' => $TrackingNumber, 'carrier' => $ShipMethod); $shipment_record = $this->OrderShipmentPackage->getPackageDetailsByShipmentId($OrderShipmentId); if (count($shipment_record) && ($shipment_record[0]['OrderShipmentPackage']['tracking_number'] == null || $shipment_record[0]['OrderShipmentPackage']['tracking_number'] == '')) { $OrderShipmentPackageId = $shipment_record[0]['OrderShipmentPackage']['id']; $this->OrderShipmentPackage->updatePackageDetails($OrderShipmentPackageId, $updating); } elseif (!count($shipment_record)) { $updating['date_created'] = date("Y-m-d H:i:s"); $this->OrderShipmentPackage->savePackageDetails($updating); $shipment_record = $this->OrderShipmentPackage->getPackageDetailsByShipmentId($OrderShipmentId); $email_result = $this->NetSuite->sendCustomerTrackingEmail($shipment_record); if ($email_result == 1) { $this->out("Tracking email sent: " . $shipment_record[0]['OrderShipmentPackage']['tracking_number']); } else { $this->out("ERROR: Tracking email failed or was already sent."); } } else { $this->out("Shipment: " . $OrderShipmentId . ", was not saved - maybe it already existed"); } $this->Order->updateOrderStatus($order_id, Order::STATUS_SHIPPED); $this->Order->updateSecondaryStatus($order_id, DboSource::expression('NULL')); $this->out('Order updated: ' . $order_id, 1, Shell::VERBOSE); $this->hr(); } $new_file_location = str_replace("tmp", "processed", $file['file']); $this->client->registerStreamWrapper(); rename($file['file'], $new_file_location); } return true; }
public function open() { $this->saveField('party_status_id', 1); $this->saveField('end_time', DboSource::expression("concat_ws(' ',CURDATE() + INTERVAL 10 DAY,'23:59:59')")); return true; //return $this->finalize(); }
function review() { if (!$this->Session->check($_GET['token'])) { $this->Session->write($_GET['token'], 'InProgress'); } else { if ($this->Session->read($_GET['token']) == 'canceled') { return $this->redirect('http://' . env('SERVER_NAME') . '/recipes/index'); } } if ($this->request->is('POST') || $this->request->is('PUT')) { $submit = $this->data['submit']; if ($submit == 'cancel') { $this->Session->write($_GET['token'], 'canceled'); return $this->redirect('http://' . env('SERVER_NAME') . '/recipes/index'); } } $paypal_api_username = Configure::read('paypal_api_username'); $paypal_api_password = Configure::read('paypal_api_password'); $paypal_api_signature = Configure::read('paypal_api_signature'); $params = array('method' => 'GetExpressCheckoutDetails', 'version' => '106', 'user' => $paypal_api_username, 'pwd' => $paypal_api_password, 'signature' => $paypal_api_signature, 'token' => $_GET['token']); $shopping_items = array(); $result = $this->__paypalClassicApi($params); $paypal_item_number = 0; while ($paypal_item_number < 1000) { if (isset($result['L_NUMBER' . $paypal_item_number])) { $item_data = $result['L_NUMBER' . $paypal_item_number]; // index 0 type, 1 ID $pieces = explode('#', $item_data); $buyable = $this->Payment->checkIfBuyable($pieces[1]); if ($buyable == false) { $this->__purchase_error(); } $shopping_items[] = array('id' => $pieces[1], 'type' => 'recipe'); } else { break; } $paypal_item_number++; } if (!isset($result['CHECKOUTSTATUS']) || $result['CHECKOUTSTATUS'] == 'PaymentActionCompleted') { $this->log($result, 'error'); $this->log($this->_logged_user['id'] . ' review function error 2', 'error'); $this->__purchase_error(); } if ($this->request->is('POST') || $this->request->is('PUT')) { $shopping_items = array(); $item_names = array(); $paypal_item_number = 0; while ($paypal_item_number < 1000) { if (isset($result['L_NUMBER' . $paypal_item_number])) { $item_data = $result['L_NUMBER' . $paypal_item_number]; $amount = $result['L_PAYMENTREQUEST_0_AMT' . $paypal_item_number]; $tax = $result['L_PAYMENTREQUEST_0_TAXAMT' . $paypal_item_number]; $item_names[] = $result['L_PAYMENTREQUEST_0_NAME' . $paypal_item_number]; $pieces = explode('#', $item_data); $shopping_items[] = array('id' => $pieces[1], 'type' => $pieces[0], 'amount' => $amount, 'tax' => $tax); } else { break; } $paypal_item_number++; } $this->log('Payment Transaction start', 'debug'); $currency = $result['CURRENCYCODE']; $params = array('user' => $paypal_api_username, 'pwd' => $paypal_api_password, 'signature' => $paypal_api_signature, 'method' => 'DoExpressCheckoutPayment', 'version' => '106', 'token' => $_GET['token'], 'PAYERID' => $_GET['PayerID'], 'PAYMENTREQUEST_0_AMT' => $result['AMT'], 'PAYMENTREQUEST_0_CURRENCYCODE' => $result['CURRENCYCODE'], 'PAYMENTREQUEST_0_PAYMENTACTION' => 'Sale'); $result1 = $this->__paypalClassicApi($params); $dataSource = $this->Payment->getDataSource(); try { $dataSource->begin(); foreach ($shopping_items as $shopping_item) { $category = $shopping_item['type']; $category = ucfirst($category); $amount = $shopping_item['amount'] + $shopping_item['tax']; $this->Payment->create(); $this->Payment->set(array('item_id' => $shopping_item['id'], 'user_id' => $this->_logged_user['id'], 'trans_type' => 'purchased', 'amount' => $amount, 'currency' => $currency, 'category' => $category, 'recipe_access_level' => 2, 'display_from' => DboSource::expression('NOW()'))); if (!$this->Payment->save()) { throw new Exception(); } } $dataSource->commit(); } catch (Exception $e) { $this->log('Payment Transaction error', 'error'); $this->__purchase_error(); } $this->__email_transaction_complete($this->_logged_user['display_name'], $item_names); $shopping_cart = array('loggin_id' => $this->_logged_user['id']); $this->Cookie->write('shoppingcart', $shopping_cart, true, time() + 3600); $this->log('Payment Transaction ends', 'debug'); $this->Session->setFlash('レシピ購入を完了しました。', 'default', array('class' => 'message success')); $this->redirect(array('controller' => 'recipes', 'action' => 'complete_purchase')); } foreach ($shopping_items as $index => $item) { $this->Recipe->id = $item['id']; $recipe = $this->Recipe->read(); $img_path = '/uploads/recipe/' . $recipe['Recipe']['hash'] . '/disp/recipe' . $recipe['Recipe']['id'] . '.jpg'; $shopping_items[$index]['image'] = $img_path; $shopping_items[$index]['name'] = $recipe['Recipe']['title']; } $this->set('details', $result); $this->set('title', "確認ページ"); $this->set('data', $shopping_items); }
private function createUser($username, $display, $token) { App::uses('String', 'Utility'); $this->User->deleteAll(array('TwitchUsername' => $username)); $newUser = array('APIKey' => strtoupper(String::uuid()), 'TwitchUsername' => $username, 'TwitchDisplay' => $display, 'TwitchToken' => $token, 'CreateDate' => DboSource::expression('NOW()')); $this->User->save($newUser); return array($newUser); }
public function changePresenterStatus($presenter_id, $new_status, $admin_user) { $presenter = $this->read('', $presenter_id); $this->saveField("presenter_status_id", $new_status); if (in_array($new_status, array(PresenterStatus::SUSPENDED, PresenterStatus::CANCELLED, PresenterStatus::TERMINATED, PresenterStatus::VOLUNTARY_SUSPENSION))) { $this->saveField("terminated_date", DboSource::expression('NOW()')); } else { $this->saveField("terminated_date", NULL); $this->query("\n\t\t\t\tINSERT INTO termination_history (terminated_date, reactivated_date, presenter_id) \n\t\t\t\tVALUES('{$presenter['Presenter']['terminated_date']}', NOW(), {$presenter_id});\n\t\t\t"); } // log change // $admin_user is integer when called from CronPresenterMonthlyShell.php $admin_user_id = gettype($admin_user) === 'object' ? $admin_user->id : $admin_user; App::uses('AdminUserAudit', 'Model'); $this->AdminUserAudit = new AdminUserAudit(); $this->AdminUserAudit->create(); $this->AdminUserAudit->saveField('admin_user_id', $admin_user_id); $this->AdminUserAudit->saveField('reference_name', 'presenters.presenter_status_id'); $this->AdminUserAudit->saveField('reference_id', $presenter_id); $this->AdminUserAudit->saveField('old_value', $presenter['Presenter']['presenter_status_id']); $this->AdminUserAudit->saveField('new_value', $new_status); $this->AdminUserAudit->saveField('notes', "Admin3 sponsor status change"); }
function updateLastLogin($userId = null) { $this->User->create(); $this->User->id = $userId; return $this->User->saveField('last_login', DboSource::expression('NOW()')); }
private function addJoin(&$Model, &$query, $currentJoin, $modelAlias = '') { if (empty($modelAlias)) { $modelAlias = $Model->name; } foreach ($currentJoin[$this->_key] as $key => $join) { if (is_numeric($key)) { $alias = $join; } elseif (is_array($join) && isset($join['model'])) { $alias = $join['model']; } else { $alias = $key; } $data = array(); $data['table'] = $Model->{$alias}->table; // table to join $data['alias'] = is_numeric($key) ? $join : $key; // name of relationship $data['type'] = is_array($join) && isset($join['type']) ? $join['type'] : $this->defaultType; // type of (default INNER) if (!$this->fieldsInformed) { // default fields if none passed if (is_array($join) && isset($join['fields'])) { $query['fields'] = array_merge($query['fields'], $join['fields']); } else { foreach (array_keys($Model->{$alias}->_schema) as $field) { $query['fields'][] = '`' . $alias . '`.`' . $field . '`'; } } } if (is_array($join) && isset($join['conditions'])) { $data['conditions'] = $join['conditions']; } else { // checking for relatinships // belongsTo if (isset($Model->belongsTo[$alias]['foreignKey'])) { $self = "`{$modelAlias}`.`" . $Model->belongsTo[$alias]['foreignKey'] . "`"; $foreign = DboSource::expression($data['alias'] . '.' . $Model->{$alias}->primaryKey); $data['conditions'] = array($self => $foreign); } // hasMany and hasOne if (isset($Model->hasMany[$alias]['foreignKey']) || isset($Model->hasOne[$alias]['foreignKey'])) { $self = "`{$modelAlias}`.`" . $Model->primaryKey . "`"; $foreign = DboSource::expression($data['alias'] . '.' . (isset($Model->hasMany[$alias]['foreignKey']) ? $Model->hasMany[$alias]['foreignKey'] : $Model->hasOne[$alias]['foreignKey'])); $data['conditions'] = array($self => $foreign); } // hasAndBelongsToMany if (isset($Model->hasAndBelongsToMany[$alias]['foreignKey']) || isset($Model->hasOne[$alias]['foreignKey'])) { $dataCopy = $data; $dataCopy['table'] = $Model->hasAndBelongsToMany[$alias]['joinTable']; $dataCopy['alias'] = $data['alias'] . 'Join'; $self1 = "`{$modelAlias}`.`" . $Model->primaryKey . "`"; $foreign1 = DboSource::expression($dataCopy['alias'] . '.' . $Model->hasAndBelongsToMany[$alias]['foreignKey']); $dataCopy['conditions'] = array($self1 => $foreign1); $query['joins'][] = $dataCopy; $self2 = '`' . $data['alias'] . 'Join`.`' . $Model->hasAndBelongsToMany[$alias]['associationForeignKey'] . '`'; $foreign2 = DboSource::expression($data['alias'] . '.' . $Model->{$alias}->primaryKey); $data['conditions'] = array($self2 => $foreign2); } } $query['joins'][] = $data; if (is_array($join) && isset($join[$this->_key])) { if (!is_array($join[$this->_key])) { $join[$this->_key] = array($join[$this->_key]); } $this->addJoin($Model->{$alias}, $query, $join, $alias); } $usedAliases[] = $alias; // logging used aliases } return $query; }
public function bandcpanel($id, $band_id) { $login_id = $this->Auth->user()['id']; var_dump($this->request->data); $this->loadModel('Bandstatus'); if ($this->request->is('post')) { $this->Bandstatus->create(); $this->request->data['Bandstatus']['login_id'] = $login_id; $this->request->data['Bandstatus']['band_id'] = $band_id; $this->request->data['Bandstatus']['date'] = DboSource::expression('NOW()'); if ($this->Bandstatus->save($this->request->data)) { $this->Session->setFlash('Status has been successfully posted.'); $this->redirect(array('controller' => 'Homes', 'action' => 'bandcpanel')); } } $this->loadModel('Fan'); $check_follow = $this->Fan->find('all', array('conditions' => array('login_id' => $login_id, 'fan_of' => $band_id))); if ($check_follow != null) { $this->set(compact('check_follow', 'check_follow')); //var_dump($check_follow); } $this->loadModel('Band'); $band = $this->Band->find('all', array('conditions' => array('login_id' => $login_id))); $this->set(compact('band', 'band')); $this->loadModel('BandStatus'); $bandst = $this->BandStatus->find('all', array('conditions' => array('login_id' => $login_id))); $this->set(compact('bandst', 'bandst')); }
/** Populates ItemPrices.price_supplement for uk_vat */ public function uk_vat() { App::import('model', 'ItemPrice'); $this->ItemPrice = new ItemPrice(); $sql = "SELECT * FROM item_prices WHERE item_price_type_id = 6 AND start_date <= NOW() AND (end_date IS NULL OR end_date > NOW())"; $results = $this->ItemPrice->query($sql); foreach ($results as $result) { //end item price $this->ItemPrice->id = $result['item_prices']['id']; $this->ItemPrice->saveField('end_date', DboSource::expression('NOW()')); $original_price = $result['item_prices']['price']; $price_supplement = round($original_price / 6, 2); $new_price = $original_price - $price_supplement; unset($result['item_prices']['id']); $result['item_prices']['price'] = $new_price; $result['item_prices']['price_supplement'] = $price_supplement; $result['item_prices']['start_date'] = DboSource::expression('NOW()'); //add new record $new_item = new ItemPrice(); $new_item->create(); $new_item->save($result['item_prices']); } }
public function presenterBrag($braggerId, $userId, $message, $facebookid) { $this->saveCreate(array("type" => "brag", "bragger" => $braggerId, "user_id" => $userId, "message" => $message, "datetime" => DboSource::expression('NOW()'), "facebook_id" => $facebookid)); }