/**
* Get the validation rules that apply to the request.
*
* @return array
*/
public function rules()
{
$rules = [];
$type = $this->get('type');
$table = Table::where('name', $type)->firstOrFail();
foreach ($table->fields as $field) {
$rules[$field['name']] = 'required';
}
return $rules;
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(StoreContentRequest $request)
{
$table = Table::where('name', $this->contentType)->first();
$attributes = [];
foreach ($table->fields as $field) {
$attributes[$field['name']] = $request->get($field['name']);
}
DB::table($this->contentType)->insert($attributes);
return redirect("/content?type={$this->contentType}");
}
/**
* Saves matches into database
*
*
*/
public function storeGamesForm(SaveGamesRequest $request)
{
$input = $request->except('_token');
$count = count($input['match_id']);
for ($i = 0; $i < $count; $i++) {
if ($input['home_goals'][$i] != '') {
DB::table('matches')->where('id', $input['match_id'][$i])->update(['home_goals' => $input['home_goals'][$i], 'away_goals' => $input['away_goals'][$i]]);
}
}
// Update Tables .tables
for ($i = 0; $i < $count; $i++) {
if ($input['home_goals'][$i] != '') {
// Update der Heimmannschaft
$homePoints = 0;
if ($input['home_goals'][$i] > $input['away_goals'][$i]) {
$homePoints = 3;
} elseif ($input['home_goals'][$i] === $input['away_goals'][$i]) {
$homePoints = 1;
}
//TODO: Check if club_id exists in table
if (Table::where('club_id', $input['home_id'][$i])->first() != NULL) {
Table::where('club_id', $input['home_id'][$i])->update(['goals' => DB::raw('goals +' . $input['home_goals'][$i]), 'goals_against' => DB::raw('goals_against +' . $input["away_goals"][$i]), 'matchday_count' => DB::raw('matchday_count + 1'), 'points' => DB::raw('points + ' . $homePoints)]);
} else {
Table::insert(['club_id' => $input['home_id'][$i], 'goals' => DB::raw('goals +' . $input['home_goals'][$i]), 'goals_against' => DB::raw('goals_against +' . $input["away_goals"][$i]), 'matchday_count' => DB::raw('matchday_count + 1'), 'points' => DB::raw('points + ' . $homePoints), 'league_id' => $input['league'], 'season' => $input['season']]);
}
//Update der Auswärtsmannschaft
$awayPoints = 0;
if ($input['home_goals'][$i] < $input['away_goals'][$i]) {
$awayPoints = 3;
} elseif ($input['home_goals'][$i] == $input['away_goals'][$i]) {
$awayPoints = 1;
}
if (Table::where('club_id', $input['away_id'][$i])->first() != NULL) {
Table::where('club_id', $input['away_id'][$i])->update(['goals' => DB::raw('goals + ' . $input["away_goals"][$i]), 'goals_against' => DB::raw('goals_against + ' . $input["home_goals"][$i]), 'matchday_count' => DB::raw('matchday_count + 1'), 'points' => DB::raw('points + ' . $awayPoints)]);
} else {
Table::insert(['club_id' => $input['away_id'][$i], 'goals' => DB::raw('goals + ' . $input["away_goals"][$i]), 'goals_against' => DB::raw('goals_against + ' . $input["home_goals"][$i]), 'matchday_count' => DB::raw('matchday_count + 1'), 'points' => DB::raw('points + ' . $awayPoints), 'league_id' => $input['league'], 'season' => $input['season']]);
}
}
}
return redirect('spiele');
}
public function finishWork($table)
{
$item = Table::find($table);
$item->active = 0;
$item->save();
$ques = Que::where('table_id', $table)->get();
$guests = [];
foreach ($ques as $que) {
$item->current_que = $item->current_que - 1;
$currentTable = Table::where('branche_id', $item->branche_id)->where('active', 1)->limit(1)->orderBy('current_que')->orderBy('id')->first();
$currentTable->current_que = $currentTable->current_que + 1;
$currentTable->guests_count = $currentTable->guests_count + 1;
$currentTable->save();
$que->table_id = $currentTable->id;
$que->save();
}
return redirect()->back();
}
public function search()
{
$name = Request::input('name');
return View('users.search')->with('tables', Table::where('name', 'like', '%' . $name . '%')->paginate(7));
}
public function list_for_devis($devis_id)
{
$devis = Devis::find($devis_id);
$table = Table::where('devis_id', $devis_id)->orderBy('updated_at', 'desc')->paginate(50);
return view('admin.table.index', compact('devis', 'table'));
}
public function constructRouterVue2(Table $from_Table, $chaine_cumul = '', $chaine_edit = '', $chaine_list = '', $loop = 0)
{
//var_dump($loop);
$chaine_cumul .= $from_Table->name . '/';
$pieces = explode('/', $chaine_cumul);
end($pieces);
$avantDernier = prev($pieces);
$table = Table::where('name', $avantDernier)->first();
$id = ':id_' . $table->variable;
echo "<h2>__________________________________________________________________________________________________________________________________________________________</h2>";
var_dump($pieces);
$chaine_edit = '';
foreach ($pieces as $piece) {
$table = Table::where('name', $piece)->first();
if ($table) {
$chaine_edit .= $piece . '/:id_' . $table->variable . '/';
}
}
$chaine_list .= rtrim($chaine_edit, '/:id_' . $from_Table->variable . '/');
//put thre keys
// $chaine_edit.=$this->primary().'/';
// $chaine_cumul.=$this->name.'/';
foreach ($from_Table->hasHasManyRelationList() as $relation) {
// var_dump($relation);
$toTable = Table::find($relation['to_model_id']);
//var_dump(rtrim($chaine_edit, '/'));
//var_dump(rtrim($chaine_list, '/'));
$this->constructRouterVue2($toTable, $chaine_cumul, $chaine_edit, $chaine_list, $loop++);
}
//var_dump(rtrim($chaine_edit, '/'));
$chaine_list = rtrim($chaine_list, '/');
$chaine_edit = rtrim($chaine_edit, '/');
var_dump('------------chaine_edit');
var_dump($chaine_edit);
/*
$toComponentTable = strrchr($chaine_list, '/');
if (!$toComponentTable) {
echo ">>";
$toComponentTable=$chaine_list;
}*/
$toComponentTable = $avantDernier;
echo "--->";
var_dump($toComponentTable);
echo "<---";
echo "<h2>EDITION</h2>";
/*
** EDITION
*/
$table = Table::where('name', $toComponentTable)->first();
if ($table) {
$edit = new CreateEditComponent($this->devis, $table);
$path = $edit->getPath();
} else {
echo "la table {$toComponentTable} non trouvee !!";
$toComponentTable = $chaine_list;
$table = Table::where('name', $toComponentTable)->first();
$path = '';
if ($table) {
$list = new CreateEditComponent($this->devis, $table);
$path = $list->getPath();
}
}
$edition = $this->RouterVue[] = ['type' => 'edit', 'route' => $chaine_edit, 'to_component' => $toComponentTable, 'path' => $path];
//var_dump($this->RouterVue);
var_dump($edition);
/*
** list
*/
echo "<h2>LIST</h2>";
//var_dump($chaine_list);
$route = '';
var_dump('edition[route]');
var_dump($edition['route']);
//$route = strrchr($edition['route'], '/')
// $route=substr($edition['route'], 0, strpos($edition['route'], '/'));//remove everything after /
$route = substr($edition['route'], 0, strrpos($edition['route'], '/'));
//remove everything after /
// var_dump('route for list');
// var_dump($route);
$table = Table::where('name', $toComponentTable)->first();
if ($table) {
$edit = new CreateListComponent($this->devis, $table);
$path = $edit->getPath();
} else {
$toComponentTable = $chaine_list;
$table = Table::where('name', $toComponentTable)->first();
$path;
if ($table) {
$list = new CreateListComponent($this->devis, $table);
$path = $list->getPath();
}
}
$list = $this->RouterVue[] = ['type' => 'list', 'route' => $route, 'to_component' => $toComponentTable, 'path' => $path];
var_dump($list);
/*
** create
*/
echo "<h2>FORM</h2>";
$route = $list['route'] . '/create';
//remove everything after /
$table = Table::where('name', $toComponentTable)->first();
if ($table) {
$edit = new CreateFormComponent($this->devis, $table);
$path = $edit->getPath();
} else {
$toComponentTable = $chaine_list;
$table = Table::where('name', $toComponentTable)->first();
$path = '';
if ($table) {
$list = new CreateFormComponent($this->devis, $table);
$path = $list->getPath();
}
}
$form = $this->RouterVue[] = ['type' => 'create', 'route' => $route, 'to_component' => $toComponentTable, 'path' => $path];
var_dump($form);
/*
** Ajout des component specifiques
if ($this->getSpecialVueComponentList($this->table)){
foreach ($this->getSpecialVueComponentList($this->table) as $specialView) {
$componentName = $this->table->vueComponentName('', $specialView);
//$path = $this->table->vueComponentRelativePathTo($this->table, $specialView);
$tag = '<'.$this->table->VueTag('',$specialView ).' :'.$this->table->variable.'="object"></'.$this->table->VueTag('',$specialView ).'>';
//var_dump($editList);
//si la fin du liste == model concerné dans le specialcompo
//dd($edition['to_component'], $this->table->name);
// $file = strrchr($path, '/');
// $file = trim($file, '/');
// $file = trim($file, '.php');
//on les execute pour trouver les namespaces
$vueClass = '\Organit\bootstrapping\Vue\MiddlesepcialComponentViews\\'.$this->devis->app_name.'\\'.$specialView;
// dd(
// (new $vueClass($this->devis,$table))->CoreSpecialCompo()->model()
// ,
// (new \Organit\bootstrapping\Vue\MiddlesepcialComponentViews\Middle\BankAccount($this->devis,$table))->CoreSpecialCompo()->model()
// );
//recuperer la liste des table qui on des speciaux compo
$list_qq=[];
foreach ($this->devis->tables as $_table ) {
if ($_table == 'vehicles') {
dd($this->getSpecialVueComponentList($_table));
# code...
}
$list_qq[] = $this->getSpecialVueComponentList($_table);
}
//dd($list_qq);
var_dump('********');
var_dump($vueClass);
$model = (new $vueClass($this->devis,$this->table))->CoreSpecialCompo()->model();
$related_table = Table::where('model', $model)->first();
if ($related_table) {
//if ($edition['to_component'] == $related_table->name) {
$this->RouterVue[]=[
'type' => 'secial',
'route' => $edition['route'].'/get_'.$componentName,
'to_component' => $componentName,
'path' => $edition['path'].'/'.$componentName,
'tag' => $tag
];
//}
# code...
}
}
}
*/
// var_dump(rtrim($chaine_cumul, '/'));
// if (isset($toTable)) {
//Table::constructRouterVue($table, $chaine_cumul, $chaine_edit, $chaine_list, $loop++);
# code...
// }
}
