PHP Company::select方法代码示例

 public function query()
 {
     $params['order'] = isset($params['order']) ? $params['order'] : ['name|ASC'];
     $companies = Company::select("companies.*");
     $companies->leftJoin("company_main_contacts", "companies.id", "=", "company_main_contacts.company_id");
     $companies->leftJoin("company_person as company_person_main_contacts", "company_person_main_contacts.id", "=", "company_main_contacts.main_contact_id");
     $companies->leftJoin("company_account_managers", "companies.id", "=", "company_account_managers.company_id");
     $companies->leftJoin("company_person as company_person_account_managers", "company_person_account_managers.id", "=", "company_account_managers.account_manager_id");
     $companies->leftJoin("people as account_managers", "company_person_account_managers.person_id", "=", "account_managers.id");
     $companies->leftJoin("people as main_contacts", "company_person_main_contacts.person_id", "=", "main_contacts.id");
     if (!Auth::user()->active_contact->isE80()) {
         $companies->where("companies.id", "=", Auth::user()->active_contact->company_id);
     }
     return $companies;
 }

 public function actionOpenfrmtimport()
 {
     $model = new FormOpenfrmt();
     if (isset($_POST['SwitchType'])) {
         //save current
         //$corComp=Yii::$app->user->Database->id;
         $newComp = (int) $_POST['companyId'];
         //company load
         Company::select($newComp);
         foreach ($_POST['SwitchType'] as $old => $new) {
             \app\models\Acctype::switchType($old, $new);
         }
         //end
         //$this->redirect(\yii\helpers\BaseUrl::base() . '/company/index');
     }
     if (isset($_POST['FormOpenfrmt'])) {
         //$yiiUser=Yii::$app->user->id;
         //$configPath=\app\helpers\Linet3Helper::getSetting("company.path");
         $file = Company::getFilePath() . "ini.txt";
         $model->iniFile = $_POST['FormOpenfrmt']['iniFile'];
         $model->iniFile = \yii\web\UploadedFile::getInstance($model, 'iniFile');
         if ($model->iniFile->saveAs($file)) {
             $model->iniFile = $file;
             //$model->read();
         }
         $file = Company::getFilePath() . "/bkmv.txt";
         $model->bkmvFile = $_POST['FormOpenfrmt']['bkmvFile'];
         $model->bkmvFile = \yii\web\UploadedFile::getInstance($model, 'bkmvFile');
         if ($model->bkmvFile->saveAs($file)) {
             //$corComp = ;
             $model->bkmvFile = $file;
             $model->readIni();
             $this->company = $model->companyId;
             Company::select($this->company);
             $model->readBkmv();
             Company::select($this->company);
         }
         return $this->render('openfrmtimportajax', array('model' => $model));
         Yii::$app->end();
     }
     return $this->render('openfrmtimport', array('model' => $model));
     //echo $model->read();
 }

 /**
  * Get Companies options for 'select' dropdown in Vuejs format
  */
 public function getCompanies(Request $request, $company_id, $trade_id, $site_id)
 {
     $company_list = Auth::user()->company->companyList('1')->pluck('id')->toArray();
     if ($company_id == 'match-trade' || $trade_id == 'match-trade') {
         //if ($trade_id == 'match-trade')
         // All authorised companies that have the given trade_id
         $companies = Company::select(['companys.id', 'companys.name'])->join('company_trade', 'companys.id', '=', 'company_trade.company_id')->where('companys.status', '1')->where('company_trade.trade_id', $trade_id)->whereIn('companys.id', $company_list)->orderBy('name')->get();
     } else {
         if ($company_id == 'all') {
             // All authorised companies
             $companies = Company::where('status', '1')->whereIn('id', $company_list)->orderBy('name')->get();
         } else {
             // All authorised companies except the given company_id
             $companies = Company::where('status', '1')->whereIn('id', $company_list)->where('id', '<>', $company_id)->orderBy('name')->get();
         }
     }
     // Unique array of companies currently on planner for given site_id
     $companiesOnPlanner = SitePlanner::distinct()->select('entity_id')->where('site_id', $site_id)->where('entity_type', 'c')->groupBy('entity_id')->lists('entity_id')->toArray();
     $array = [];
     $array[] = ['value' => '', 'text' => 'Select company'];
     if ($company_id == 'match-trade') {
         $array[] = ['value' => 'gen', 'text' => 'Unassigned (Generic)'];
     }
     // Create array in specific Vuejs 'select' format.
     foreach ($companies as $company) {
         $text = $company->name;
         if (in_array($company->id, $companiesOnPlanner)) {
             $text = '<b>' . $company->name . '</b>';
         }
         $array[] = ['value' => $company->id, 'text' => $text, 'name' => $company->name];
     }
     return $array;
 }

 /**
  * Function Remove
  * Process Delete the Brand Data
  *
  * @return \Illuminate\Http\JsonResponse
  */
 public function onDelete()
 {
     $id = Input::get('id');
     $Model = \App\Models\Company::select(['id'])->where('id', $id)->first();
     if ($Model) {
         \App\Models\Company::where('id', $id)->delete();
         $param['message'] = Lang::get('info.has deleted');
         $param['error'] = false;
     } else {
         $param['message'] = Lang::get('info.has error');
         $param['error'] = true;
     }
     return json_encode($param);
 }