public function save()
{
# Set validation rules
$rules = ['firstname' => 'required', 'lastname' => 'required', 'email' => 'required', 'phone' => 'required', 'location' => 'required', 'service_category' => 'required', 'service_detail' => 'required'];
$validator = Validator::make(Input::all(), $rules);
# Handle invalid data
if ($validator->fails()) {
return View::make('error')->with('message', 'Looks like there\'s some missing data');
}
$quote = new Quote();
$quote->firstname = Input::get('firstname');
$quote->lastname = Input::get('lastname');
$quote->email = Input::get('email');
$quote->phone = Input::get('phone');
$quote->location = Input::get('location');
$quote->service_category = Input::get('service_category');
$quote->service_detail = Input::get('service_detail');
$quote->save();
$email = Input::get('email');
# Shoot email to marketing team
Mail::send('emails.marketing', Input::all(), function ($message) use($email) {
$message->to('*****@*****.**')->subject($email . ' is requesting a quote');
});
return View::make('thank_you')->with(['person' => 'experienced personnel']);
}
public function run()
{
$form = new AddQuoteForm();
if (!empty($_POST['AddQuoteForm']) && is_array($_POST['AddQuoteForm'])) {
$form->attributes = $_POST['AddQuoteForm'];
if ($form->validate()) {
$quote = new Quote();
$quote->textEn = $form->textEn;
$quote->textRu = $form->textRu;
$quote->authorId = 0;
$quote->notes = $form->author . ' : ' . $form->notes;
if ($quote->save()) {
/*
* Send emaiil with notification to admin.
*/
$email = Yii::app()->email;
$email->type = 'text/plain';
$email->to = Yii::app()->params['adminEmail'];
$email->subject = 'New quote request.';
$email->message = $this->controller->renderPartial('_emailAdd', array('quote' => $quote), true);
$email->send();
$this->controller->redirect(array('addThanks'));
}
}
}
$this->controller->render('add', array('form' => $form));
}
public function add()
{
$quote = new Quote();
$quote->user_id = $this->session->userdata('id');
$quote->text = $this->input->post('body');
$quote->author = $this->input->post('author');
$quote->save();
header('Location: /quotes');
}
public function run($context)
{
$preferences = $context->preferences;
$quote_count = 0;
$stocks = $context->stocks;
foreach ($stocks as $stock) {
if (!$stock->attivo) {
continue;
}
if ($stock->mercato != 'eurotlx' && $stock->mercato != 'tlx') {
continue;
}
$quote = new Quote();
$quote->isin = $stock->isin;
$quote->quotazione = isin2value_tlx($quote->isin, $preferences->isin_lookup_eurotlx);
$quote->data = date('Y-m-d');
$quote->ora = date('H:i:s');
if (is_numeric($quote->quotazione)) {
$quote->save();
$quote_count++;
}
}
printf("%s fetched %d quotes\n", get_called_class(), $quote_count);
}
/**
* Creates a new model.
*
* If creation is successful, the browser will be redirected to the 'view' page.
*
* @param bool $quick If true, this indicates the action is being requested via AJAX
*/
public function actionCreate($quick = false, $duplicate = false)
{
$model = new Quote();
if ($duplicate && !isset($_POST['Quote'])) {
$copiedModel = Quote::model()->findByPk($duplicate);
if (!empty($copiedModel)) {
foreach ($copiedModel->attributes as $name => $value) {
if ($name != 'id') {
$model->{$name} = $value;
}
}
$model->setLineItems($this->duplicateLineItems($copiedModel), false, true);
}
}
$users = User::getNames();
if ($quick && !Yii::app()->request->isAjaxRequest) {
throw new CHttpException(400);
}
$currency = Yii::app()->params->currency;
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Quote'])) {
$model->setX2Fields($_POST['Quote']);
$model->currency = $currency;
$model->createDate = time();
$model->lastUpdated = $model->createDate;
$model->createdBy = Yii::app()->user->name;
$model->updatedBy = $model->createdBy;
if (empty($model->name)) {
$model->name = '';
}
if (isset($_POST['lineitem'])) {
$model->lineItems = $_POST['lineitem'];
}
if (!$model->hasLineItemErrors) {
if ($model->save()) {
$model->createEventRecord();
$model->createActionRecord();
$model->saveLineItems();
if (!$quick) {
$this->redirect(array('view', 'id' => $model->id));
} else {
if (isset($_GET['recordId']) && isset($_GET['recordType'])) {
$recordId = $_GET['recordId'];
$recordType = $_GET['recordType'];
$relatedModel = X2Model::model($_GET['recordType'])->findByPk($recordId);
// tie record to quote
if ($relatedModel) {
$relate = new Relationships();
$relate->firstId = $model->id;
$relate->firstType = "Quote";
$relate->secondId = $relatedModel->id;
$relate->secondType = $recordType;
$relate->save();
$model->createAssociatedAction(X2Model::getAssociationType(get_class($relatedModel)), $relatedModel->id);
}
}
return;
}
}
}
}
// get products
$products = Product::activeProducts();
$viewData = array('model' => $model, 'users' => $users, 'products' => $products, 'quick' => $quick);
if (!$quick) {
$this->render('create', $viewData);
} else {
if ($model->hasErrors() || $model->hasLineItemErrors) {
// Sneak into the response that validation failed via setting
// the response code manually:
header('HTTP/1.1 400 Validation Error');
}
$this->renderPartial('create', $viewData, false, true);
}
}
$product_id = $product->save();
$pb->set_productbundle_product_relationship($product_id, $product_key, $product_bundle_id);
break;
}
//while
}
//foreach
$pb->tax = 0;
$pb->shipping = 0;
$pb->save();
//Save any product bundle comment
if (isset($bundle['comment'])) {
$product_bundle_note = new ProductBundleNote();
$product_bundle_note->description = $bundle['comment'];
$product_bundle_note->save();
$pb->set_product_bundle_note_relationship($bundle_key, $product_bundle_note->id, $product_bundle_id);
}
$pb->set_productbundle_quote_relationship($focus->id, $product_bundle_id, $bundle_key);
$focus->tax += $pb->tax;
$focus->shipping += $pb->shipping;
$focus->subtotal += $pb->subtotal;
$focus->deal_tot += $pb->deal_tot;
$focus->new_sub += $pb->new_sub;
$focus->total += $pb->total;
}
//foreach
//Save the quote
$focus->save();
}
//foreach
}
public function run()
{
if ($this->id == 'edit') {
$id = !empty($_GET['id']) ? $_GET['id'] : 0;
$quote = Quote::model()->with('tags', 'author')->findByPk($id);
if ($quote === null) {
throw new CHttpException(404, 'Quote not found');
}
} else {
// add action
$quote = new Quote();
}
if (!$quote->author) {
$quote->author = new Author();
}
if (!empty($_POST['Quote']) && is_array($_POST['Quote'])) {
$quote->attributes = $_POST['Quote'];
/*
* Process approved time.
*/
$approved = !empty($_POST['Quote']['approvedTime']);
if (!$quote->approvedTime && $approved) {
$quote->approvedTime = time();
} elseif (!$approved) {
$quote->approvedTime = 0;
}
/*
* Process author.
*/
if ($_POST['Quote']['authorId']) {
// Existing author.
$author = Author::model()->findByPk($_POST['Quote']['authorId']);
if ($author === null) {
throw new CException("Author with \"{$_POST['Quote']['authorId']}\" not found.");
}
} else {
// New author.
$authorName = $_POST['Quote']['authorCustomName'];
// At first try to find author with the same name.
$criteria = new CDbCriteria();
$criteria->condition = 'name = :name';
$criteria->params = array(':name' => $authorName);
$author = Author::model()->find($criteria);
if ($author === null) {
$author = new Author();
$author->name = $authorName;
$author->save();
}
}
$quote->authorId = $author->id;
/*
* Process tags.
*/
if (!empty($_POST['tags']) && is_array($_POST['tags'])) {
$tags = $_POST['tags'];
} else {
$tags = array();
}
$tagsObj = array();
foreach ($tags as $tag) {
$tagsObj[] = Tag::model()->findByPk($tag);
}
$quote->tags = $tagsObj;
if ($quote->save()) {
Yii::app()->user->setFlash('generalMessage', 'Quote was saved successfully.');
$this->controller->redirect(array('list'));
}
}
$criteria = new CDbCriteria();
$criteria->order = 'name';
$authors = Author::model()->findAll($criteria);
$this->controller->render('edit', array('quote' => $quote, 'authors' => $authors));
}
public function create_history($id)
{
$this->autoRender = false;
// backup old version
$quote_id = (int) $id;
App::import('Model', 'QuoteManager.Quote');
$quote = new Quote();
$quote_model = new Quote();
$quote_model->recursive = -1;
// cake_debug($quote_id); exit;
$backup_data = $quote->find('first', array('conditions' => array('Quote.id' => $quote_id)));
$update_version = $quote->find('first', array('conditions' => array('Quote.id' => $quote_id)));
$versions = $quote_model->find('all', array('conditions' => array('Quote.vid' => $quote_id)));
$current_version = count($versions) + 1;
$quote_number_split = explode('-', $update_version['Quote']['quote_number']);
$update_version['Quote']['quote_number'] = "{$quote_number_split[0]}-{$current_version}";
$this->request->data['Quote']['quote_number'] = "{$quote_number_split[0]}-{$current_version}";
$update_version['Quote']['current_version'] = $current_version;
$update_version['Quote']['status'] = "Revision";
// pr($update_version['Quote']); exit;
$quote_model->save($update_version['Quote']);
$current_user = $this->loginUser;
$backup_data['Quote']['vid'] = $quote_id;
$backup_data['Quote']['id'] = null;
$backup_data['Quote']['created'] = date('Y-m-d H:i:s');
$backup_data['Quote']['created_by'] = isset($current_user['id']) ? $current_user['id'] : '0';
unset($backup_data['WorkOrder']);
unset($backup_data['PurchaseOrder']);
$backup_data_all = $backup_data;
unset($backup_data['QuoteStatus']);
unset($backup_data['CabinetOrder']);
unset($backup_data['QuoteInstallerPaysheet']);
unset($backup_data['CabinetOrderItem']);
unset($backup_data['Customer']);
unset($backup_data['User']);
unset($backup_data['UserCreated']);
unset($backup_data['Invoice']);
unset($backup_data['GraniteOrder']);
unset($backup_data['GraniteOrderItem']);
// pr($backup_data);exit;
$flag = $quote->save($backup_data['Quote'], false);
$backup_data['Quote']['vid'] = $quote_id;
// old quote id
$quote_id = (int) $quote->id;
// new quote id
if (isset($this->request->data['QuoteStatus']) && !empty($this->request->data['QuoteStatus'])) {
$this->request->data['QuoteStatus']['quote_vid'] = $quote_id;
}
$backup_data['Quote']['id'] = $quote_id;
// Quote Installer Paysheet
foreach ($backup_data_all['QuoteInstallerPaysheet'] as $index => $value) {
$backup_data_all['QuoteInstallerPaysheet'][$index]['id'] = null;
$backup_data_all['QuoteInstallerPaysheet'][$index]['quote_id'] = $quote_id;
}
App::import('Model', 'QuoteManager.QuoteInstallerPaysheet');
$QuoteInstallerPaysheet = new QuoteInstallerPaysheet();
$QuoteInstallerPaysheet->saveAll($backup_data_all['QuoteInstallerPaysheet']);
// Quote Status
foreach ($backup_data_all['QuoteStatus'] as $index => $value) {
$backup_data_all['QuoteStatus'][$index]['id'] = null;
$backup_data_all['QuoteStatus'][$index]['quote_id'] = $quote_id;
$backup_data_all['QuoteStatus'][$index]['quote_vid'] = $backup_data['Quote']['vid'];
}
App::import('Model', 'QuoteManager.QuoteStatus');
$QuoteStatus = new QuoteStatus();
$QuoteStatus->saveAll($backup_data_all['QuoteStatus']);
if (!empty($backup_data_all['GraniteOrder'])) {
// Granite Order
foreach ($backup_data_all['GraniteOrder'] as $index => $value) {
$backup_data_all['GraniteOrder'][$index]['id'] = null;
$backup_data_all['GraniteOrder'][$index]['quote_id'] = $quote_id;
}
App::import('Model', 'QuoteManager.GraniteOrder');
$graniteOrder = new GraniteOrder();
$graniteOrder->saveAll($backup_data_all['GraniteOrder']);
// Granite Order Item
foreach ($backup_data_all['GraniteOrderItem'] as $index => $value) {
$backup_data_all['GraniteOrderItem'][$index]['id'] = null;
$backup_data_all['GraniteOrderItem'][$index]['quote_id'] = $quote_id;
$backup_data_all['GraniteOrderItem'][$index]['granite_order_id'] = $graniteOrder->id;
}
App::import('Model', 'QuoteManager.GraniteOrderItem');
$graniteOrderItem = new GraniteOrderItem();
$graniteOrderItem->saveAll($backup_data_all['GraniteOrderItem']);
}
if (!empty($backup_data_all['CabinetOrder'])) {
// Cabinet Order
foreach ($backup_data_all['CabinetOrder'] as $index => $value) {
$backup_data_all['CabinetOrder'][$index]['id'] = null;
$backup_data_all['CabinetOrder'][$index]['quote_id'] = $quote_id;
}
App::import('Model', 'QuoteManager.CabinetOrder');
$CabinetOrder = new CabinetOrder();
$CabinetOrder->saveAll($backup_data_all['CabinetOrder'], false);
}
// Cabinet Order Item
// foreach ($backup_data_all['CabinetOrderItem'] as $index => $value) {
// $backup_data_all['CabinetOrderItem'][$index]['id'] = null;
// $backup_data_all['CabinetOrderItem'][$index]['quote_id'] = $quote_id;
//// $backup_data_all['CabinetOrderItem'][$index]['cabinet_order_id'] = $CabinetOrder->id;
// }
// App::import('Model', 'QuoteManager.CabinetOrderItem');
// $CabinetOrderItem = new CabinetOrderItem();
// $CabinetOrderItem->saveAll($backup_data_all['CabinetOrderItem']);
// }
}
/**
* add method
*
* @return void
*/
public function reset_quote_cabinets($quote_id)
{
$quote_cabinets = array();
App::import("Model", "QuoteManager.Quote");
$quote_model = new Quote();
$quote = $quote_model->read(null, $quote_id);
$drawer = $this->request['data']['Global']['drawer'];
$drawer_slide = $this->request['data']['Global']['drawer_slide'];
$delivery = $this->request['data']['Global']['delivery'];
$installation = $this->request['data']['Global']['installation'];
$is_interior_melamine = $this->request['data']['Global']['is_interior_melamine'];
$quote['Quote']['drawer'] = $drawer;
$quote['Quote']['drawer_slide'] = $drawer_slide;
$quote['Quote']['delivery'] = $delivery;
$quote['Quote']['installation'] = $installation;
$quote['Quote']['is_interior_melamine'] = $is_interior_melamine;
$quote_model->save($quote);
$this->CabinetOrder->deleteAll(array('quote_id' => $quote_id));
if (isset($this->request['data']['CabinetOrder']) && is_array($this->request['data']['CabinetOrder']) && !empty($this->request['data']['CabinetOrder'])) {
foreach ($this->request['data']['CabinetOrder'] as $cabinet) {
if ($cabinet['temporary']) {
continue;
// skip the not saved one
}
if ($cabinet['temporary_delete']) {
unset($cabinet['temporary_delete']);
}
$cabinet['quote_id'] = $quote_id;
switch ($cabinet['resource_type']) {
case 'cabinet':
$resource_id = $cabinet['resource_id'];
// $resource_type = $cabinet['resource_type'];
$cabinet_color = $cabinet['cabinet_color'];
$material_id = $cabinet['material_id'];
$door_id = $cabinet['door_id'];
$door_color = $cabinet['door_color'];
$quote_cabinets[] = $cabinet + array('quote_id' => $quote_id);
break;
case 'custom_panel':
case 'custom_door':
$cabinet['resource_id'] = '0';
$quote_cabinets[] = $cabinet;
break;
default:
$quote_cabinets[] = $cabinet;
break;
}
}
$this->CabinetOrder->saveAll($quote_cabinets);
}
$this->redirect(FULL_BASE_URL . $this->webroot . 'quote_manager/quotes/detail/' . $quote_id . '#quote-detail');
}
public function actionQuickCreate()
{
if (isset($_POST['Quote'])) {
foreach ($_POST as $key => $arr) {
$pieces = explode("_", $key);
if (isset($pieces[0]) && $pieces[0] == 'autoselect') {
$newKey = $pieces[1];
if (isset($_POST[$newKey . "_id"]) && $_POST[$newKey . "_id"] != "") {
$val = $_POST[$newKey . "_id"];
} else {
$field = Fields::model()->findByAttributes(array('fieldName' => $newKey));
if (isset($field)) {
$type = ucfirst($field->linkType);
if ($type != "Contacts") {
eval("\$lookupModel={$type}::model()->findByAttributes(array('name'=>'{$arr}'));");
} else {
$names = explode(" ", $arr);
$lookupModel = Contacts::model()->findByAttributes(array('firstName' => $names[0], 'lastName' => $names[1]));
}
if (isset($lookupModel)) {
$val = $lookupModel->id;
} else {
$val = $arr;
}
}
}
$model->{$newKey} = $val;
}
}
// $this->render('test', array('model'=>$_POST));
$model = new Quote();
$oldAttributes = $model->attributes;
foreach (array_keys($model->attributes) as $field) {
if (isset($_POST['Quote'][$field])) {
$model->{$field} = $_POST['Quote'][$field];
$fieldData = Fields::model()->findByAttributes(array('modelName' => 'Quotes', 'fieldName' => $field));
if ($fieldData->type == 'assignment' && $fieldData->linkType == 'multiple') {
$model->{$field} = Accounts::parseUsers($model->{$field});
} elseif ($fieldData->type == 'date') {
$model->{$field} = $this->parseDate($model->{$field});
}
}
}
$contacts = $_POST['associatedContacts'];
// get contacts
$contact = Contacts::model()->findByPk($contacts[0]);
$model->associatedContacts = $contact->id;
$redirect = $_POST['redirect'];
// get product names
$allProducts = Product::model()->findAll(array('select' => 'id, name, currency'));
$productNames = array(0 => '');
foreach ($allProducts as $product) {
$productNames[$product->id] = $product->name;
$productCurrency[$product->id] = $product->currency;
}
$currency = Yii::app()->params->currency;
// get products
if (isset($_POST['ExistingProducts'])) {
$ids = $_POST['ExistingProducts']['id'];
$prices = $_POST['ExistingProducts']['price'];
$quantities = $_POST['ExistingProducts']['quantity'];
$adjustments = $_POST['ExistingProducts']['adjustment'];
$products = array();
foreach ($ids as $key => $id) {
if ($id != 0) {
// remove blanks
$products[$key]['id'] = $id;
$products[$key]['name'] = $productNames[$id];
$products[$key]['price'] = $prices[$key];
$products[$key]['quantity'] = $quantities[$key];
if (strchr($adjustments[$key], '%')) {
// percent adjustment
$products[$key]['adjustment'] = floatval(str_replace("%", "", $adjustments[$key]));
$products[$key]['adjustmentType'] = 'percent';
} else {
$products[$key]['adjustment'] = $adjustments[$key];
$products[$key]['adjustmentType'] = 'linear';
}
}
}
} else {
$products = array();
}
if (!empty($products)) {
$currency = $productCurrency[$products[0]['id']];
}
$model->currency = $currency;
$model->createDate = time();
$model->lastUpdated = time();
$model->createdBy = Yii::app()->user->getName();
$model->updatedBy = Yii::app()->user->getName();
if ($model->save()) {
$changes = $this->calculateChanges($oldAttributes, $model->attributes, $model);
$this->updateChangelog($model, $changes);
// tie contacts to quote
/*
foreach($contacts as $contactid) {
$relate = new Relationships;
$relate->firstId = $model->id;
$relate->firstType = "quotes";
$relate->secondId = $contactid;
$relate->secondType = "contacts";
$relate->save();
} */
// tie products to quote
foreach ($products as $product) {
$qp = new QuoteProduct();
$qp->quoteId = $model->id;
$qp->productId = $product['id'];
$qp->name = $product['name'];
$qp->price = $product['price'];
$qp->quantity = $product['quantity'];
$qp->adjustment = $product['adjustment'];
$qp->adjustmentType = $product['adjustmentType'];
$qp->save();
}
// generate history
$action = new Actions();
$action->associationType = 'contacts';
$action->type = 'quotes';
$action->associationId = $contact->id;
$action->associationName = $contact->name;
$action->assignedTo = Yii::app()->user->getName();
$action->completedBy = Yii::app()->user->getName();
$action->createDate = time();
$action->dueDate = time();
$action->completeDate = time();
$action->visibility = 1;
$action->complete = 'Yes';
$created = Yii::app()->dateFormatter->format(Yii::app()->locale->getDateFormat('long'), $model->createDate);
$updated = Yii::app()->dateFormatter->format(Yii::app()->locale->getDateFormat('long'), $model->lastUpdated);
$expires = Yii::app()->dateFormatter->format(Yii::app()->locale->getDateFormat('long'), $model->expirationDate);
$description = "New Quote: <b>{$model->id}</b> {$model->name} ({$model->status})\n\t\t\t\tCreated: <b>{$created}</b>\n\t\t\t\tUpdated: <b>{$updated}</b> by <b>{$model->updatedBy}</b>\n\t\t\t\tExpires: <b>{$expires}</b>\n\n";
$table = $model->productTable();
$table = str_replace("\n", "", $table);
$table = str_replace("\t", "", $table);
$description .= $table;
$action->actionDescription = $description;
$action->save();
}
Yii::app()->clientScript->scriptMap['*.js'] = false;
$contact = Contacts::model()->findByPk($contacts[0]);
$this->renderPartial('quoteFormWrapper', array('model' => $contact), false, true);
}
}
if (!$quotes) {
die('no_pending_quotes');
break;
}
require classes_dir . 'quote.php';
echo 'Approving: ';
foreach ($quotes as $quoteid) {
$quote = new Quote();
$quote->permaid = $quoteid['permaid'];
if (!$quote->read()) {
continue;
}
printf('%s ', $quote->permaid);
$push->hit(sprintf(_('New quote: %s - %s'), $quote->permalink, $quote->excerpt));
$quote->status = 'approved';
$quote->save(false);
unset($quote);
}
break;
case 'privacy_login':
$db->query('UPDATE sites SET privacy_level = 2 WHERE db = :db', array(array(':db', $settings->db, PDO::PARAM_STR)));
break;
case 'privacy_hide_all':
$db->query('UPDATE sites SET privacy_level = 1 WHERE db = :db', array(array(':db', $settings->db, PDO::PARAM_STR)));
break;
case 'privacy_unhide_all':
$db->query('UPDATE sites SET privacy_level = 0 WHERE db = :db', array(array(':db', $settings->db, PDO::PARAM_STR)));
break;
case 'privacy_show_all':
$db->query('UPDATE sites SET privacy_level = -1 WHERE db = :db', array(array(':db', $settings->db, PDO::PARAM_STR)));
break;
public function actionSave()
{
$user = Yii::app()->user->getProfile();
$quoteText = Yii::app()->getRequest()->getParam('text', null);
if (!$quoteText === null) {
return false;
}
$blockId = Yii::app()->getRequest()->getParam('blockId', null);
if ($blockId !== null) {
$arr = explode('-', $blockId);
$blockId = key_exists(0, $arr) ? (int) $arr[0] : 0;
$block = Block::model()->published()->findByPK($blockId);
if ($block === false) {
return false;
}
} else {
return false;
}
// Создаем и сохраняем цитату
$quote = new Quote();
$quote->user_id = $user->id;
$quote->block_id = $block->id;
$quote->content = $quoteText;
if ($quote->save()) {
// Общее кол-во цитат
$totalCount = Quote::model()->user($user->id)->program($quote->course_type_id)->count();
// Возвращаем ответ
$resp = array('status' => 1, 'data' => array('id' => $quote->id, 'text' => $quote->getContent(), 'url' => $quote->getUrl(), 'totalCount' => $totalCount));
Yii::app()->ajax->raw($resp);
} else {
$resp = array('status' => 0, 'error' => 'Ошибка сохранения.');
Yii::app()->ajax->raw($resp);
}
}
public function addQuote()
{
$act = 'add';
if (Input::has('submit')) {
$rules = array('quote' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->passes()) {
$quote = new Quote();
$quote->quote = Input::get('quote');
$quote->date = Input::get('date');
$quote->save();
return Redirect::to('admin/rkmquote')->with('sukses', 'Rekam data berhasil!');
} else {
return Redirect::to('admin/rkmquote')->withInput()->withErrors($validator);
}
} else {
return View::make('admin.quote', compact('act'));
}
}
if (isset($params[1])) {
switch ($params[1]) {
case 'post':
if ($_SERVER['REQUEST_METHOD'] != 'POST') {
redir(sprintf('%ssubmit', $settings->base_url));
}
$quote = new Quote();
$quote->nick = $_POST['nick'];
$quote->ip = $session->ip;
$quote->text = $_POST['text'];
$quote->comment = $_POST['comment'];
$quote->hidden = isset($_POST['hidden']) && $_POST['hidden'] == 'on';
$quote->status = $session->level == 'admin' ? 'approved' : 'pending';
$quote->api = 1;
// web
$permaid = $quote->save();
if ($permaid === false) {
redir(sprintf('%ssubmit/invalid', $settings->base_url));
}
if ($quote->status == 'approved') {
redir(sprintf('%s%s', $settings->base_url, $permaid));
} else {
redir(sprintf('%ssubmit/sent', $settings->base_url));
}
break;
case 'invalid':
$html->do_sysmsg(_('Oops!'), _('Your quote has not been sent. Maybe it was too short?'), 200);
break;
case 'sent':
$html->do_sysmsg(_('Quote sent!'), _('Your quote has been submitted and is now pending approval!'), 200);
break;
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$this->line('Lets start our migration.');
//Migrate Groups to Roles
$groups = DB::connection('oldmysql')->table('groups');
$this->line($groups->count() . ' groups[\'s] were found in the legacy database');
foreach ($groups->get() as $group) {
$role = new Role();
$role->name = $group->group;
$role->save();
}
//Migrate Users
$users = DB::connection('oldmysql')->table('users');
$this->line($users->count() . ' user[\'s] were found in the legacy database');
foreach ($users->get() as $user) {
$this->line('Migrating user: '******'oldmysql')->table('groups')->where('id', $user->group)->first();
$myrole = Role::where('name', $group->group)->first();
$newuser->roles()->attach($myrole);
$this->line('Adding user to role: ' . $group->group);
}
//Migrate Users
$quotes = DB::connection('oldmysql')->table('quotes');
$this->line($quotes->count() . ' quote[\'s] were found in the legacy database');
foreach ($quotes->get() as $quote) {
$this->line('Migrating quote: #' . $quote->id);
$newquote = new Quote();
$newquote->timestamps = false;
$newquote->id = $quote->id;
$newquote->title = $quote->title;
$newquote->quote = $quote->quote;
$user = User::find($quote->userid);
$newquote->user()->associate($user);
$newquote->status = $quote->approved;
$newquote->created_at = date('Y-m-d H:i:s', $quote->timestamp);
$newquote->updated_at = date('Y-m-d H:i:s', $quote->timestamp);
$newquote->save();
}
$votes = DB::connection('oldmysql')->table('votes');
$this->line($votes->count() . ' vote[\'s] were found in the legacy database');
foreach ($votes->get() as $vote) {
$user = User::find($vote->userid);
$quote = Quote::find($vote->quoteid);
if ($user && $quote) {
if ($vote->vote == 1) {
$this->line($user->username . ' voted up #' . $quote->id);
} else {
$this->line($user->username . ' voted down #' . $quote->id);
}
if ($quote) {
$vuser = $quote->voted()->whereUserId($vote->userid)->first();
if (!$vuser) {
$quote->voted()->attach($user, array('vote' => $vote->vote));
} else {
$vuser->pivot->vote = $vote->vote;
$vuser->pivot->save();
}
}
//Our confidence has changed in this quote.
$quote->updateVoteConfidence();
} else {
if (!$quote) {
$this->line('Vote #' . $vote->id . ' could not be imported because the quote doesn\'t exist');
}
if (!$user) {
$this->line('Vote #' . $vote->id . ' could not be imported because the user doesn\'t exist');
}
}
}
}
