public function actionCreate() { $typeId = Yii::app()->request->getParam('typeId', 0); $model = new Site(); $model->dpid = $this->companyId; $model->type_id = $typeId; if (Yii::app()->request->isPostRequest) { $model->attributes = Yii::app()->request->getPost('Site'); $se = new Sequence("site"); $model->lid = $se->nextval(); $model->create_at = date('Y-m-d H:i:s', time()); $model->update_at = date('Y-m-d H:i:s', time()); $model->delete_flag = '0'; //var_dump($model);exit; if ($model->save()) { Yii::app()->user->setFlash('success', yii::t('app', '添加成功')); $this->redirect(array('site/index', 'typeId' => $typeId, 'companyId' => $this->companyId)); } } $types = $this->getTypes(); $floors = $this->getFloors(); $sitepersons = $this->getSitePersons(); //var_dump($floors); //var_dump($types);exit; $this->render('create', array('model' => $model, 'types' => $types, 'floors' => $floors, 'sitepersons' => $sitepersons)); }
public static function save() { $params = $_POST; $v = new Valitron\Validator($params); $v->rule('required', 'site_name'); $v->rule('lengthMin', 'site_name', 5); $v->rule('numeric', 'latitude'); $v->rule('required', 'latitude'); $v->rule('lengthMin', 'latitude', 4); $v->rule('lengthMax', 'latitude', 7); $v->rule('numeric', 'latitude'); $v->rule('required', 'longitude'); $v->rule('lengthMin', 'longitude', 4); $v->rule('lengthMax', 'longitude', 7); $v->rule('numeric', 'longitude'); $v->rule('required', 'area'); $v->rule('required', 'tent'); $v->rule('required', 'grade'); $attributes = array('site_name' => $params['site_name'], 'latitude' => $params['latitude'], 'longitude' => $params['longitude'], 'area' => $params['area'], 'tent' => $params['tent'], 'grade' => $params['grade'], 'user_id' => $_SESSION['user'], 'content' => $params['content']); if ($v->validate()) { $attributes = array('site_name' => $params['site_name'], 'latitude' => $params['latitude'], 'longitude' => $params['longitude'], 'area' => $params['area'], 'tent' => $params['tent'], 'grade' => $params['grade'], 'user_id' => $_SESSION['user'], 'content' => $params['content']); $site = new Site($attributes); $site->save(); Redirect::to('/site/show_site/' . $site->id, array('message' => 'Uusi telttapaikka on luotu!')); } else { View::make('site/new_site.html', array('errors' => $v->errors(), 'attributes' => $attributes, 'message' => 'Annetuissa tiedoissa puutteita tai virheitä')); } }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { $site = new Site(); $site->name = Input::get('name'); $site->save(); return Redirect::to('site'); }
public function create($data, $save = true) { $site = new Site($this, $data); if ($save) { $site->save(); } return $site; }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Site(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Site'])) { $model->attributes = $_POST['Site']; if ($model->save()) { $this->redirect(array('view', 'id' => $model->id)); } } $this->render('create', array('model' => $model)); }
/** * Updates a particular model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id the ID of the model to be updated */ public function actionIndex() { $model = Site::model()->find(); if ($model === NULL) { $model = new Site(); } if (isset($_POST['Site'])) { $model->attributes = $_POST['Site']; if ($model->save()) { Yii::app()->user->setFlash('success', '信息提交成功!'); } else { Yii::app()->user->setFlash('success', '信息提交失败!'); } } $this->render('index', array('model' => $model)); }
/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their coresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aSite !== null) { if ($this->aSite->isModified() || $this->aSite->isNew()) { $affectedRows += $this->aSite->save($con); } $this->setSite($this->aSite); } if ($this->aFeed !== null) { if ($this->aFeed->isModified() || $this->aFeed->isNew()) { $affectedRows += $this->aFeed->save($con); } $this->setFeed($this->aFeed); } if ($this->isNew()) { $this->modifiedColumns[] = SitefeedPeer::ID; } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = SitefeedPeer::doInsert($this, $con); $affectedRows += 1; // we are assuming that there is only 1 row per doInsert() which // should always be true here (even though technically // BasePeer::doInsert() can insert multiple rows). $this->setId($pk); //[IMV] update autoincrement primary key $this->setNew(false); } else { $affectedRows += SitefeedPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } $this->alreadyInSave = false; } return $affectedRows; }
public function setUp() { parent::setUp(); $user = User::firstOrCreate(['email' => '*****@*****.**']); //if first user, create site object if (\User::count() == 1) { $site = new \Site(); $site->name = ''; $site->description = ''; $site->email = $user->email; $site->lang = 'en-US'; $site->create_lrs = array('super'); $site->registration = 'Closed'; $site->restrict = 'None'; //restrict registration to a specific email domain $site->domain = ''; $site->super = array(array('user' => $user->_id)); $site->save(); } }
public function handle($user) { //if first user, create site object if (\User::count() == 1) { $site = new \Site(); $site->name = ''; $site->description = ''; $site->email = $user->email; $site->lang = 'en-US'; $site->create_lrs = array('super'); $site->registration = 'Closed'; $site->restrict = 'None'; //restrict registration to a specific email domain $site->domain = ''; $site->super = array(array('user' => $user->_id)); $site->save(); } //now send an email asking to verify email $this->sendEmail($user); }
public function prepareData() { $site = new Site(); $site->site_id = 1; $site->site_domain = 'site1'; $site->save(); $site = new Site(); $site->site_id = 2; $site->site_domain = 'site2'; $site->save(); $var = new Variable(); $var->variable_id = 1; $var->variable_name = 'var1'; $var->save(); $var = new Variable(); $var->variable_id = 2; $var->variable_name = 'var2'; $var->save(); $varval = new SiteVarvalue(); $varval->site_id = 1; $varval->variable_id = 1; $varval->varvalue_value = 'val1 dom1 var1'; $varval->save(); $varval = new SiteVarvalue(); $varval->site_id = 1; $varval->variable_id = 2; $varval->varvalue_value = 'val2 dom1 var2'; $varval->save(); $varval = new SiteVarvalue(); $varval->site_id = 2; $varval->variable_id = 1; $varval->varvalue_value = 'val3 dom2 var1'; $varval->save(); $varval = new SiteVarvalue(); $varval->site_id = 2; $varval->variable_id = 2; $varval->varvalue_value = 'val4 dom2 var2'; $varval->save(); }
function executeSave() { $request = fvRequest::getInstance(); if (!($Site = SiteManager::getInstance()->getByPk($request->getRequestParameter('id')))) { $Site = new Site(); } $s = $request->getRequestParameter('s'); $Site->updateFromRequest($s); if ($Site->save()) { fvResponce::getInstance()->setHeader('Id', $Site->getPk()); $this->setFlash("Данные успешно сохранены", self::$FLASH_SUCCESS); fvResponce::getInstance()->setHeader('redirect', fvSite::$fvConfig->get('dir_web_root') . $request->getRequestParameter('module') . "/?id=" . $Site->getPk()); } else { fvResponce::getInstance()->setHeader('X-JSON', json_encode($Site->getValidationResult())); $this->setFlash("Ошибка при сохранении данных проверте правильность введенных данных", self::$FLASH_ERROR); } if (fvRequest::getInstance()->isXmlHttpRequest()) { return self::$FV_AJAX_CALL; } else { return self::$FV_OK; } }
function Site($address) { $db = new DB(); $this->address = $address; if (substr($this->address, -1, 1) == '/') { $this->address = substr($this->address, 0, strlen($this->address) - 1); // Remove trailing / } $db->query("SELECT * FROM site WHERE address = '" . $this->address . "'"); if ($db->numRows() == 0) { // No record in the DB $db->close(); $this->loaded = 0; $newad = str_replace("http://", '', $this->address); $newad = preg_replace('/\\/.*$/', '', $newad); $newad = 'http://' . $newad; if ($this->address == $newad) { $this->parent = ""; $this->lock = 0; } else { $s = new Site($newad); if ($s->loaded) { $this->parent = $s->sid; $this->lock = $s->lock; } else { $s->save(); } } } else { $siteinfo = $db->fetchRow(); $this->lock = $siteinfo[3]; $this->parent = $siteinfo[1]; $this->sid = $siteinfo[0]; $db->close(); $this->loaded = 1; } }
if (!isset($_SESSION['uid'])) { die('Sorry, you need to be logged in to edit pages'); } if ($_POST['address'] == '' || $_POST['source'] == '') { die('Sorry, there was an error recieving all the fields'); } $s = new Site($_POST['address']); if (!$s->loaded) { $s->checkWWW(); } if ($s->lock) { print "Sorry, this page is locked"; die; } if (!$s->loaded) { $s->save(); } $ip = $_SERVER['REMOTE_ADDR']; $rating = 0; $comment = htmlentities($_POST['comment']); $source = str_replace("\r", '', WikiWideWebize($s, getSource($_POST['address']))); $source = str_replace(" />", ">", $source); $nsource = str_replace("\r", '', stripslashes($_POST['source'])); $nsource = str_replace(" />", ">", $nsource); $nsource = preg_replace("/<\\/?([A-Z]+)[^>]*>/Ue", "strtolower('\$1')", $nsource); $source = preg_replace("/<\\/?([A-Z]+)[^>]*>/Ue", "strtolower('\$1')", $source); $source2 = explode("\n", $source); $source = explode("\n", entityScrub($source)); $nsource = explode("\n", $nsource); $diff = array_diff($nsource, $source); $diff2 = array_diff($source, $nsource);
/** * testHABTMKeepExistingAlternateDataFormat * * @return void */ public function testHABTMKeepExistingAlternateDataFormat() { $this->loadFixtures('Site', 'Domain', 'DomainsSite'); $Site = new Site(); $expected = array(array('DomainsSite' => array('id' => 1, 'site_id' => 1, 'domain_id' => 1, 'active' => true, 'created' => '2007-03-17 01:16:23')), array('DomainsSite' => array('id' => 2, 'site_id' => 1, 'domain_id' => 2, 'active' => true, 'created' => '2007-03-17 01:16:23'))); $result = $Site->DomainsSite->find('all', array('conditions' => array('DomainsSite.site_id' => 1), 'fields' => array('DomainsSite.id', 'DomainsSite.site_id', 'DomainsSite.domain_id', 'DomainsSite.active', 'DomainsSite.created'), 'order' => 'DomainsSite.id')); $this->assertEquals($expected, $result); $time = date('Y-m-d H:i:s'); $data = array('Site' => array('id' => 1), 'Domain' => array(array('site_id' => 1, 'domain_id' => 3, 'created' => $time), array('id' => 2, 'site_id' => 1, 'domain_id' => 2))); $Site->save($data); $expected = array(array('DomainsSite' => array('id' => 2, 'site_id' => 1, 'domain_id' => 2, 'active' => true, 'created' => '2007-03-17 01:16:23')), array('DomainsSite' => array('id' => 7, 'site_id' => 1, 'domain_id' => 3, 'active' => false, 'created' => $time))); $result = $Site->DomainsSite->find('all', array('conditions' => array('DomainsSite.site_id' => 1), 'fields' => array('DomainsSite.id', 'DomainsSite.site_id', 'DomainsSite.domain_id', 'DomainsSite.active', 'DomainsSite.created'), 'order' => 'DomainsSite.id')); $this->assertEquals($expected, $result); }
protected function createSite(\User $user) { $model = new \Site(['name' => 'Test', 'description' => '', 'email' => $user->email, 'lang' => 'en-US', 'create_lrs' => 'super', 'registration' => 'Closed', 'restrict' => 'None', 'domain' => '', 'super' => [['user' => new \MongoId($user->_id)]]]); $success = $model->save(); return $model; }
public static function initializeSite($url = 'localhost', $default = 0, $wildcard = 0) { $site = new Site(); // Is the skins module installed? If so, get the key of the default skin if (class_exists('Skin', TRUE)) { $skin = Doctrine::getTable('Skin')->findOneByDefault(TRUE); if ($skin) { $site['skin_id'] = $skin['skin_id']; } } // Create default site setttings $site['url'] = $url; $site['homepage'] = '/welcome'; $site['wildcard'] = $wildcard; $site['default'] = $default; $site->save(); $site->free(); }
public function actionAddSite() { $errors = array(); $site = new Site(); $contact = new Contact(); $address = new Address(); /* * Set default blank contact to fulfill the current relationship with a site */ $contact->nick_name = 'NULL'; $contact->primary_phone = 'NULL'; $contact->title = NULL; $contact->first_name = ''; $contact->last_name = ''; $contact->qualifications = NULL; $contact->save(); $site->contact_id = $contact->id; $address->contact_id = $contact->id; if (!empty($_POST)) { $site->attributes = $_POST['Site']; if (!$site->validate()) { $errors = $site->getErrors(); } $address->attributes = $_POST['Address']; if (!$address->validate()) { $errors = array_merge($errors, $address->getErrors()); } if (!$errors) { if (!$site->save()) { throw new Exception("Unable to save contact: " . print_r($site->getErrors(), true)); } if (!$address->save()) { throw new Exception("Unable to save address: " . print_r($address->getErrors(), true)); } Audit::add('admin-Site', 'add', $site->id); $this->redirect(array('/admin/editSite?site_id=' . $site->id)); } } $this->render('/admin/addsite', array('site' => $site, 'errors' => $errors, 'address' => $address, 'contact' => $contact)); }
/** * test HABM operations without clobbering existing records #275 * * @return void */ public function testHABTMKeepExisting() { $this->loadFixtures('Site', 'Domain', 'DomainsSite'); $Site = new Site(); $results = $Site->find('count'); $expected = 3; $this->assertEquals($results, $expected); $data = $Site->findById(1); // include api.cakephp.org $data['Domain'] = array('Domain' => array(1, 2, 3)); $Site->save($data); $Site->id = 1; $results = $Site->read(); $expected = 3; // 3 domains belonging to cakephp $this->assertEquals($expected, count($results['Domain'])); $Site->id = 2; $results = $Site->read(); $expected = 2; // 2 domains belonging to markstory $this->assertEquals($expected, count($results['Domain'])); $Site->id = 3; $results = $Site->read(); $expected = 2; $this->assertEquals($expected, count($results['Domain'])); $results['Domain'] = array('Domain' => array(7)); $Site->save($results); // remove association from domain 6 $results = $Site->read(); $expected = 1; // only 1 domain left belonging to rchavik $this->assertEquals($expected, count($results['Domain'])); // add deleted domain back $results['Domain'] = array('Domain' => array(6, 7)); $Site->save($results); $results = $Site->read(); $expected = 2; // 2 domains belonging to rchavik $this->assertEquals($expected, count($results['Domain'])); $Site->DomainsSite->id = $results['Domain'][0]['DomainsSite']['id']; $Site->DomainsSite->saveField('active', true); $results = $Site->Domain->DomainsSite->find('count', array('conditions' => array('DomainsSite.active' => true))); $expected = 5; $this->assertEquals($expected, $results); // activate api.cakephp.org $activated = $Site->DomainsSite->findByDomainId(3); $activated['DomainsSite']['active'] = true; $Site->DomainsSite->save($activated); $results = $Site->DomainsSite->find('count', array('conditions' => array('DomainsSite.active' => true))); $expected = 6; $this->assertEquals($expected, $results); // remove 2 previously active domains, and leave $activated alone $data = array('Site' => array('id' => 1, 'name' => 'cakephp (modified)'), 'Domain' => array('Domain' => array(3))); $Site->create($data); $Site->save($data); // tests that record is still identical prior to removal $Site->id = 1; $results = $Site->read(); unset($results['Domain'][0]['DomainsSite']['updated']); unset($activated['DomainsSite']['updated']); $this->assertEquals($activated['DomainsSite'], $results['Domain'][0]['DomainsSite']); }
public static function createOrder($companyId, $orderId, $orderStatus, $productList, $orderTasteIds, $orderTasteMemo, $callId, Order $order, Site $site, SiteNo $siteNo) { $sellOff = array(); ////////////// //return json_encode(array('status'=>false,'msg'=>"test1")); ///////////// $time = date('Y-m-d H:i:s', time()); $db = Yii::app()->db; $transaction = $db->beginTransaction(); $se = new Sequence("order_product"); $setaste = new Sequence("order_taste"); $orderProductStatus = 0; if ($orderStatus > 1) { $orderProductStatus = 1; } try { ///先删除所有为下单的临时菜品,后插入 $sql = 'delete from nb_order_product where dpid=' . $companyId . ' and product_order_status=0 and order_id =' . $orderId; $result = $db->createCommand($sql)->execute(); //return array('status'=>false,'msg'=>"test11"); //插入订单单品 if (!empty($productList)) { $productListArr = explode(";", $productList); foreach ($productListArr as $tvalue) { //更新库存//失败则返回 $productDetailArr = explode(",", $tvalue); $productdata = Product::model()->find('lid=:lid and dpid=:dpid', array(':lid' => $productDetailArr[2], ':dpid' => $companyId)); //return json_encode(array('status'=>true,'msg'=>$productdata->store_number.$productDetailArr[2].$productDetailArr[3])); if ($productdata->store_number == 0 || $productdata->store_number > 0 && $productdata->store_number < $productDetailArr[3]) { $transaction->rollback(); return array('status' => false, 'msg' => $productdata->product_name . "数量不足"); } ////////套餐数量判断////////////////////////// //不是临时挂单就更新库存,更新下单数和点赞数,发送更新库存消息 if ($orderStatus > 1) { $productdata->order_number = $productdata->order_number + $productDetailArr[4]; $productdata->favourite_number = $productdata->favourite_number + $productDetailArr[4]; if ($productdata->store_number > 0) { $productdata->store_number = $productdata->store_number - $productDetailArr[4]; array_push($sellOff, array("product_id" => sprintf("%010d", $productDetailArr[2]), "type" => "product", "num" => $productdata->store_number)); } ///套餐数量减//////////// } $productdata->save(); //return array('status'=>false,'msg'=>"test111333"); if ($productDetailArr[3] == "0") { //插入 $orderProductId = $se->nextval(); //插入一条 $orderProductData = array('lid' => $orderProductId, 'dpid' => $companyId, 'create_at' => $time, 'order_id' => $orderId, 'set_id' => $productDetailArr[1], 'product_id' => $productDetailArr[2], 'offprice' => $productDetailArr[5], 'price' => $productDetailArr[6], 'update_at' => $time, 'amount' => $productDetailArr[4], 'is_giving' => $productDetailArr[7], 'taste_memo' => $productDetailArr[9], 'product_order_status' => $orderProductStatus); //return array('status'=>false,'msg'=>"test14444".implode("..",$orderProductData)); $db->createCommand()->insert('nb_order_product', $orderProductData); } //修改为先删除后插入,防止以后一个菜品被分开点多分。 ////else{ // //更新 // $orderProductData= OrderProduct::model()->find('lid=:lid and dpid=:dpid' , array(':lid'=>$productDetailArr[0],':dpid'=>$companyId)); // $orderProductData->price=$productDetailArr[3]; // $orderProductData->amount=$productDetailArr[2]; // $orderProductData->is_giving=$productDetailArr[4]; // $orderProductData->taste_memo=$productDetailArr[6]; // $orderProductData->save(); // } //insert taste//delete and insert taste $orderProductTasteIds = str_replace("|", ",", $productDetailArr[8]); if (!empty($orderProductTasteIds)) { $orderProductTasteIds = substr($orderProductTasteIds, 0, strlen($orderProductTasteIds) - 1); $orderProductTasteArr = explode(",", $orderProductTasteIds); $sql2 = 'delete from nb_order_taste where dpid=' . $companyId . ' and is_order=0 and order_id = ' . $productDetailArr[0]; //return json_encode(array('status'=>true,'msg'=>$orderProductTasteIds)); $result = $db->createCommand($sql2)->execute(); //重新插入 if (!empty($orderProductTasteArr)) { foreach ($orderProductTasteArr as $tvalue) { $orderProductTasteId = $setaste->nextval(); //return json_encode(array('status'=>false,'msg'=>$productDetailArr[0]."|".$tvalue."|".$orderTasteId)); $orderProductTasteAll = array('lid' => $orderProductTasteId, 'dpid' => $companyId, 'create_at' => $time, 'update_at' => $time, 'order_id' => $orderProductId, 'taste_id' => $tvalue, 'is_order' => "0", 'delete_flag' => "0"); $db->createCommand()->insert('nb_order_taste', $orderProductTasteAll); } } } } } if (!empty($site)) { if ($site->status < $orderStatus) { $site->status = $orderStatus; $site->update_at = $time; $site->save(); } } if (!empty($siteNo)) { if ($siteNo->status < $orderStatus) { $siteNo->status = $orderStatus; $siteNo->update_at = $time; $siteNo->save(); } } if ($order->order_status < $orderStatus) { $order->order_status = $orderStatus; $order->update_at = $time; } $order->taste_memo = $orderTasteMemo; $order->callno = $callId; $order->save(); //删除全单口味 $orderTasteIds = str_replace("|", ",", $orderTasteIds); if (!empty($orderTasteIds)) { //return json_encode(array('status'=>false,'msg'=>$orderTasteIds)); $orderTasteIds = substr($orderTasteIds, 0, strlen($orderTasteIds) - 1); $orderTasteArr = explode(",", $orderTasteIds); $sql = 'delete from nb_order_taste where dpid=' . $companyId . ' and is_order=1 and order_id =' . $orderId; $result = $db->createCommand($sql)->execute(); //重新插入 //return json_encode(array('status'=>false,'msg'=>"test3")); //$se=new Sequence("order_taste"); if (!empty($orderTasteArr)) { foreach ($orderTasteArr as $tvalue) { $orderTasteId = $setaste->nextval(); $orderTasteAll = array('lid' => $orderTasteId, 'dpid' => $companyId, 'create_at' => $time, 'update_at' => $time, 'order_id' => $orderId, 'taste_id' => $tvalue, 'is_order' => "1", 'delete_flag' => "0"); $db->createCommand()->insert('nb_order_taste', $orderTasteAll); } } } // if(!$savejson["status"]) // { // $ret=json_encode($savejson); // }else{ if ($orderStatus > 1) { $ret = Helper::printKitchenAll3($order, $site, $siteNo, false); if (!$ret['status']) { $transaction->rollback(); } else { $transaction->commit(); } } else { $ret = array('status' => true, 'msg' => "保存成功", 'jobs' => array()); $transaction->commit(); } //估清产品通知 // if(!empty($sellOff)){ // //return array('status'=>false,'msg'=>"沽清:".$sellOff); // Gateway::getOnlineStatus(); // $store = Store::instance('wymenu'); // $pads=Pad::model()->findAll(" dpid = :dpid and delete_flag='0' and pad_type in ('0','1','2')",array(":dpid"=>$dpid)); // //var_dump($pads);exit; // $sendjsondata=json_encode(array("company_id"=>$dpid, // "do_id"=>"sell_off", // "do_data"=>$sellOff)); // //var_dump($sendjsondata);exit; // foreach($pads as $pad) // { // $clientId=$store->get("padclient_".$dpid.$pad->lid); // //var_dump($clientId,$print_data);exit; // if(!empty($clientId)) // { // Gateway::sendToClient($clientId,$sendjsondata); // } // } // } //return array('status'=>true,'msg'=>"保存成功",'jobs'=>array()); return $ret; } catch (Exception $ex) { $transaction->rollback(); return array('status' => false, 'msg' => $e->getMessage(), 'jobs' => array()); } }