public function postFormLayerInfoPopUpCr($id, $idx, $layern) { $fieldinfo = $this->getfieldInfos(); $medias = $this->getMedias(); $desc = \Input::get('display') == 'keyvalue' ? $this->getDesc() : \Input::get('description'); $rules = array('layername' => 'required'); $validator = Validator::make(\Input::all(), $rules); if ($validator->fails()) { // get the error messages from the validator $messages = $validator->messages(); // redirect our user back to the form with the errors from the validator return Redirect::to('layer')->withErrors($validator); } else { $check = Identify::where('layerid', '=', $idx)->where('layername', '=', $layern, 'AND')->first(); if ($check === null) { $identify = new Identify(); $identify->title = \Input::get('title'); $identify->display = \Input::get('display'); $identify->description = $desc; $identify->layername = \Input::get('layername'); $identify->layerid = \Input::get('layerid'); $identify->key_ = $fieldinfo; $identify->media = $medias; $identify->showattachments = \Input::get('showattachments'); $identify->save(); $msg = 'tambah'; } else { $identify = $check; $identify->title = \Input::get('title'); $identify->description = $desc; $identify->layername = \Input::get('layername'); $identify->layerid = \Input::get('layerid'); $identify->display = \Input::get('display'); $identify->key_ = $fieldinfo; $identify->media = $medias; $identify->showattachments = \Input::get('showattachments'); $identify->save(); $identify->touch(); $msg = 'edit'; } //return $medias; //return $msg." ".$idx." ".$desc; return redirect('layer'); } }
public function GetTableCanEdit() { $query = Identify::leftJoin('identify_table', function ($join) { $join->on('Identify.id_identify', '=', 'identify_table.id_identify'); })->get(['Identify.id_identify', 'Identify.title', 'Identify.layername', 'Identify.layerid', 'Identify.display', 'Identify.description', 'Identify.key_', 'Identify.media', 'Identify.showattachments', 'identify_table.tablename']); // ->where('identify.id_identify','=',5) /* ->first([ 'identify.id_identify', 'identify.layername', 'identify_table.tablename' ]);*/ return $query; }