programming:phplaravel

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
programming:phplaravel [2022/09/10 14:08] – [php.laravel laravel] adminprogramming:phplaravel [2022/09/19 16:57] (current) – [laravel.Development] admin
Line 1: Line 1:
 ===== php.laravel laravel===== ===== php.laravel laravel=====
-<WRAP left  tip 60%>+  * good info start here  https://www.honeybadger.io/blog/laravel-queues-deep-dive/ 
 +  * good site - model info https://freek.dev/2332-getting-information-about-all-the-models-in-your-laravel-app 
 +<WRAP left  tip 80%>
  php Artisan tinker example user:  php Artisan tinker example user:
 <code PHP> <code PHP>
Line 7: Line 9:
 $methods = (new ReflectionClass('\App\Models\User'))->getMethods(); $methods = (new ReflectionClass('\App\Models\User'))->getMethods();
  
-$u=User::->find(5);+$u=User::find(5);
  
 show $u # show source show $u # show source
Line 23: Line 25:
  
 App\Models\Role::create(['id' => 2,   'code' => "archivist",'name' => "Архивист"]); App\Models\Role::create(['id' => 2,   'code' => "archivist",'name' => "Архивист"]);
 +
 +
 +Storage::disk('tinker')->put('users_roles.json', json_encode($data_u, JSON_PRETTY_PRINT + JSON_UNESCAPED_SLASHES + JSON_UNESCAPED_UNICODE));
  
 # execute code in tinker from file # execute code in tinker from file
 include('/var/www/laravel/storage/app/tinker/update_users.php') include('/var/www/laravel/storage/app/tinker/update_users.php')
 +
 +####### - обновление роли 
 +#найти пользователя 
 +User::with(['roles:id,name'])->where('id','305')->get(['id','name']);
 +User::with('digitalCertificates','roles')->where('name','LIKE', '%Ворончихин%')->first()
 +User::with('Roles')->where('name','LIKE', '%Шестакова%')->get(['id','name'])
 +User::with('Roles:id,name')->where('name','LIKE', '%Долматова%')->first(['id','name'])
 + 
 + 
 +#Обновление
 +User::where('name','LIKE', '%тампель%')->first()->roles()->detach(Role::where(['code' => 'user'])->first());
 +User::where('name','LIKE', '%Ворончихин%')->first()->roles()->syncWithoutDetaching(Role::where(['code' => 'user'])->first());
 +User::find(450)->roles()->syncWithoutDetaching(Role::where(['code' => 'user'])->first());
 + 
 + 
 +function addUser($uid) {
 +  return User::find($uid)->roles()->syncWithoutDetaching(Role::where(['code' => 'user'])->first());
 +}
 </code> </code>
 ++++ Get All Models| ++++ Get All Models|
Line 56: Line 79:
     };     };
 getAllModels(); getAllModels();
 +
 +</code>
 +++++
 +
 +++++ SQL create php tinker |
 +1. format sql
 +<code SQL>
 +-- sql for format commands tinker
 +with q as
 +(select id,ad_department,ad_subdepartment,ad_position
 +from public.ad_check
 +where 1=1
 +  and  ad_status
 +  and  ( length(ad_department)>2 or length(ad_subdepartment)>2 or length(ad_position)>2)
 +-- and id in (72, 76, 114, 118, 186, 187, 201, 213, 221, 229, 242, 247, 280, 284, 287, 315, 319)
 +--and ARRAY_LENGTH(REGEXP_SPLIT_TO_ARRAY(name, '\s'), 1)>3
 +)
 +select id, format('updateUser($a,id: %s, update: [%s])'
 +                          ,id
 +                          ,array_to_string(
 +                            array[ case when length(ad_department)>2 then '"department" => "'||ad_department||'",' else '' end
 +                                  ,case when length(ad_subdepartment)>2 then '"subdepartment" => "'||ad_subdepartment||'",' else '' end
 +                                  ,case when length(ad_position)>2 then '"position" => "'||ad_position||'",' else '' end
 +                                      ,'"place_of_work_filled"=>true'
 +                                   ]
 +                     ,' ')
 +    )
 +from q;
 +</code>
 +2.format php for tinker
 +<code PHP>
 +<?php
 +# execute.php
 +function updateUser(array &$a ,int $id, array $update = ["place_of_work_filled"=>true])
 +{
 +   $a=array_merge_recursive($a,array("id_".$id=>array(
 +                                     User::where("id",$id)->first(["id","name","department"
 +                                                                  ,"subdepartment","position"
 +                                                                  ,"place_of_work_filled"])
 +                                    ,User::where("id",$id)->update($update)
 +                                    ,User::where("id",$id)->first(["id","name","department"
 +                                                                  ,"subdepartment","position"
 +                                                                  ,"place_of_work_filled"])
 +                                    )
 +                        )
 +            );
 +}
 +
 +
 +$data=[];
 +
 +updateUser($data,id: 4, update: ["department" => "Управление информационных технологий"
 +                                ,"position" => "Начальник управления"
 +                                , "place_of_work_filled"=>true]);
 +updateUser($data,id: 5, update: ["department" => "Управление информационных технологий"\
 +                                ,"position" => "Начальник управления"
 +                                , "place_of_work_filled"=>true]);
 +...
 +#save result
 +Storage::disk('tinker')->put('users20220910.json', json_encode($data, JSON_PRETTY_PRINT + JSON_UNESCAPED_SLASHES + JSON_UNESCAPED_UNICODE));
 +</code>
 +
 +3. execute tinker 
 +<code BASH>
 +>>> include('/var/www/laravel/storage/app/tinker/update_users.php')
 +</code>
 +
 +
 +4. check without role
 +<code PHP>
 +
 +
 +$data_u=[];
 +
 +$results=User::with(['roles:id,name'])->get(['id','name']);
 +foreach($results as $k => $v) {
 + if ($v->roles->isEmpty()) {
 +    array_push($data_u,("${v["id"]}  ${v["name"]}  -> ".$v->roles->pluck('name')->implode(',')));
 +  }
 +};
 +
 +Storage::disk('tinker')->put('users_roles.json', json_encode($data_u, JSON_PRETTY_PRINT + JSON_UNESCAPED_SLASHES + JSON_UNESCAPED_UNICODE));
 +
 +
  
 </code> </code>
Line 67: Line 174:
 ==== laravel.Development ==== ==== laravel.Development ====
   * Laravel's Dependency Injection Container in Depth https://gist.github.com/davejamesmiller/bd857d9b0ac895df7604dd2e63b23afe   * Laravel's Dependency Injection Container in Depth https://gist.github.com/davejamesmiller/bd857d9b0ac895df7604dd2e63b23afe
 +  * laravel queues https://www.honeybadger.io/blog/laravel-queues-deep-dive/#introduction-to-jobs-queues-and-workers
   * laracast - namespace https://laracasts.com/lessons/namespacing-primer    * laracast - namespace https://laracasts.com/lessons/namespacing-primer 
   * laravel auth guard https://darkghosthunter.medium.com/laravel-making-your-own-passwordless-auth-guard-b7740c89adf8   * laravel auth guard https://darkghosthunter.medium.com/laravel-making-your-own-passwordless-auth-guard-b7740c89adf8
  • programming/phplaravel.1662818903.txt.gz
  • Last modified: 2022/09/10 14:08
  • by admin