軟體工程
Laravel 5.5 ORM 的 ( cond1 and cond2) OR (cond3 and cond4) 寫法
假設兩個 Model : A, B, 一對一關係，例如 A has B, B belongs A，當要撈出 A 中有 B 且符合 在 B 的篩選欄位條件。A 是 Post 貼文, B 是 Comment 評論，A 和 B 的更新日期時間欄位都是
read more
假設兩個 Model : A, B, 一對一關係，例如 A has B, B belongs A，當要撈出 A 中有 B 且符合 在 B 的篩選欄位條件。A 是 Post 貼文, B 是 Comment 評論，A 和 B 的更新日期時間欄位都是
read moreVersion: Laravel 5.5 Model: Post, Comment Post’s columns: id, title, content, created_at, updated_at Comment’s columns: id, post_id, content, c_date, c_time, u_date, u_time Relation: A post has many comments and a comment belongs to a post. The following shows how to get posts, which had been comments in recent 24 hours. use CarbonCarbon; // use package Post::whereHas('comments', function ($query) { $query->whereRaw('(u_date = ? AND u_time >= ?) OR (u_date =? AND
read moreWe can get session value or data of a loginned user at AppServiceProvider. The following we will show how to get, share values of session and loginned user to all views. ========= Code: namespace App\Yourapp\Younamespace; use Illuminate\Support\ServiceProvider; use Illuminate\Support\Facades\Session; use Illuminate\Support\View; use App; class AppServiceProvider extends ServiceProvider{ public function boot() { $auth = $this->app['auth']; // get Laravel's Auth facades view()->composer('*', function($view) use (&$auth) { // this function coding style is
read more
Howard Lee, Frontend-engineer with Angular 7+, Typescript, ReactJS, VueJS. Flutter, Dart, PHP, Ruby, JavaScript, HTML, SASS, CSS, Postgres, MySQL, Web Developer. Have a certificate of AWS Solution Architect Associate with verify number: 8FYNL55LCEEQ10W5. You can verify at AWS Certificate site or Credly site Tech lead role Lead 4 colleagues to build products and infrastructure Coordinate schedule of delivering products Senior web frontend developer role Products Form-filling, form-sharing, file-management, repair-managemnt and project-management for construction industry at Suiqui IoT management and EC platform for Liquid Petroleum Gas(LPG) at Wave-In Comm.
Know More