public function noteSociete($id, $back) { $notes = DB::table('societes')->join('contacts', 'societes.id', '=', 'contacts.societe_id')->join('notes', 'contacts.id', '=', 'notes.contact_id')->select('notes.*', 'contacts.nom_contact', 'societes.id AS ste')->where('societes.id', '=', $id)->where('notes.etat', '=', '1')->paginate(15); $actif = 'notes'; $profil = Societe::findOrFail($id); return View::make('notes.notes-societe', compact('notes', 'back', 'actif', 'profil')); }
$module = Module::select('prix_module')->findOrFail($id); $produit = Produit::select('nom_produit', 'vers_produit')->findOrFail($id_produit); $data['module']['prix_module'] = $module->prix_module; $data['produit']['id'] = $id_produit; $data['produit']['nom'] = 'Licence ' . $produit->nom_produit . ' Version ' . $produit->vers_produit; } return json_encode($data); }); /**** Ajax for others pages ***/ Route::get('/SocieteSelect', function () { if (Request::ajax()) { $id = Request::get('id'); if ($id == 0) { $contacts = Contact::select('id', 'nom_contact', 'prenoms_contact')->where('etat', 1)->get(); } else { $contacts = Societe::findOrFail($id)->contacts()->where('etat', 1)->get(); } if ($contacts->isEmpty()) { $data = []; } else { foreach ($contacts as $key => $value) { $data[$value->id] = $value->nom_contact . ' ' . $value->prenoms_contact; } } } return json_encode($data); }); Route::get('/ContactSelect', function () { if (Request::ajax()) { $id = Request::get('id'); $adresse = DB::table('contacts')->select('societe_id')->where('id', $id)->get();
| */ /* Test Page */ Route::get('test', function () { return view('test'); }); /* Home View Route */ Route::get('/', 'WelcomeController@index'); /* Societe & Contact Views Routes */ Route::post('societe/action', ['as' => 'societe.action', function () { $data = Request::all(); if (Request::input('supp')) { if ($data['type'] == 0) { foreach ($data as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Societe::findOrFail($value); var_dump($profil); dd(); $profil->update(['etat' => 0]); } return redirect(route('societe.index')); } // return redirect(route('societe.index')); } else { return 'suppression contact'; } } if (Request::input('export')) { if ($data['type'] == 0) { return 'export societe'; } else {
public function DeleteCheckedDocs(Request $request) { $i = 1; $data = $request->all(); if ($request->input('supp')) { if ($data['type'] == 0 || $data['type'] == 3) { foreach ($data as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Societe::findOrFail($value); $profil->update(['etat' => 0]); } } } elseif ($data['type'] == 1) { foreach ($data as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Contact::findOrFail($value); $profil->update(['etat' => 0]); } } } elseif ($data['type'] == 2) { foreach ($data as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Groupe::findOrFail($value); $profil->update(['etat' => 0]); } } } } // Import de contacts if ($request->input('export')) { Excel::create('ExportContact', function ($excel) { $excel->sheet('Sheetname', function ($sheet) { $donnees = Input::all(); $j = 0; if ($donnees['type'] == 0 || $donnees['type'] == 3) { foreach ($donnees as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Societe::findOrFail($value); $export[$key] = $profil; } } foreach ($export as $donnees) { $extract[$j] = ['Nom de la société' => $donnees->nom_clt, 'Effectif' => $donnees->effectif_clt, 'Chiffre d\'affaire' => $donnees->ca_clt, 'N° TVA' => $donnees->num_tva_clt, 'URL' => $donnees->url_clt, 'Téléphone' => $donnees->tel_siege_clt, 'Fax' => $donnees->fax_siege_clt, 'E-mail' => $donnees->email_siege_clt, 'Pays' => $donnees->pays_clt, 'Ville' => $donnees->ville_siege_clt, 'Adresse' => $donnees->adresse_siege_clt, 'Commentaire' => $donnees->comment_clt]; $j++; } } elseif ($donnees['type'] == 1) { foreach ($donnees as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Contact::with(['societe' => function ($query) { $query->with(['groupe'])->select('nom_clt', 'id', 'groupe_id'); }])->findOrFail($value); $export[$key] = $profil; } } foreach ($export as $donnees) { $extract[$j] = ['Civilité' => $donnees->genre_contact, 'Nom' => $donnees->nom_contact, 'Prénom' => $donnees->prenoms_contact, 'Société' => isset($donnees->societe->nom_clt) ? $donnees->societe->nom_clt : NULL, 'Groupe' => isset($donnees->societe->groupe->nom_groupe) ? $donnees->societe->groupe->nom_groupe . ' ' . $donnees->societe->groupe->date_groupe : NULL, 'Fonction' => $donnees->fonction_contact, 'Service' => $donnees->service_contact, 'Description' => $donnees->description_contact, 'Téléphone' => $donnees->tel_contact, 'E-mail' => $donnees->email_contact, 'Adresse' => $donnees->adresse_contact]; $j++; } } elseif ($donnees['type'] == 2) { foreach ($donnees as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Groupe::findOrFail($value)->societe()->where('etat', 1)->get(); foreach ($profil as $pkey => $pvalue) { $export[$key] = $pvalue; } } } var_dump($export); dd(); foreach ($export as $donnees) { $extract[$j] = ['Civilité' => $donnees->genre_contact, 'Nom' => $donnees->nom_contact, 'Prénom' => $donnees->prenoms_contact, 'Société' => isset($donnees->societe->nom_clt) ? $donnees->societe->nom_clt : NULL, 'Groupe' => isset($donnees->societe->groupe->nom_groupe) ? $donnees->societe->groupe->nom_groupe . ' ' . $donnees->societe->groupe->date_groupe : NULL, 'Fonction' => $donnees->fonction_contact, 'Service' => $donnees->service_contact, 'Description' => $donnees->description_contact, 'Téléphone' => $donnees->tel_contact, 'E-mail' => $donnees->email_contact, 'Adresse' => $donnees->adresse_contact]; $j++; } } $sheet->fromArray($extract); }); })->export('xls'); } // Import des contacts à partir du Groupe CRM if ($request->input('export')) { Excel::create('ExportContact', function ($excel) { $excel->sheet('Sheetname', function ($sheet) { $donnees = Input::all(); $j = 0; if ($donnees['type'] == 0) { foreach ($donnees as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Societe::findOrFail($value); $export[$key] = $profil; } } foreach ($export as $donnees) { $extract[$j] = ['Nom de la société' => $donnees->nom_clt, 'Effectif' => $donnees->effectif_clt, 'Chiffre d\'affaire' => $donnees->ca_clt, 'N° TVA' => $donnees->num_tva_clt, 'URL' => $donnees->url_clt, 'Téléphone' => $donnees->tel_siege_clt, 'Fax' => $donnees->fax_siege_clt, 'E-mail' => $donnees->email_siege_clt, 'Pays' => $donnees->pays_clt, 'Ville' => $donnees->ville_siege_clt, 'Adresse' => $donnees->adresse_siege_clt, 'Commentaire' => $donnees->comment_clt]; $j++; } } else { foreach ($donnees as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Contact::with(['societe' => function ($query) { $query->with(['groupe'])->select('nom_clt', 'id', 'groupe_id'); }])->findOrFail($value); $export[$key] = $profil; } } foreach ($export as $donnees) { $extract[$j] = ['Civilité' => $donnees->genre_contact, 'Nom' => $donnees->nom_contact, 'Prénom' => $donnees->prenoms_contact, 'Société' => isset($donnees->societe->nom_clt) ? $donnees->societe->nom_clt : NULL, 'Groupe' => isset($donnees->societe->groupe->nom_groupe) ? $donnees->societe->groupe->nom_groupe . ' ' . $donnees->societe->groupe->date_groupe : NULL, 'Fonction' => $donnees->fonction_contact, 'Service' => $donnees->service_contact, 'Description' => $donnees->description_contact, 'Téléphone' => $donnees->tel_contact, 'E-mail' => $donnees->email_contact, 'Adresse' => $donnees->adresse_contact]; $j++; } } $sheet->fromArray($extract); }); })->export('xls'); } // Ajout de note if ($request->input('add_note')) { if ($data['type'] == 0) { echo 'Bonjour nouvelle'; dd(); foreach ($data as $key => $value) { if (substr($key, 0, 1) == 'c') { $profil = Societe::findOrFail($value); $profil->update(['etat' => 0]); } } } else { echo 'Contact'; } } if ($data['type'] == 0) { return redirect(route('societe.index')); } else { return redirect(route('contact.index')); } }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { // $profil = Societe::findOrFail($id); $profil->update(['etat' => 0]); return redirect(route('societe.index')); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { // $contacts = Societe::findOrFail($id)->contacts()->select('id')->where('etat', 1)->get(); if (!empty($contacts->id)) { foreach ($contacts as $value) { $contact = Contact::findOrFail($value->id); $contact->update(['etat' => 0]); } foreach ($contact as $value) { $contact->update(['etat' => 0]); } } $profil = Societe::findOrFail($id); $profil->update(['etat' => 0]); return redirect(route('societe.index')); }