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