if ($filter_array['datefrom'] != '') { $query->where('date_created', '>=', (Input::get("datefrom") != '' ? Input::get("datefrom") : $filter_array['datefrom']) . ' 00:00:00'); } } if (Input::get("dateto") != '' || isset($filter_array['dateto'])) { #Clear or assign $filter_array['dateto'] = Input::get("dateto") == '' && Input::get("_token") != '' ? '' : (Input::get("dateto") != '' ? Input::get("dateto") : $filter_array['dateto']); if ($filter_array['dateto'] != '') { $query->where('date_created', '<=', (Input::get("dateto") != '' ? Input::get("dateto") : $filter_array['dateto']) . ' 23:59:59'); } } if (Input::get("active_status") != '' || isset($filter_array['active_status'])) { #Clear or assign $filter_array['active_status'] = Input::get("active_status") == '' && Input::get("_token") != '' ? '' : (Input::get("active_status") != '' ? Input::get("active_status") : $filter_array['active_status']); if ($filter_array['active_status'] != '') { $query->where('account_status', '=', Input::get("active_status") != '' ? Input::get("active_status") : $filter_array['active_status']); } } Session::put('FilterArray', $filter_array); $total_pages = count($query->where("account_type", '=', 'INVESTOR')->get()); $result = $query->skip(Session::get('rec_per_page') * (Input::get('page') - 1))->take(Session::get('rec_per_page'))->where("account_type", '=', 'INVESTOR')->select(array('account_id AS primarykey', "firstname as first_name", 'lastname as last_name', 'countries_dbx.id', 'phone', 'email_address', 'date_created', 'account_status as status', 'gender'))->get(); echo Helpers::generateGrid(array("title" => "Viewing Listing of investors", "print" => false, "view" => "investor", "search" => false, "checkbox" => false, "col_number" => false, "total_pages" => $total_pages, "actions" => "", "filters" => array("investors", "date"), "isReport" => true, "data" => $result)); ?> </section><!-- /.content --> @stop
<section class="content-header"> <h1> Viewers List </h1> <ol class="breadcrumb"> <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li> <li class="active">My Campaign Viewers</li> <br /> </ol> </section> <!-- Main content --> <section class="content"> <?php $result = Campaign::getMultipleViews(); if (!empty($result)) { echo Helpers::generateGrid(array("title" => "My Campaign Viewers", "print" => false, "view" => "", "search" => false, "checkbox" => false, "col_number" => false, "total_pages" => 30, "actions" => "", "filters" => array(), "isReport" => Session::get('account_type') == 'ADMIN' ? false : false, "data" => $result)); } else { echo "<h4> No records to show. </h4>"; } ?> </section><!-- /.content --> @stop
<h1> Shares </h1> <ol class="breadcrumb"> <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li> <li class="active">Finance</li> <li class="active">Shares</li> </ol> </section> <!-- Main content --> <section class="content"> <?php $query = DB::table("tbl_campaign_summary"); $query->join("tbl_campaigns", "campaign_id", "=", "campaign_id"); // $query->where("account_type",'=','ENTREPRENEUR'); if (Input::get("table_search") != '') { //$query->where("email_address",'LIKE',"%". Input::get("table_search") ."%"); $searchColumns = array("firstname", 'lastname', 'country', 'phone', 'email_address', 'date_created', 'account_status', 'gender'); foreach ($searchColumns as $item) { $query->orWhere($item, 'LIKE', "%" . Input::get("table_search") . "%"); } } $total_pages = count($query->get()); //DB::table("accounts_dbx"). $result = $query->skip(Session::get('rec_per_page') * (Input::get('page') - 1))->take(Session::get('rec_per_page'))->select(array('campaign_id AS primarykey', "Business_name", 'Business_summary', 'campaignstatus as campaign_status', 'creationtime as creation_time'))->get(); echo Helpers::generateGrid(array("title" => "Viewing Shares Allocation Report", "print" => false, "search" => false, "view" => "report", "checkbox" => false, "col_number" => false, "total_pages" => $total_pages, "actions" => "", "filters" => array("date"), "isReport" => false, "data" => $result)); ?> </section><!-- /.content --> @stop
<h1> Campaigns </h1> <ol class="breadcrumb"> <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li> <li class="active">Campaigns</li> </ol> </section> <!-- Main content --> <section class="content"> <?php $query = DB::table("tbl_campaign_summary"); //$query->join("tbl_campaigns","campaign_id","=","campaign_id"); // $query->where("account_type",'=','ENTREPRENEUR'); if (Input::get("table_search") != '') { //$query->where("email_address",'LIKE',"%". Input::get("table_search") ."%"); $searchColumns = array("firstname", 'lastname', 'country', 'phone', 'email_address', 'date_created', 'account_status', 'gender'); foreach ($searchColumns as $item) { $query->orWhere($item, 'LIKE', "%" . Input::get("table_search") . "%"); } } $total_pages = count($query->get()); //DB::table("accounts_dbx"). $result = $query->skip(Session::get('rec_per_page') * (Input::get('page') - 1))->take(Session::get('rec_per_page'))->select(array('campaign_id AS primarykey', "Business_name", 'Business_summary', 'campaignstatus as campaign_status', 'creationtime as creation_time'))->get(); echo Helpers::generateGrid(array("title" => "Viewing Listing of Campaigns", "print" => false, "search" => false, "view" => "ENTREPRENEUR", "checkbox" => false, "col_number" => false, "total_pages" => $total_pages, "actions" => "", "filters" => array("date"), "isReport" => false, "data" => $result)); ?> </section><!-- /.content --> @stop
@extends('admin.layouts.default') @section('content') <section class="content-header"> <h1> Entrepreneurs </h1> <ol class="breadcrumb"> <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li> <li class="active">Accounts Administration</li> <li class="active">Entrepreneurs</li> </ol> </section> <!-- Main content --> <section class="content"> <?php $result = DB::select("SELECT account_id AS primarykey, firstname, lastname,country,phone,email_address,date_created,account_status,gender FROM accounts_dbx WHERE account_type='ENTREPRENEUR'"); echo Helpers::generateGrid(array("title" => "Viewing Listing of Entrepreneur", "print" => false, "search" => false, "view" => "ENTREPRENEUR", "checkbox" => false, "col_number" => false, "pagination" => "", "actions" => "", "filters" => array("date"), "isReport" => true, "data" => $result)); ?> </section><!-- /.content --> @stop
} if (Input::get("datefrom") != '' || !empty($filter_array['datefrom'])) { #Clear or assign $filter_array['datefrom'] = Input::get("datefrom") == '' && Input::get("_token") != '' ? '' : (Input::get("datefrom") != '' ? Input::get("datefrom") : $filter_array['datefrom']); if ($filter_array['datefrom'] != '') { $query->where('date_subscribed', '>=', (Input::get("datefrom") != '' ? Input::get("datefrom") : $filter_array['datefrom']) . ' 00:00:00'); } } if (Input::get("dateto") != '' || !empty($filter_array['dateto'])) { #Clear or assign $filter_array['dateto'] = Input::get("dateto") == '' && Input::get("_token") != '' ? '' : (Input::get("dateto") != '' ? Input::get("dateto") : $filter_array['dateto']); if ($filter_array['dateto'] != '') { $query->where('date_subscribed', '<=', (Input::get("dateto") != '' ? Input::get("dateto") : $filter_array['dateto']) . ' 23:59:59'); } } if (Input::get("active_status") != '' || !empty($filter_array['active_status'])) { #Clear or assign $filter_array['active_status'] = Input::get("active_status") == '' && Input::get("_token") != '' ? '' : (Input::get("active_status") != '' ? Input::get("active_status") : $filter_array['active_status']); if ($filter_array['active_status'] != '') { $query->where('status', '=', Input::get("active_status") != '' ? Input::get("active_status") : $filter_array['active_status']); } } Session::put('FilterArray', $filter_array); $total_pages = count($query->get()); $result = $query->skip(Session::get('rec_per_page') * (Input::get('page') - 1))->take(Session::get('rec_per_page'))->select(array('subscriber_id as primarykey', "email_address", 'date_subscribed as date_subscribed_*', 'status as subscription_status'))->get(); echo Helpers::generateGrid(array("title" => "Viewing Listing of Newsletter subscriptions", "print" => false, "view" => "newsletter", "search" => false, "checkbox" => false, "col_number" => false, "total_pages" => $total_pages, "actions" => "", "filters" => array("ACTIVE_STATUS", "date"), "isReport" => false, "data" => $result)); ?> </section><!-- /.content --> @stop