当前位置: 首页>>代码示例>>PHP>>正文


PHP Breadcrumbs::addCrumb方法代码示例

本文整理汇总了PHP中Breadcrumbs::addCrumb方法的典型用法代码示例。如果您正苦于以下问题:PHP Breadcrumbs::addCrumb方法的具体用法?PHP Breadcrumbs::addCrumb怎么用?PHP Breadcrumbs::addCrumb使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Breadcrumbs的用法示例。


在下文中一共展示了Breadcrumbs::addCrumb方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: getIndex

 public function getIndex()
 {
     $this->heads = array(array('Role', array('search' => true, 'sort' => false, 'select' => Prefs::getRole()->RoleToSelection('_id', 'rolename'))), array('Created', array('search' => true, 'sort' => true, 'date' => true)), array('Last Update', array('search' => true, 'sort' => true, 'date' => true)));
     //print $this->model->where('docFormat','picture')->get()->toJSON();
     Breadcrumbs::addCrumb('System', URL::to(strtolower($this->controller_name)));
     return parent::getIndex();
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:7,代码来源:UsergroupController.php

示例2: getIndex

 public function getIndex()
 {
     $this->heads = array(array('Full Name', array('search' => true, 'sort' => true)), array('Role', array('search' => true, 'sort' => false, 'select' => Prefs::getRole()->RoleToSelection('_id', 'rolename'))), array('Email', array('search' => true, 'sort' => true)), array('Mobile', array('search' => true, 'sort' => true)), array('Address', array('search' => true, 'sort' => true)), array('Created', array('search' => true, 'sort' => true, 'date' => true)), array('Last Update', array('search' => true, 'sort' => true, 'date' => true)));
     $this->title = 'Employees';
     $this->place_action = 'first';
     Breadcrumbs::addCrumb('HRMS', URL::to(strtolower($this->controller_name)));
     return parent::getIndex();
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:8,代码来源:EmployeeController.php

示例3: getIndex

 public function getIndex()
 {
     $this->heads = array(array('Type', array('search' => true, 'sort' => true)), array('Created', array('search' => true, 'sort' => true, 'daterange' => true)), array('Last Update', array('search' => true, 'sort' => true, 'daterange' => true)));
     //print $this->model->where('docFormat','picture')->get()->toJSON();
     $this->title = 'Device Type';
     Breadcrumbs::addCrumb('Assets', URL::to(strtolower($this->controller_name)));
     return parent::getIndex();
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:8,代码来源:DateparamController.php

示例4: getIndex

 public function getIndex()
 {
     $this->heads = array(array('Name', array('search' => false, 'sort' => false)), array('Code', array('search' => false, 'sort' => false)), array('Venue', array('search' => true, 'sort' => true)), array('Address', array('search' => true, 'sort' => true)), array('Category', array('search' => true, 'sort' => true, 'select' => Config::get('asset.location_category'))), array('Tags', array('search' => true, 'sort' => true)), array('Created', array('search' => true, 'sort' => true, 'daterange' => true)), array('Last Update', array('search' => true, 'sort' => true, 'daterange' => true)));
     //print $this->model->where('docFormat','picture')->get()->toJSON();
     $this->title = 'Location';
     Breadcrumbs::addCrumb('Assets', URL::to(strtolower($this->controller_name)));
     $this->additional_filter = View::make('assetlocation.addfilter')->render();
     return parent::getIndex();
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:9,代码来源:AssetlocationController.php

示例5: __construct

 public function __construct(Authentication $auth, Store $session, Request $request, Redirector $redirect, Application $application)
 {
     $this->auth = $auth;
     $this->session = $session;
     $this->request = $request;
     $this->redirect = $redirect;
     $this->application = $application;
     \Breadcrumbs::addCrumb(trans('core::core.breadcrumb.home'), \URL::route('dashboard.index'));
 }
开发者ID:notegame,项目名称:asgardcms,代码行数:9,代码来源:AdminMiddleware.php

示例6: getIndex

 public function getIndex()
 {
     $this->heads = array(array('Full Name', array('search' => true, 'sort' => true)), array('Role', array('search' => true, 'sort' => false, 'select' => Prefs::getRole()->RoleToSelection('_id', 'rolename'))), array('Email', array('search' => true, 'sort' => true)), array('Mobile', array('search' => true, 'sort' => true)), array('Address', array('search' => true, 'sort' => true)), array('Created', array('search' => true, 'sort' => true, 'date' => true)), array('Last Update', array('search' => true, 'sort' => true, 'date' => true)));
     $this->title = 'Users';
     $this->place_action = 'first';
     Breadcrumbs::addCrumb('Profile', URL::to(strtolower($this->controller_name)));
     //return parent::getIndex();
     $bt_edit = '<a href="' . URL::to('profile/edit/' . Auth::user()->_id) . '" class="btn btn-sm btn-primary btn-transparent"><i class="fa fa-edit"></i> Edit</a>';
     return View::make('profile.index')->with('title', Auth::user()->fullname . ' ' . $bt_edit);
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:10,代码来源:ProfileController.php

示例7: getIndex

 public function getIndex()
 {
     $this->heads = array(array('Rack Code', array('search' => true, 'sort' => true)), array('Picture', array('search' => true, 'sort' => true, 'attr' => array('class' => 'span2'))), array('Description', array('search' => true, 'sort' => true)), array('Location', array('search' => true, 'sort' => true, 'select' => Assets::getLocation()->LocationToSelection('_id', 'name', true))), array('Tags', array('search' => true, 'sort' => true)), array('Created', array('search' => true, 'sort' => true, 'date' => true)), array('Last Update', array('search' => true, 'sort' => true, 'date' => true)));
     //print $this->model->where('docFormat','picture')->get()->toJSON();
     $this->title = 'Racks';
     $this->place_action = 'first';
     Breadcrumbs::addCrumb('Assets', URL::to(strtolower($this->controller_name)));
     $this->additional_filter = View::make('rack.addfilter')->render();
     //$this->js_additional_param = "aoData.push( { 'name':'categoryFilter', 'value': $('#assigned-product-filter').val() } );";
     return parent::getIndex();
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:11,代码来源:RackController.php

示例8: __construct

 public function __construct()
 {
     parent::__construct();
     $this->controller_name = str_replace('Controller', '', get_class());
     //$this->crumb = new Breadcrumb();
     //$this->crumb->append('Home','left',true);
     //$this->crumb->append(strtolower($this->controller_name));
     $this->model = new Holiday();
     //$this->model = DB::collection('documents');
     $this->title = $this->controller_name;
     Breadcrumbs::addCrumb('HRMS Parameters', URL::to(strtolower($this->controller_name)));
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:12,代码来源:HolidayController.php

示例9: getIndex

 public function getIndex()
 {
     Options::refresh();
     $this->heads = array(array('Option', array('search' => true, 'sort' => true, 'attr' => array('class' => 'span2'))), array('Var Name', array('search' => true, 'sort' => true, 'attr' => array('class' => 'span2'))), array('Value', array('search' => true, 'sort' => true)));
     //print $this->model->where('docFormat','picture')->get()->toJSON();
     $this->title = 'Option';
     //$this->crumb = Breadcrumb::generate();
     $this->place_action = 'first';
     $this->can_add = false;
     $this->modal_sets = View::make(strtolower($this->controller_name) . '.modal')->render();
     $this->js_table_event = View::make(strtolower($this->controller_name) . '.tableevent')->render();
     Breadcrumbs::addCrumb('System', URL::to(strtolower($this->controller_name)));
     return parent::getIndex();
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:14,代码来源:OptionController.php

示例10: getIndex

 public function getIndex()
 {
     Breadcrumbs::addCrumb('Reports', URL::to($this->controller_name));
     $this->report_action = $this->controller_name;
     $this->additional_filter = View::make('approvalreport.addfilter')->with('report_action', $this->report_action)->render();
     $dataArray01 = array('label' => 'My First Dataset', 'fillColor' => 'rgba(220,220,220,0.2)', 'strokeColor' => 'rgba(220,220,220,1)', 'pointColor' => 'rgba(220,220,220,1)', 'pointStrokeColor' => '#fff', 'pointHighlightFill' => '#fff', 'pointHighlightStroke' => 'rgba(220,220,220,1)', 'data' => array(65, 59, 80, 81, 56, 55, 40));
     $dataArray02 = array('label' => 'My First Dataset', 'fillColor' => 'rgba(220,220,220,0.2)', 'strokeColor' => 'rgba(220,220,220,1)', 'pointColor' => 'rgba(220,220,220,1)', 'pointStrokeColor' => '#fff', 'pointHighlightFill' => '#fff', 'pointHighlightStroke' => 'rgba(220,220,220,1)', 'data' => array(28, 48, 40, 19, 86, 27, 90));
     $dataArray03 = array('label' => 'My Third Dataset', 'fillColor' => 'rgba(200,200,200,0.2)', 'strokeColor' => 'rgba(220,220,220,1)', 'pointColor' => 'rgba(220,220,220,1)', 'pointStrokeColor' => '#fff', 'pointHighlightFill' => '#fff', 'pointHighlightStroke' => 'rgba(220,220,220,1)', 'data' => array(35, 12, 60, 22, 100, 90, 85));
     $labels = array("Januari", "Februari", "March", "April", "Mei", "June", "Juli");
     $this->data = array('series01' => $dataArray01, 'series02' => $dataArray02, 'series03' => $dataArray03, 'labels' => $labels);
     $this->report_view = 'approvalreport.report';
     $this->title = 'Approvals';
     return parent::getIndex();
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:14,代码来源:ApprovalreportController.php

示例11: getHistory

 public function getHistory($type = 'asset', $id)
 {
     $_id = new MongoId($id);
     if ($type == 'Location') {
         $type = 'location';
     } elseif ($type == 'Rack') {
         $type = 'rack';
     } else {
         $type = 'asset';
     }
     $history = History::where('historyObject._id', $_id)->where('historyObjectType', $type)->orderBy('historyTimestamp', 'desc')->orderBy('historySequence', 'desc')->get();
     $diffs = array();
     foreach ($history as $h) {
         $h->date = date('Y-m-d H:i:s', $h->historyTimestamp->sec);
         $diffs[$h->date][$h->historySequence] = $h->historyObject;
     }
     $history = History::where('historyObject._id', $_id)->where('historyObjectType', $type)->where('historySequence', 0)->orderBy('historyTimestamp', 'desc')->get();
     $tab_data = array();
     foreach ($history as $h) {
         $apv_status = Assets::getApprovalStatus($h->approvalTicket);
         if ($apv_status == 'pending') {
             $bt_apv = '<span class="btn btn-info change-approval ' . $h->approvalTicket . '" data-id="' . $h->approvalTicket . '" >' . $apv_status . '</span>';
         } else {
             if ($apv_status == 'verified') {
                 $bt_apv = '<span class="btn btn-success" >' . $apv_status . '</span>';
             } else {
                 $bt_apv = '';
             }
         }
         $d = date('Y-m-d H:i:s', $h->historyTimestamp->sec);
         $tab_data[] = array($d, $h->historyAction, $h->historyObject['SKU'], $h->historyAction == 'new' ? 'NA' : $this->objdiff($diffs[$d]), $bt_apv);
     }
     $header = array('Modified', 'Event', 'Name', 'Diff', 'Approval');
     $attr = array('class' => 'table', 'id' => 'transTab', 'style' => 'width:100%;', 'border' => '0');
     $t = new HtmlTable($tab_data, $attr, $header);
     $itemtable = $t->build();
     $asset = Asset::find($id);
     Breadcrumbs::addCrumb('Approval', URL::to(strtolower($this->controller_name)));
     Breadcrumbs::addCrumb('Change Detail', URL::to(strtolower($this->controller_name)));
     return View::make('history.table')->with('a', $asset)->with('title', 'Change Detail')->with('table', $itemtable);
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:41,代码来源:ApprovalController.php

示例12: getIndex

 public function getIndex()
 {
     $this->heads = array(array('Merchant Name', array('search' => true, 'sort' => true, 'attr' => array('class' => 'span2'))), array('Legacy ID', array('search' => true, 'sort' => true, 'attr' => array('class' => 'span2'))), array('Status', array('search' => true, 'sort' => true, 'select' => array('' => 'All', 'active' => 'Active', 'inactive' => 'Inactive'), 'attr' => array('class' => 'span2'))), array('Category', array('search' => true, 'select' => Prefs::getShopCategory()->shopcatToSelection('slug', 'name'), 'sort' => true)), array('URL', array('search' => true, 'sort' => true)), array('Email', array('search' => true, 'sort' => true)), array('Phone', array('search' => true, 'sort' => true)), array('Street', array('search' => true, 'sort' => true)), array('City', array('search' => true, 'sort' => true)), array('Created', array('search' => true, 'sort' => true, 'datetimerange' => true)), array('Last Update', array('search' => true, 'sort' => true, 'datetimerange' => true)));
     //print $this->model->where('docFormat','picture')->get()->toJSON();
     $this->title = 'Advertiser';
     $this->place_action = 'first';
     Breadcrumbs::addCrumb('Assets', URL::to(strtolower($this->controller_name)));
     $this->additional_filter = View::make(strtolower($this->controller_name) . '.addfilter')->with('sync_url', strtolower($this->controller_name) . '/synclegacy')->render();
     $this->js_additional_param = "aoData.push( { 'name':'categoryFilter', 'value': \$('#assigned-product-filter').val() } );";
     $this->product_info_url = strtolower($this->controller_name) . '/info';
     return parent::getIndex();
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:12,代码来源:AdvertiserController.php

示例13: getCommit

 public function getCommit($sessid)
 {
     $heads = Importsession::where('sessId', '=', $sessid)->where('isHead', '=', 1)->first();
     $heads = $heads['heads'];
     $imports = Importsession::where('sessId', '=', $sessid)->where('isHead', '=', 0)->get();
     $headselect = array();
     foreach ($heads as $h) {
         $headselect[$h] = $h;
     }
     $vl = $this->validateData($imports->toArray());
     $dbval = $vl['db'];
     $inval = $vl['in'];
     $title = $this->controller_name;
     $submit = strtolower($this->controller_name) . '/commit/' . $sessid;
     $controller_name = strtolower($this->controller_name);
     $this->title = $this->title == '' ? Str::plural($this->controller_name) : Str::plural($this->title);
     Breadcrumbs::addCrumb($this->title, URL::to($controller_name));
     Breadcrumbs::addCrumb('Import ' . $this->title, URL::to($controller_name . '/import'));
     Breadcrumbs::addCrumb('Preview', URL::to($controller_name . '/import'));
     return View::make('importer.commitselect')->with('title', $title)->with('submit', $submit)->with('headselect', $headselect)->with('heads', $heads)->with('dbval', $dbval)->with('inval', $inval)->with('back', $controller_name . '/import')->with('imports', $imports);
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:21,代码来源:ImporterController.php

示例14: getPrint

 public function getPrint()
 {
     $this->fields = Config::get('jex.default_log_fields');
     //print $this->model->where('docFormat','picture')->get()->toJSON();
     $this->title = 'Delivery Log';
     Breadcrumbs::addCrumb('Cost Report', URL::to(strtolower($this->controller_name)));
     //$this->additional_filter = View::make(strtolower($this->controller_name).'.addfilter')->with('submit_url','gl/static')->render();
     //$this->js_additional_param = "aoData.push( { 'name':'acc-period-to', 'value': $('#acc-period-to').val() }, { 'name':'acc-period-from', 'value': $('#acc-period-from').val() }, { 'name':'acc-code-from', 'value': $('#acc-code-from').val() }, { 'name':'acc-code-to', 'value': $('#acc-code-to').val() }, { 'name':'acc-company', 'value': $('#acc-company').val() } );";
     $this->product_info_url = strtolower($this->controller_name) . '/info';
     $this->printlink = strtolower($this->controller_name) . '/print';
     //table generator part
     $this->fields = array(array(Config::get('jayon.jayon_members_table') . '.merchantname', array('kind' => 'text', 'alias' => 'merchant_name', 'query' => 'like', 'callback' => 'merchantInfo', 'pos' => 'both', 'show' => true)), array('ordertime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickuptime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickup_person', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickup_person', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliverytime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliveryslot', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliveryzone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliverycity', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('shipping_address', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('merchant_trans_id', array('kind' => 'text', 'callback' => 'dispBar', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_type', array('kind' => 'text', 'callback' => 'colorizetype', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('directions', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)));
     $db = Config::get('jayon.main_db');
     $this->def_order_by = 'ordertime';
     $this->def_order_dir = 'desc';
     $this->place_action = 'none';
     $this->show_select = false;
     $this->sql_key = 'delivery_id';
     $this->sql_table_name = Config::get('jayon.incoming_delivery_table');
     $this->sql_connection = 'mysql';
     $this->responder_type = 's';
     return parent::printPage();
 }
开发者ID:awidarto,项目名称:bilnatracker,代码行数:23,代码来源:DeliverylogController.php

示例15: getIndex

 public function getIndex()
 {
     $this->heads = array(array('Period', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('Date', array('search' => true, 'sort' => true, 'style' => 'min-width:100px;', 'daterange' => true)), array('JV Ref', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;')), array('Account', array('search' => true, 'style' => 'min-width:100px;', 'sort' => true)), array('Account Description', array('search' => true, 'style' => 'min-width:125px;', 'sort' => true)), array('Reference Doc.', array('search' => true, 'sort' => true)), array('Orig. Currency', array('search' => true, 'sort' => true)), array('Orig. Amount', array('search' => true, 'sort' => true)), array('Conversion Rate', array('search' => true, 'sort' => true)), array('Base Amount', array('search' => true, 'sort' => true)), array('Transaction Description', array('search' => true, 'sort' => true)));
     //print $this->model->where('docFormat','picture')->get()->toJSON();
     $this->title = 'AFE Report - Lvl 2';
     $this->place_action = 'none';
     $this->show_select = false;
     Breadcrumbs::addCrumb('Cost Report', URL::to(strtolower($this->controller_name)));
     $this->additional_filter = View::make(strtolower($this->controller_name) . '.addfilter')->with('submit_url', 'afelvltwo')->render();
     $db = Config::get('lundin.main_db');
     $company = Input::get('acc-company');
     $period_from = Input::get('acc-period-from');
     $period_to = Input::get('acc-period-to');
     if ($period_from == '' || is_null($period_from)) {
         $period_from = date('Y0m', time());
     }
     if ($period_to == '' || is_null($period_to)) {
         $period_to = date('Y0m', time());
     }
     $company = strtolower($company);
     if ($company == '') {
         $company = Config::get('lundin.default_company');
     }
     $afe = Input::get('acc-afe');
     if ($afe == '' || is_null($afe)) {
         $afes = Prefs::getAfe($company)->AfeToArray();
         $afe = $afes[0]->ANL_CODE;
     }
     $company = strtolower($company);
     $this->def_order_by = 'TRANS_DATETIME';
     $this->def_order_dir = 'DESC';
     $this->place_action = 'none';
     $this->show_select = false;
     $this->sql_key = 'TRANS_DATETIME';
     $this->sql_table_name = $company . '_a_salfldg';
     $this->sql_connection = 'mysql2';
     /* Start custom queries */
     $model = DB::connection($this->sql_connection)->table($this->sql_table_name);
     $tables = array();
     $actualresult = $model->select(DB::raw($company . '_a_salfldg.ACCNT_CODE,' . $company . '_acnt.DESCR AS ADESCR,' . 'SUM(' . $company . '_a_salfldg.AMOUNT) as AMT'))->where($company . '_a_salfldg.ACCNT_CODE', 'like', '2%')->where($company . '_a_salfldg.ANAL_T1', '=', $afe)->where($company . '_a_salfldg.PERIOD', '>=', $period_from)->where($company . '_a_salfldg.PERIOD', '<=', $period_to)->leftJoin($company . '_acnt', $company . '_a_salfldg.ACCNT_CODE', '=', $company . '_acnt.ACNT_CODE')->groupBy($company . '_a_salfldg.ACCNT_CODE')->get();
     $model = DB::connection($this->sql_connection)->table($company . '_a_salfldg');
     $prioritdresult = $model->select(DB::raw($company . '_a_salfldg.ACCNT_CODE,' . $company . '_acnt.DESCR AS ADESCR,' . 'SUM(' . $company . '_a_salfldg.AMOUNT) as AMT'))->where($company . '_a_salfldg.ACCNT_CODE', 'like', '2%')->where($company . '_a_salfldg.ANAL_T1', '=', $afe)->where($company . '_a_salfldg.PERIOD', '<', $period_from)->leftJoin($company . '_acnt', $company . '_a_salfldg.ACCNT_CODE', '=', $company . '_acnt.ACNT_CODE')->groupBy($company . '_a_salfldg.ACCNT_CODE')->get();
     $model = DB::connection($this->sql_connection)->table($company . '_a_salfldg');
     $currentitdresult = $model->select(DB::raw($company . '_a_salfldg.ACCNT_CODE,' . $company . '_acnt.DESCR AS ADESCR,' . 'SUM(' . $company . '_a_salfldg.AMOUNT) as AMT'))->where($company . '_a_salfldg.ACCNT_CODE', 'like', '2%')->where($company . '_a_salfldg.ANAL_T1', '=', $afe)->where($company . '_a_salfldg.PERIOD', '<=', $period_to)->leftJoin($company . '_acnt', $company . '_a_salfldg.ACCNT_CODE', '=', $company . '_acnt.ACNT_CODE')->groupBy($company . '_a_salfldg.ACCNT_CODE')->get();
     $model = DB::connection($this->sql_connection)->table($company . '_b_salfldg');
     $budgetresult = $model->select(DB::raw($company . '_b_salfldg.ACCNT_CODE,' . $company . '_acnt.DESCR AS ADESCR,' . 'SUM(' . $company . '_b_salfldg.AMOUNT) as AMT'))->where($company . '_b_salfldg.ACCNT_CODE', 'like', '2%')->where($company . '_b_salfldg.ANAL_T1', '=', $afe)->where($company . '_b_salfldg.PERIOD', '>=', $period_from)->where($company . '_b_salfldg.PERIOD', '<=', $period_to)->leftJoin($company . '_acnt', $company . '_b_salfldg.ACCNT_CODE', '=', $company . '_acnt.ACNT_CODE')->groupBy($company . '_b_salfldg.ACCNT_CODE')->get();
     $model = DB::connection($this->sql_connection)->table($company . '_d_salfldg');
     $revbudgetresult = $model->select(DB::raw($company . '_d_salfldg.ACCNT_CODE,' . $company . '_acnt.DESCR AS ADESCR,' . 'SUM(' . $company . '_d_salfldg.AMOUNT) as AMT'))->where($company . '_d_salfldg.ACCNT_CODE', 'like', '2%')->where($company . '_d_salfldg.ANAL_T1', '=', $afe)->where($company . '_d_salfldg.PERIOD', '>=', $period_from)->where($company . '_d_salfldg.PERIOD', '<=', $period_to)->leftJoin($company . '_acnt', $company . '_d_salfldg.ACCNT_CODE', '=', $company . '_acnt.ACNT_CODE')->groupBy($company . '_d_salfldg.ACCNT_CODE')->get();
     $tabdata = array();
     foreach ($actualresult as $a) {
         $tabdata[$a->ACCNT_CODE] = $a;
         $tabdata[$a->ACCNT_CODE]->BAMT = 0;
         $tabdata[$a->ACCNT_CODE]->DAMT = 0;
         $tabdata[$a->ACCNT_CODE]->PITDAMT = 0;
         $tabdata[$a->ACCNT_CODE]->CITDAMT = 0;
     }
     foreach ($prioritdresult as $p) {
         if (isset($tabdata[$p->ACCNT_CODE])) {
             $tabdata[$p->ACCNT_CODE]->PITDAMT = $p->AMT;
         }
     }
     foreach ($currentitdresult as $c) {
         if (isset($tabdata[$c->ACCNT_CODE])) {
             $tabdata[$c->ACCNT_CODE]->CITDAMT = $c->AMT;
         }
     }
     foreach ($budgetresult as $b) {
         if (isset($tabdata[$b->ACCNT_CODE])) {
             $tabdata[$b->ACCNT_CODE]->BAMT = $b->AMT;
         } else {
             $tabdata[$b->ACCNT_CODE] = $b;
             $tabdata[$b->ACCNT_CODE]->BAMT = $b->AMT;
             $tabdata[$b->ACCNT_CODE]->AMT = 0;
             $tabdata[$b->ACCNT_CODE]->DAMT = 0;
             $tabdata[$b->ACCNT_CODE]->PITDAMT = 0;
             $tabdata[$b->ACCNT_CODE]->CITDAMT = 0;
         }
     }
     foreach ($revbudgetresult as $d) {
         if (isset($tabdata[$d->ACCNT_CODE])) {
             $tabdata[$d->ACCNT_CODE]->DAMT = $d->AMT;
         } else {
             $tabdata[$d->ACCNT_CODE] = $d;
             $tabdata[$d->ACCNT_CODE]->DAMT = $d->AMT;
             $tabdata[$d->ACCNT_CODE]->AMT = 0;
             $tabdata[$d->ACCNT_CODE]->BAMT = 0;
             $tabdata[$d->ACCNT_CODE]->PITDAMT = 0;
             $tabdata[$d->ACCNT_CODE]->CITDAMT = 0;
         }
     }
     ksort($tabdata);
     $tattrs = array('width' => '100%', 'class' => 'table table-bordered');
     $thead = array();
     $tdataclr = array();
     $tdataexp = array();
     $thead[] = array(array('value' => '#', 'attr' => 'rowspan=2'), array('value' => 'Account', 'attr' => 'colspan=2 rowspan=2 class="center"'), array('value' => 'Budget', 'attr' => 'colspan=3'), array('value' => 'Actual', 'attr' => 'colspan=3'), array('value' => 'Variance', 'attr' => 'colspan=2'));
     $thead[] = array(array('value' => 'Original'), array('value' => 'Revised'), array('value' => 'Current Year'), array('value' => 'Prior ITD'), array('value' => 'Period To Date'), array('value' => 'Current ITD'), array('value' => '$'), array('value' => '%'));
     $seq = 1;
     $sumexp = new stdClass();
     $sumclr = new stdClass();
//.........这里部分代码省略.........
开发者ID:awidarto,项目名称:bilnatracker,代码行数:101,代码来源:AfelvltwoController.php


注:本文中的Breadcrumbs::addCrumb方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。