public function sendlist() { $id = $_GET['id']; $dispatchlist = Dispatchlist::find($id); \Illuminate\Support\Facades\DB::update("update dispatchlists set status='active' WHERE id='{$dispatchlist->id}'"); return Redirect::to('dispatchlist'); }
/** * Execute the console command. */ public function handle() { $file = base_path('resources') . '/new_name.txt'; $handle = fopen($file, 'r'); if (!$handle) { throw new FileNotFoundException($file); } while (($line = fgets($handle)) !== false) { $data = explode("\t", $line); if (count($data) != 2) { continue; } $newName = trim($data[1]); if (empty($newName)) { continue; } DB::update('update organizations set fullName=' . DB::connection()->getPdo()->quote($newName) . ' where edrpou=' . DB::connection()->getPdo()->quote($data[0]) . ' limit 1'); var_dump(1); // if(++$j >= 2000) { // $values = implode(', ', array_map(function($v){ // foreach($v as &$vv) // $vv = DB::connection()->getPdo()->quote($vv); // return '('. implode(',', $v) .')'; // }, $rows)); // // DB::insert('insert ignore into `fio` (`name`, `nameRU`) values '. $values .' ON DUPLICATE KEY UPDATE c=c+1'); // $j = 0; // $rows = []; // } } fclose($handle); }
function mesajOku($oku) { $mesajOku = DB::select("select k.adi,k.soyadi,m.mesaj,m.tarih from mesajlar as m left join kullanicilar as k on m.gonderen_id=k.id where m.id = ? limit 0,1", array($oku)); $d = DB::update('update mesajlar set durum=1 where id = ?', array($oku)); $kullanici["user"] = $mesajOku[0]; return view('admin/mesajOku', array('kullanici' => $kullanici)); }
public function duzenleUrun($urun_id) { $form = Input::all(); $kural = array('kategori_id' => 'required', 'baslik' => 'required', 'kisa_aciklama' => 'required', 'aciklama' => 'required', 'fiyat' => 'required', 'kampanya' => 'required', 'piyasa_fiyati' => 'required', 'durum' => 'required', 'stok' => 'required'); $dogrulama = \Validator::Make($form, $kural); if ($dogrulama->fails()) { // gönderilen verilerde hata var return \Redirect::to('admin/urunDuzenle/' . $urun_id)->withErrors($dogrulama)->withInput(); } $form["bugunteslimat"] = isset($form["bugunteslimat"]) ? 1 : 0; $form["coksatan"] = isset($form["coksatan"]) ? 1 : 0; $form["kargobedava"] = isset($form["kargobedava"]) ? 1 : 0; $form["indirimliurun"] = isset($form["indirimliurun"]) ? 1 : 0; $form["onecikan"] = isset($form["onecikan"]) ? 1 : 0; $q = "UPDATE urunler SET kategori_id = ?, baslik=? , kisa_aciklama = ?, aciklama = ?, fiyat=? ,kampanya=? ,piyasa_fiyati=? ,durum=? ,stok=?, one_cikan=?, indirimli_urun=?, cok_satan=?, kargo_bedava=?, bugun_teslimat=? WHERE id = ?"; $islem = DB::update($q, array($form["kategori_id"], $form["baslik"], $form["kisa_aciklama"], $form["aciklama"], $form["fiyat"], $form["kampanya"], $form["piyasa_fiyati"], $form["durum"], $form["stok"], $form["onecikan"], $form["indirimliurun"], $form["coksatan"], $form["kargobedava"], $form["bugunteslimat"], $urun_id)); if ($islem) { $mesaj = "basarili"; return Redirect::to("admin/urun")->with("mesaj", $mesaj); } else { $mesaj = "basarisiz"; return Redirect::to("admin/urun")->with("mesaj", $mesaj); } // Mesaj session'a yazılıyor redirect yapıldığı için. }
/** * UPDATE query * @param array $content string contendo campos e valores que serao atualizados * @param string $filter string com filtro para atualização */ public function updateData($dados, $filter) { $this->validateTable(); $dados = key($dados) . ' = ' . $dados[key($dados)]; $filter = key($filter) . ' = ' . $filter[key($filter)]; return DB::update('UPDATE ' . $this->table_name . ' SET ' . $dados . ' WHERE ' . $filter); }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('dramas', function (Blueprint $table) { $table->integer('favorites')->after('reviews')->default(0); }); DB::update('update dramas set favorites=(select count(*) from favorites where drama_id=dramas.id and deleted_at is null)'); }
/** * Execute the console command. * * @return mixed */ public function handle() { //GOAL TRAVEL $qt = "UPDATE \t goal_travel\n SET duration_complete = duration_complete +1\n WHERE\t\tduration_complete < duration\n AND\t\t\tflg=1"; //GOAL CAR $qc = "UPDATE \t goal_car\n SET duration_complete = duration_complete +1\n WHERE\t\tduration_complete < duration\n AND\t\t\tflg=1"; //GOAL GENERAL $qg = "UPDATE \t goal_general\n SET duration_complete = duration_complete +1\n WHERE\t\tduration_complete < duration\n AND\t\t\tflg=1"; //GOAL HOME $qh = "UPDATE \t goal_home\n SET duration_complete = duration_complete +1\n WHERE\t\tduration_complete < duration\n AND\t\t\tflg=1"; if (!DB::update($qt)) { echo "log error - travel"; } if (!DB::update($qc)) { echo "log error - car"; } if (!DB::update($qg)) { echo "log error - general"; } if (!DB::update($qh)) { echo "log error - home"; } /** * Update the flg to zero is goal completed */ $qu = "UPDATE \tgoal_general\n SET\t flg=0\n WHERE\t\tduration_complete = duration"; DB::update($qu); $qu = "UPDATE \tgoal_travel\n SET\t flg=0\n WHERE\t\tduration_complete = duration"; DB::update($qu); $qu = "UPDATE \tgoal_car\n SET\t flg=0\n WHERE\t\tduration_complete = duration"; DB::update($qu); $qu = "UPDATE \tgoal_home\n SET\t flg=0\n WHERE\t\tduration_complete = duration"; DB::update($qu); }
public function clear(Request $request) { $post = $request->all(); $comment = $post['comment']; $value = $post['amount']; $student = $post['regNo']; $clearedAt = $post['signedAt']; $clearedBy = $post['signedBy']; $comment = preg_replace('/[^A-Za-z0-9 _]/', '', $comment); $value = preg_replace('/[^0-9]/', '', $value); DB::beginTransaction(); $submit = DB::update("UPDATE charge\n INNER JOIN comments ON charge.students_studentNo = comments.students_studentNo\n INNER JOIN cleared_at ON charge.students_studentNo = cleared_at.students_studentNo\n INNER JOIN cleared_by ON charge.students_studentNo = cleared_by.students_studentNo\n SET\n charge.cafeteria_value = '{$value}',\n charge.queueFlag = charge.queueFlag + 1,\n comments.cafeteria = '{$comment}',\n cleared_at.cafeteria_cleared_at = '{$clearedAt}',\n cleared_by.cafeteria_cleared_by = '{$clearedBy}'\n\n WHERE charge.students_studentNo = '{$student}'\n AND comments.students_studentNo = '{$student}'\n AND cleared_at.students_studentNo = '{$student}'\n AND cleared_by.students_studentNo='{$student}' "); if ($submit) { DB::commit(); } else { DB::rollBack(); } // $admin = DB::table('departments') // ->join('administrators','departments.administrator','=','administrators.admin_id') // ->select('administrators.email')->where('departments.department_name','=','Library') // ->pluck('email'); //Send Mail // Mail::send('mails.clear', ['student' => $student ], function($message) use($admin){ // $message->to($admin)->from('*****@*****.**', 'Strathmore University')->subject('Clearance'); // }); return redirect('/cafeteria'); }
function bannerDuzenleKaydet($duzenle) { $form = input::all(); // $kural = array('ad'=>'required','yol'=>'required','genislik'=>'required','yukseklik'=>'required','url'=>'required','durum'=>'required'); // $dogrulama = \Validator::Make($form,$kural); // if($dogrulama->fails()) { // // gönderilen verilerde hata var // return Redirect::to('admin/bannerDuzenle/'. $duzenle)->withErrors($dogrulama)->withInput(); // }else{ $dosya = Input::file('dosya'); $uzanti = $dosya->getClientOriginalExtension(); $dosyaAdi = date('YmdHis') . "_b." . $uzanti; $path = base_path('bannerResimler/' . $dosyaAdi); $imagePath = 'bannerResimler/' . $dosyaAdi; Image::make($dosya->getRealPath())->save($path); $sorgu = "UPDATE banner SET ad=?,yol=?, genislik=?, yukseklik=?, url=?, durum=? WHERE id=?"; $islem = DB::update($sorgu, array($form["ad"], $dosyaAdi, $form["genislik"], $form["yukseklik"], $form["url"], $form["durum"], $duzenle)); if ($islem) { $mesaj = "basarili"; return Redirect::to("admin/bannerListele")->with("mesaj", $mesaj); } else { $mesaj = "başarısız"; return Redirect::to("admin/bannerListele")->with("mesaj", $mesaj); } }
public function setStatus(Request $request) { $input = $request->all(); $workId = $input['workId']; $status = $input['status']; $affected = DB::update('UPDATE work_status SET STATUS = ? WHERE work_id = ?', [$status, $workId]); }
static function approve($id, $pass) { $entry = DB::select("SELECT password FROM Entries WHERE rowid=?", [$id]); if (Hash::check($pass, $entry[0]->password)) { return DB::update("UPDATE Entries SET is_approved=1, password=? WHERE rowid=?", [Hash::make($pass), $id]); } return 0; }
/** * Завершает текущий тест * @param $levelId * @return array */ public function finishTest($levelId) { $testId = $this->currentTestId($levelId); $query = 'UPDATE tests SET is_passed = TRUE, pass_datetime = now(), pass_duration = (SELECT EXTRACT(MINUTE FROM (now() - start_datetime))) WHERE id = ' . $testId . ';'; DB::update(DB::raw($query)); ProfileController::updatePoints($testId); return ['is_finished' => true]; }
public function show() { if ($this->record->owner_id == Auth::User()->id && empty($this->record->read_by_owner)) { DB::update('update leads set read_by_owner=1 where id="' . $this->record->id . '"'); } $activityList = $this->relatedActivityList(); return View('lead/lead-view', ['record' => $this->record, 'activityList' => $activityList, 'editPath' => 'lead']); }
static function update($game) { DB::update('UPDATE Games SET name=:name, num_players=:num_players, nickname_field=:nickname_field, multicampus=:multicampus WHERE rowid=:rowid', $game); // DB::delete('DELETE FROM Fields WHERE id_game=:rowid', $game); // if (!empty($game->extra_fields)) { // this.insertFields($game->rowid, $game->extra_fields); // } return 1; }
public static function setCursillosEsRespuesta($cursillosIds = array()) { $recordsCount = 0; DB::transaction(function () use(&$recordsCount, $cursillosIds) { $ids = implode(",", $cursillosIds); $recordsCount = DB::update("update cursillos set esRespuesta=true where (esRespuesta = false and activo = true and id in ({$ids}))"); }); return $recordsCount; }
public function emailOnlineNotify($data) { $to = explode(',', Setting::get('email_on_to')); Mail::raw(Setting::get('email_on_message'), function ($message) use($to) { $message->from(Setting::get('email_from'), 'Pulse'); $message->to($to); $message->subject(Setting::get('email_on_subject')); }); DB::update("UPDATE statuses SET email_on_notified = 1 WHERE id = '" . $data['id'] . "'"); }
public function created(UpdatedByCache $model) { $caches = $model->updatedByCaches(); $updatedBy = $model->userId; foreach ($caches as $cache) { $table = (new $cache())->getTable(); $field = $this->getField($cache); DB::update("UPDATE {$table} SET updated_by = {$updatedBy} WHERE id = {$model->{$field}}"); } }
function guncelle() { $gelenler = Input::all(); //$kullanici = Session::all(); $kulId = Session::get('id'); //$kullanici["id"]; //$kulId2 = Cookie::get('user'); //$kid= $kulId2['id']; $data = DB::update("update admin set adi=?, soyadi=?, mail=? WHERE id=?", array($gelenler['adi'], $gelenler['soyadi'], $gelenler['mail'], $kulId)); $data = DB::select('select * from admin WHERE id=?', array('1')); return view('admin/adminDuzenle', array('data' => $data)); }
/** * Rebuilds the cache for the records in question. * * @param array $config * @param Model $model * @param $command * @param null $aggregateField * @return mixed */ public function rebuildCacheRecord(array $config, Model $model, $command, $aggregateField = null) { $config = $this->processConfig($config); $modelTable = $this->getModelTable($model); if (is_null($aggregateField)) { $aggregateField = $config['foreignKey']; } else { $aggregateField = snake_case($aggregateField); } $sql = "UPDATE `{$config['table']}` INNER JOIN (" . "SELECT `{$config['foreignKey']}`, {$command}(`{$aggregateField}`) AS aggregate FROM `{$modelTable}` GROUP BY `{$config['foreignKey']}`) a " . "ON (a.`{$config['foreignKey']}` = `{$config['table']}`.`{$config['key']}`" . ") SET `{$config['field']}` = aggregate"; return DB::update($sql); }
public function vtDuzenle() { $gelen = Input::all(); $id = $gelen["id"]; $mail = $gelen["mail"]; $adi = $gelen["adi"]; $soyadi = $gelen["soyadi"]; $durum = DB::update("update kullanicilar set mail = ?, adi = ?, soyadi = ? WHERE id = ?", array($mail, $adi, $soyadi, $id)); if ($durum) { //return view('uyeler'); return Redirect::to("uyeler"); } }
protected function update(array $config, $operation, $foreignKey) { if (is_null($foreignKey)) { return; } $table = $this->getTable($config['model']); // the following is required for camel-cased models, in case users are defining their attributes as camelCase // $field = snake_case($config['countField']); // $key = snake_case($config['key']); // $foreignKey = snake_case($foreignKey); $sql = "UPDATE `{$table}` SET `{$field}` = `{$field}` {$operation} 1 WHERE `{$key}` = {$foreignKey}"; return DB::update($sql); }
public function clear(Request $request) { $post = $request->all(); $comment = $post['comment']; $value = $post['amount']; $student = $post['regNo']; $submit = DB::update("UPDATE charge INNER JOIN comments ON charge.students_studentNo = comments.students_studentNo SET comments.cafeteria = '{$comment}', charge.cafeteria_value = '{$value}', charge.queueFlag = '2' WHERE charge.students_studentNo = '{$student}' AND comments.students_studentNo = '{$student}' "); //Send Mail $emails = ['*****@*****.**', '*****@*****.**', '*****@*****.**']; Mail::send('mails.clear', ['student' => $student], function ($message) use($emails) { $message->to($emails)->from('*****@*****.**', 'strath')->subject('Clearance'); }); return redirect('/cafeteria'); }
public function clear(Request $request) { $post = $request->all(); $comment = $post['comment']; $value = $post['amount']; $student = $post['regNo']; $submit = DB::update("UPDATE charge INNER JOIN comments ON charge.students_studentNo = comments.students_studentNo SET comments.cafeteria = '{$comment}', charge.cafeteria_value = '{$value}', charge.queueFlag = '2' WHERE charge.students_studentNo = '{$student}' AND comments.students_studentNo = '{$student}' "); $admin = DB::table('schools')->join('administrators', 'schools.administrator', '=', 'administrators.admin_id')->select('administrators.email')->where('schools.department_name', '=', 'Library')->pluck('email'); //Send Mail Mail::send('mails.clear', ['student' => $student], function ($message) use($admin) { $message->to($admin)->from('*****@*****.**', 'Strathmore University')->subject('Clearance'); }); return redirect('/cafeteria'); }
public function EditProfile(Request $request) { // var_dump($request->input('phone')); // // var_dump($request->input('address')); // var_dump($request->input('email')); $sql = "UPDATE TBL_USER SET PHONE='" . $request->input('phone') . "', ADDRESS='" . $request->input('address') . "' , EMAIL='" . $request->input('email') . "' WHERE EMP_ID='" . get_userID() . "'"; $ret = DB::update(DB::raw($sql)); $val = array("emp_id" => get_userID(), "PHONE" => $request->input('phone'), "ADDRESS" => $request->input('address'), "EMAIL" => $request->input('email')); if ($ret) { Logprocess(5, $val); } return redirect()->to('/editprofile')->with('updateok', true); }
/** * Formla gelen düzenle işlemi. */ public function duzenleForm($kul_id) { $form = Input::all(); if (!empty($form["kulAdi"]) and !empty($form["kulSoyadi"]) and !empty($form["kulMail"]) and !empty($form["kulSifre"]) and !empty($form["kulGizli"])) { $q = "UPDATE kullanicilar SET adi = ?, soyadi = ?, mail = ?, sifre = ?, gizli_soru = ? WHERE id = ?"; $islem = DB::update($q, array($form["kulAdi"], $form["kulSoyadi"], $form["kulMail"], $form["kulSifre"], $form["kulGizli"], $kul_id)); if ($islem) { $mesaj = "basarili"; } else { $mesaj = "basarisiz"; } } // Mesaj session'a yazılıyor redirect yapıldığı için. return redirect("kullanicilar/liste")->with("mesaj", $mesaj); }
public function storeQuiz(Request $request, $lecture_id, $subject_id, $assignment_id) { $point = 0; $answers = Input::get('answers'); $request->user()->assignments()->attach(array($assignment_id)); $request->user()->answers()->attach($answers); foreach ($answers as $answer_id) { $answer = Answer::find($answer_id); if ($answer->correct) { $point++; } } DB::update('UPDATE (users_assignments) SET point=? WHERE user_id=? AND assignment_id=?', [$point, $request->user()->id, $assignment_id]); return redirect('/lectures/' . $lecture_id . '/assignments'); }
public function add(Request $request) { $validator = Validator::make($request->all(), ['postcode' => 'required|integer', 'country' => 'required', 'address' => 'required']); if ($validator->fails()) { return redirect('/creator')->withInput()->withErrors($validator); } $id = Auth::user()->id; $creator = new Creator(); $creator->postcode = $request->postcode; $creator->country = $request->country; $creator->home_address = $request->address; $creator->user_id = $id; $creator->save(); DB::update('update users set isCreator = 1 where id = ?', [$id]); return redirect('/new'); }
public function soruDuzenle($duzenleId) { $gelenler = Input::All(); $kural = array('sorunuz' => 'required'); $dogrulama = \Validator::Make($gelenler, $kural); if ($dogrulama->fails()) { $bilgi["hata"] = "Lütfen sorunuz alanını boş bırakmayınız!"; $duzenle = DB::select('select * from anketdetay'); return view('admin/anketSoruDuzenle', array('bilgi' => $bilgi), array('data' => $duzenle)); } else { $bilgi["bilgi"] = "Kayıt başarılı."; $bilgi["kid"] = $gelenler['soru']; $data = DB::update('update anketdetay set sorunuz=? WHERE id=?', array($gelenler["sorunuz"], $bilgi["kid"])); $duzenle = DB::select('select * from anketdetay'); return view('admin/anketSoruDuzenle', array('bilgi' => $bilgi), array('data' => $duzenle)); } }
public function rebuildCacheRecord(array $config, Model $model, $command, $aggregateField = null) { $config = $this->processConfig($config); $modelTable = $this->getModelTable($model); $modelMorphClass = $model->getMorphClass(); if (is_null($aggregateField)) { $aggregateField = $config['foreignKey']; } else { $aggregateField = snake_case($aggregateField); } if (!$config['polymorphic']) { $sql = "UPDATE `{$config['table']}` INNER JOIN (" . "SELECT `{$config['foreignKey']}`, {$command}(`{$aggregateField}`) AS aggregate FROM `{$modelTable}` GROUP BY `{$config['foreignKey']}`) a " . "ON (a.`{$config['foreignKey']}` = `{$config['table']}`.`{$config['key']}`" . ") SET `{$config['field']}` = aggregate"; } else { $sql = "UPDATE `{$config['table']}` INNER JOIN (" . "SELECT `{$config['foreignKey']}`, COUNT(`{$config['foreignKey']}`) AS aggregate FROM `{$config['name']}s` WHERE `{$config['name']}_type` = '{$modelMorphClass}' GROUP BY `{$config['foreignKey']}`)" . "a ON(a . `{$config['foreignKey']}` = `{$config['table']}` . `id`)" . "SET `{$config['field']}` = aggregate"; } return DB::update($sql); }
public function haberDuzenle($haber_id) { function trcharacter($s) { $tr = array('ş', 'Ş', 'ı', 'İ', 'ğ', 'Ğ', 'ü', 'Ü', 'ö', 'Ö', 'ç', 'Ç'); $en = array('s', 's', 'i', 'i', 'g', 'g', 'u', 'u', 'o', 'o', 'c', 'c'); $s = str_replace($tr, $en, $s); $s = strtolower($s); $s = preg_replace('/&amp;amp;amp;amp;amp;amp;amp;.+?;/', '-', $s); $s = preg_replace('/[^%a-z0-9 _-]/', '-', $s); $s = preg_replace('/\\s+/', '-', $s); $s = preg_replace('|-+|', '-', $s); $s = str_replace("--", "-", $s); $s = trim($s, '-'); return $s; } $data = Input::all(); if (Input::hasFile('dosya')) { $eskiResim = DB::select("select resimYolu from haberler where id = ?", array($haber_id)); echo "Resim Yolu " . $eskiResim[0]->resimYolu; $eskiResimFileName = $eskiResim[0]->resimYolu; File::delete("haberResimler/" . $eskiResimFileName); $file = Input::file('dosya'); $destinationPath = 'haberResimler/'; $extension = $file->getClientOriginalExtension(); $filename = trcharacter(substr($file->getClientOriginalName(), 0, -5)) . "_" . str_random(12) . ".{$extension}"; $upload_success = $file->move($destinationPath, $filename); DB::insert("update haberler set resimYolu = ? where id = ?", array($filename, $haber_id)); } $form = Input::all(); $kural = array('haber_baslik' => 'required', 'detay' => 'required', 'durum' => 'required'); $dogrulama = \Validator::Make($form, $kural); if ($dogrulama->fails()) { // Gönderilen Verilerde Hata Varsa ... return \Redirect::to('admin/haberDuzenle/' . $haber_id)->withErrors($dogrulama)->withInput(); } $data = DB::update('update haberler set haber_baslik = ?, detay = ?, durum = ? WHERE id = ?', array($form["haber_baslik"], $form["detay"], $form["durum"], $haber_id)); if ($data) { $mesaj = "basarili"; return Redirect::to("admin/haberler")->with("mesaj", $mesaj); } else { $mesaj = "basarisiz"; return Redirect::to("admin/haberler")->with("mesaj", $mesaj); } }