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/"]);
}
