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

示例#3
0
<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
示例#4
0
<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
示例#6
0
}
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