コード例 #1
0
ファイル: User.php プロジェクト: bikedel/farmbook_admin
 public function getDatabaseName()
 {
     $data = Farmbook::where('id', '=', $this->farmbook)->first();
     if (is_null($data)) {
         $data = "No database";
     } else {
         $data = $data->name;
     }
     return $data;
 }
コード例 #2
0
 /**
  * Show the application dashboard.
  *
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request, $id)
 {
     // current timestamp
     $now = Carbon\Carbon::now('Africa/Cairo')->toDateTimeString();
     // get inpute
     $id = $request->input('id');
     $name = $request->input('name');
     $database = $request->input('database');
     $suburbs = $request->input('suburbs');
     //dd($suburbs);
     //$type     = $request->input('type');
     Farmbook::where('id', $id)->update(array('name' => $name, 'database' => $database, 'updated_at' => $now));
     $farmbook = Farmbook::where('id', '=', $id)->first();
     // store the deed suburbs
     $farmbook->suburbs()->sync($suburbs);
     //  dd("user controller Store ",$id,,$farmbooks);
     Session::flash('flash_message', 'Updated ' . $name . ' at ' . $now);
     Session::flash('flash_type', 'alert-success');
     return Redirect::back();
 }
コード例 #3
0
 public function createdatabase(Request $request)
 {
     $file = storage_path() . '/databases/dummy_database.sql';
     $file2 = storage_path() . '/databases/dummy_database.sql';
     // check if the file exists
     if (file_exists($file)) {
         $sqldump = file_get_contents($file);
     } else {
         $file = "not found";
         $message = 'missing dummy_database';
         Session::flash('flash_message', $message);
         Session::flash('flash_type', 'alert-danger');
         return Redirect::back()->with('flash_message', $message);
     }
     $database = $request->input('database');
     $type = $request->input('type');
     $database = $database . '_' . $type . '_farmbook2';
     //dd($database);
     $servername = config('database.connections.mysql.host');
     $username = config('database.connections.mysql.username');
     $password = config('database.connections.mysql.password');
     // dd('make database',$database);
     $dbname = 'tmp';
     // connect to tmp database
     $otf = new \App\Database\OTF(['database' => $dbname]);
     $db = DB::connection($dbname);
     $sql = "CREATE DATABASE " . $database;
     //set created to false
     $created = false;
     try {
         // created database successfully
         $db->getpdo()->exec($sql);
         $created = true;
     } catch (Exception $ex) {
         // dd( $ex->getMessage());
         // error creating database
         $message = $ex->getMessage();
     }
     // database created success
     if ($created == true) {
         $Farmbook = Farmbook::where('database', '=', $database);
         $normal_name = str_replace('_', ' ', $database);
         $normal_name = str_replace('farmbook2', ' ', $normal_name);
         if ($Farmbook->count() > 0) {
             $Farmbook = Farmbook::where('database', '=', $database)->update(['database' => $database]);
         } else {
             // add to farmbooks
             $Farmbook = new Farmbook();
             $Farmbook->name = $normal_name;
             $Farmbook->database = $database;
             $Farmbook->type = 0;
             $Farmbook->save();
         }
         // connect to the new database
         $otf = new \App\Database\OTF(['database' => $database]);
         $db = DB::connection($database);
         // creates tables with dummy
         $db->getpdo()->exec($sqldump);
         $message = $database . ' created successfully.';
         Session::flash('flash_message', $message);
         Session::flash('flash_type', 'alert-success');
     } else {
         Session::flash('flash_message', $message);
         Session::flash('flash_type', 'alert-danger');
     }
     return Redirect::back()->with('flash_message', $message);
 }