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));
}
