public function index()
{
$companies = Company::paginate($this->pageElements);
return view('site.index', ['companies' => $companies]);
}
public function activate($id)
{
$company = Company::findOrFail($id);
$company->status = 'ACTIVE';
$company->save();
$date = new \DateTime();
DB::table('users')->where('company_id', $id)->update(array('status' => 'ACTIVE', 'active_date' => $date));
\Session::flash('message', 'You have successfully activated ' . $company->name);
$keyword = '';
$companies = Company::paginate(15);
return view('company.list', compact('companies', 'keyword'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$company = Company::paginate();
return view('settings.companys.index', compact('company'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function delete($id)
{
$company = Company::findOrFail($id);
//goals
DB::table('goal_managements')->whereIn('user_id', function ($query) use($company) {
$query->select('id')->from('users')->whereRaw('users.company_id = ?', array($company->id));
})->delete();
//points
DB::table('points')->where('company_id', '=', $company->id)->delete();
//points_audit
DB::table('point_audits')->where('company_id', '=', $company->id)->delete();
//sales
DB::table('sales')->where('company_id', '=', $company->id)->delete();
//sales_audits
DB::table('sale_audits')->where('company_id', '=', $company->id)->delete();
//user_passwords
DB::table('user_passwords')->whereIn('user_id', function ($query) use($company) {
$query->select('id')->from('users')->whereRaw('users.company_id = ?', array($company->id));
})->delete();
//users
DB::table('users')->where('company_id', '=', $company->id)->delete();
//company
DB::table('companies')->where('id', '=', $company->id)->delete();
\Session::flash('message', 'You have successfully delete ' . $company->name);
$keyword = '';
$companies = Company::paginate(15);
return view('company.list', compact('companies', 'keyword'));
}
public function index()
{
return view('company.index', ['companies' => \App\Company::paginate(10)]);
}
/**
* Get all of the companies
*
* @return Collection
*/
public function getAll()
{
return Company::paginate(15);
}
