public function search($params) { $query = Lead::find(); $activeDataProvider = new ActiveDataProvider(["query" => $query, "pagination" => ["pageSize" => 20]]); if (!$this->load($params) || !$this->validate()) { return $activeDataProvider; } $query->andFilterWhere(["like", "firstName", $this->firstName])->andFilterWhere(["like", "lastName", $this->lastName])->andFilterWhere(["like", "companyName", $this->companyName])->andFilterWhere(["like", "type", $this->type]); return $activeDataProvider; }
public function solution_checkbox(Lead $lead = null) { $selected = []; if ($lead != null) { $selected = $lead->solutions()->orderBy('sort_order')->lists('solution_id'); } if (request()->isMethod('post')) { if (request()->has('solutions')) { $selected = request()->get('solutions'); } } $solutions = $this->all(); $html = ''; foreach ($solutions as $solution) { $html .= '<div class="checkbox">'; $html .= form()->checkbox('solutions[]', $solution->id, in_array($solution->id, $selected), ['id' => 'cb_' . $solution->id]); $html .= form()->label('cb_' . $solution->id, $solution->name); $html .= '</div>'; } return $html; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Lead::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'budget_tier' => $this->budget_tier, 'budget_mandated' => $this->budget_mandated, 'budget_maintenance' => $this->budget_maintenance, 'budget_innovation' => $this->budget_innovation, 'budget_growth' => $this->budget_growth]); $query->andFilterWhere(['like', 'company', $this->company])->andFilterWhere(['like', 'company_url', $this->company_url])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'contacts', $this->contacts])->andFilterWhere(['like', 'company_description', $this->company_description])->andFilterWhere(['like', 'person_biography', $this->person_biography])->andFilterWhere(['like', 'investment_priorities', $this->investment_priorities])->andFilterWhere(['like', 'platforms', $this->platforms])->andFilterWhere(['like', 'cost_reduction_areas', $this->cost_reduction_areas])->andFilterWhere(['like', 'endpoints', $this->endpoints])->andFilterWhere(['like', 'picture', $this->picture]); return $dataProvider; }
/** * Finds the Lead model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Lead the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Lead::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * @return \yii\db\ActiveQuery */ public function getLeads() { return $this->hasMany(Lead::className(), ['lead_blocked_by' => 'id']); }
public function validate($input, $id = null) { return Lead::validate($input, $id); }
public function store(Request $request) { $project = new Project(); $project->project_name = $request->input('project_name'); $project->project_type = $request->input('project_type'); $project->project_description = $request->input('project_description'); $project->project_budget = $request->input('project_budget'); $project->project_timeline = $request->input('project_timeline'); $project->project_size = $request->input('project_size'); $project->project_framework = $request->input('project_framework'); $project->project_theme = $request->input('project_theme'); $project->project_cms = $request->input('project_cms'); $lead = new Lead(); $lead->lead_name = $request->input('lead_name'); $lead->lead_company = $request->input('lead_company'); $lead->lead_email = $request->input('lead_email'); $lead->lead_phone = $request->input('lead_phone'); $lead->lead_address = $request->input('lead_address'); $lead->lead_city = $request->input('lead_city'); $lead->lead_state = $request->input('lead_state'); $lead->lead_zip = $request->input('lead_zip'); $lead->lead_type = $request->input('lead_type'); $lead->lead_focus = $request->input('lead_focus'); $lead->lead_involvement = $request->input('lead_involvement'); $lead->lead_boss = $request->input('lead_boss'); $lead->save(); // link the new project and lead together in the database $project->user_id = Auth::user()->id; $project->lead_id = $lead->id; $project->save(); return redirect('projects'); }
} ?> </ul> </div> <div id="opps" class="tab-pane fade"> <h3>Opportunities</h3> <p>A List of validated budget holders with confirmed budget sizes and purchasing priorities.</p> <p>Opportunities Table: <?php echo Html::a('Here', ['lead/index']); ?> </p> <ul> <?php foreach (Lead::find()->each() as $lead) { echo "<li> " . Html::img($lead->picture, ['width' => '350', 'height' => '350'], ['alt' => $lead->name]) . Html::a($lead->name, ['lead/view', 'id' => $lead->id]) . "</li>"; } ?> </ul> </div> <div id="tech" class="tab-pane fade"> <h3>Tech</h3> <p>Technologies available for use in solutions throughout the Razormind Network.</p> <p>Tech Table</p> </div> <div id="contracts" class="tab-pane fade"> <h3>Contracts</h3> <p>Active and available contracts. It is useful to review available contracts with partners, suppliers, and clients. Razormind acts as guarantor for each contract signed through this system.</p>
public function getTotalFee(Member $member) { $query = Lead::query(); $query->leftJoin('lead_solutions', function ($join) { $join->on('lead_solutions.lead_id', '=', 'leads.id'); }); $query->leftJoin('solutions', function ($join) { $join->on('solutions.id', '=', 'lead_solutions.solution_id'); }); $query->where('leads.member_id', '=', $member->id); $query->select(db()->raw('lead_solutions.*, solutions.fee')); $rows = $query->get(); if (!$rows->isEmpty()) { $total = 0; foreach ($rows as $item) { if (!is_null($item->custom_fee)) { $total += $item->custom_fee; } else { $total += $item->fee; } } return $total; } else { return 0; } }
public function destroy($id) { Lead::destroy($id); return redirect('leads'); }
public function actionDelete($id) { Lead::findOne($id)->deleteRecursive(); Yii::$app->getSession()->setFlash("success", 'The record was deleted.'); return $this->redirect(["lead/"]); }