WP File Manager

Current Path: /home/itutorethiopia/public_html/app/Models/

Name	Action
..
Admincoupon.php	Edit
Advertisement.php	Edit
Api_droid.php	Edit
Bank.php	Edit
Banner.php	Edit
Blog.php	Edit
Blogadmin.php	Edit
Blogcategories.php	Edit
Blogcomment.php	Edit
Blogs.php	Edit
Categories.php	Edit
Ccavenue.php	Edit
Clientbanner.php	Edit
Core
Coupon.php	Edit
Course.php	Edit
CourseFiles.php	Edit
CourseImages.php	Edit
CourseSurvey.php	Edit
CourseTaken.php	Edit
CourseVideos.php	Edit
Course_25.php	Edit
Coursecomments.php	Edit
Courselanguage.php	Edit
Courselisting.php	Edit
Currency.php	Edit
Customcourserequest.php	Edit
Dashboard.php	Edit
Dashboard_25.php	Edit
Emailsettings.php	Edit
Featured.php	Edit
Forum.php	Edit
Forumcategory.php	Edit
Forumcomments.php	Edit
Instructor.php	Edit
Invoice.php	Edit
Membership.php	Edit
Message.php	Edit
Notifications.php	Edit
Notificationsettings.php	Edit
Questionanswer.php	Edit
Reportabuse.php	Edit
Search.php	Edit
Search_25.php	Edit
Sendmail.php	Edit
Sitecategories.php	Edit
Sitecategory.php	Edit
Sitesubcategory.php	Edit
Subscriber.php	Edit
Transaction.php	Edit
UserCredits.php	Edit
Users.php	Edit
Withdrawrequests.php	Edit
Youtube.php	Edit
bsetec
bsetec.php	Edit

Editing: Blogadmin.php

<?php
namespace App\Models;

use Illuminate\Auth\Authenticatable;
use Illuminate\Database\Eloquent\Model;
class Blogadmin extends bsetec  {
	
	protected $table = 'blogs';
	protected $primaryKey = 'blogID';

public function __construct() {
		parent::__construct();
		
	}

public static function querySelect(  ){
		
		
		return "  SELECT ".\bsetecHelpers::getdbprefix()."blogcategories.name, ".\bsetecHelpers::getdbprefix()."blogs.* FROM ".\bsetecHelpers::getdbprefix()."blogs JOIN ".\bsetecHelpers::getdbprefix()."blogcategories ON ".\bsetecHelpers::getdbprefix()."blogs.CatID = ".\bsetecHelpers::getdbprefix()."blogcategories.CatID";
	}
	public static function queryWhere(  ){
		
		return " WHERE ".\bsetecHelpers::getdbprefix()."blogs.blogID IS NOT NULL   ";
	}
	
	public static function queryGroup(){
		return "  ";
	}

public function getBlogrows($args, $table='blogs', $key='blogID'){

extract( array_merge( array(
			'page' 		=> '0' ,
			'limit'  	=> '0' ,
			'sort' 		=> '' ,
			'order' 	=> '' ,
			'params' 	=> '' ,
			'global'	=> 1	  
			), $args ));

if(count($args)>0 && isset($args['sort'])){
			$sort   = $args['sort'];
			$order 	= $args['order'];	
			if($args['sort']=='CatID'){
				$sort 			  = \bsetecHelpers::getdbprefix()."blogcategories.name ";
			}
		}else{
			$sort 			  = \bsetecHelpers::getdbprefix()."blogs.blogID ";
			$order 			  = 'DESC';
		}
		
		$offset 		  = ($page-1) * $limit ;	
		$limitConditional = ($page !=0 && $limit !=0) ? "LIMIT  $offset , $limit" : '';	
		$orderConditional = ($sort !='' && $order !='') ?  " ORDER BY {$sort} {$order} " : '';

$result = \DB::select( self::querySelect() . self::queryWhere(). " 
			{$params} ". self::queryGroup() ." {$orderConditional}  {$limitConditional} ");

if($key =='' ) { $key ='*'; } else { $key = \bsetecHelpers::getdbprefix().$table.".".$key ; }	
		$counter_select = preg_replace( '/[\s]*SELECT(.*)FROM/Usi', 'SELECT count('.$key.') as total FROM', self::querySelect() ); 	
		
		$res = \DB::select( $counter_select . self::queryWhere()." {$params} ". self::queryGroup());

if(count($res)>0){
			$total = $res['0']->total;
		}else{
			$total = false;
		}

return $results = array('rows'=> $result , 'total' => $total);
	}

public function getCatinfo(){
		return \DB::table('blogcategories')->where('enable', '=', '1')->get();
	}

}