DB::raw() Query in Eloquent ->get();

By -
ParkInfo::leftJoin('park_block_setup as block','block.park_id','=','park_info.id')
    ->where('park_info.is_archive', 0)
    ->groupBy('park_info.id')
    ->orderBy('park_info.park_name', 'asc')
    ->get([
        'park_info.*',
        DB::raw('ifnull(sum(block.has_land),0) has_land'),
        DB::raw('ifnull(sum(block.has_space),0) has_space')
    ]);

Comments

Post a Comment

Popular posts from this blog

WP register_post_type() with custom CMB2 meta box

By -
functions.php register_post_type('portfolio',[ 'labels'=>[ 'name'=> 'Portfolio', 'add_new_item'=>'Add new portfolio', 'view_item'=>'View portfolio', ], 'public'=>true, 'menu_icon'=>'dashicons-edit', 'menu_position'=>1, 'supports'=> ['title','editor','thumbnail'] ]); custom.php add_action('cmb2_admin_init','custom_metaboxes'); function custom_metaboxes(){ $portfolioMetaBox = new_cmb2_box([ 'object_types'=>['portfolio'], 'id'=>'portfolio-additional-fields', 'title'=>'Portfolio Additional Fields' ]); $portfolioMetaBox->add_field([ 'id'=>'portfolio_designation', 'name'=>'Portfoilo Designation', 'type'=>'text' ]); $portfolioMetaBox->add_field([ 
Read more

Git post receive setup at server for git push to the production from local machine

By -
IN SERVER cd www mkdir repo cd repo mkdir app.website.git cd app.website.git git init –bare cd hooks touch post-receive chmod R 775 post-receive put the following line in post-receive file git --work-tree=/var/www/html/app.website.com --git-dir=/var/www/repo/app.website.git checkout master -f cd /var/www/html/app.website.com nano /etc/hosts 127.0.1.1 app.website.com cd /etc /apach2 /site-available cp 000-deault.conf app.website.com.conf LOCALLY git remote -v git remote add prod-website ssh://root@192.168.0.1:/var/www/repo/app.website.git
Read more