Viewing file:  ContactController.php (10.09 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Http\Controllers\Customer;
use App\Http\Controllers\Controller;
use App\Imports\ContactsImport;
use App\Models\Contact;
use App\Models\Group;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\WithCustomCsvSettings;
use Maatwebsite\Excel\Facades\Excel;
class ContactController extends Controller
{
public function create()
{
$current_plan = auth('customer')->user()->plan;
if (!$current_plan)
return back()->with('fail', 'Doesn\'t have any plan right now');
$contacts= auth('customer')->user()->contacts()->count();
$planContactLimit= $current_plan->contact_limit;
if ($contacts >= $planContactLimit){
return back()->with('fail', 'Doesn\'t have enough contact limit');
}
return view('customer.contacts.create');
}
public function index()
{
return view('customer.contacts.index');
}
public function import_contacts()
{
return view('customer.contacts.import_create');
}
public function getAll()
{
$contacts = auth('customer')->user()->contacts()->select(['id', 'first_name', 'last_name', 'email', 'company', 'address', 'zip_code', 'city', 'state', 'note']);
return datatables()->of($contacts)
->addColumn('action', function ($q) {
return "<a class='btn btn-sm btn-info' href='" . route('customer.contacts.edit', [$q->id]) . "'>Edit</a> " .
'<button class="btn btn-sm btn-danger" data-message="Are you sure you want to delete this contact?"
data-action=' . route('customer.contacts.destroy', [$q]) . '
data-input={"_method":"delete"}
data-toggle="modal" data-target="#modal-confirm">Delete</button>';
})
->addColumn('name', function ($q) {
return $q->first_name . ' ' . $q->last_name;
})
->rawColumns(['action'])
->toJson();
}
public function store(Request $request)
{
$request->validate([
'email' => 'required'
]);
$current_plan = auth('customer')->user()->plan;
if (!$current_plan)
return redirect()->route('customer.contacts.index')->with('fail', 'Doesn\'t have any plan right now');
$contacts= auth('customer')->user()->contacts()->count();
$planContactLimit= $current_plan->contact_limit;
if ($contacts >= $planContactLimit){
return redirect()->route('customer.contacts.index')->with('fail', 'Doesn\'t have enough contact limit');
}
$contact = auth('customer')->user()->contacts()->create($request->all());
setActivity(auth('customer')->user()->id, 'add', 'contact', $contact->id, 'New Contact Created');
return redirect()->route('customer.contacts.index')->with('success', 'Contact successfully added');
}
public function edit(Contact $contact)
{
$data['contact'] = $contact;
return view('customer.contacts.edit', $data);
}
public function update(Contact $contact, Request $request)
{
$request->validate([
'email' => 'required',
]);
$valid_data = $request->only('first_name', 'last_name', 'email', 'company', 'forward_to', 'forward_to_dial_code', 'address', 'zip_code', 'city', 'state', 'note');
//update the model
$contact->update($valid_data);
setActivity(auth('customer')->user()->id, 'edit', 'contact', $contact->id, 'Contact Updated');
return back()->with('success', 'Contact successfully updated');
}
public function destroy(Contact $contact)
{
$contact->delete();
setActivity(auth('customer')->user()->id, 'delete', 'contact', $contact->id, 'Contact Deleted');
return back()->with('success', 'Contact successfully deleted');
}
public function import_contacts_show(Request $request)
{
$request->validate([
'import_contact_csv' => 'required|mimes:csv,txt'
]);
$import_contact_data = Excel::toArray(new class implements ToCollection,WithCustomCsvSettings {
public function collection(\Illuminate\Support\Collection $rows)
{
return $rows;
}
public function getCsvSettings(): array
{
return [
'input_encoding' => 'ISO-8859-1'
];
}
}, $request->file('import_contact_csv')
);
$import_contact_contact_array = [];
unset($import_contact_data[0][0]);
foreach (array_slice($import_contact_data[0],0,10) as $data) {
$import_contact_contact_array[] = [
'email' => $data[0],
'first_name' => $data[1],
'last_name' => $data[2],
'address' => $data[3],
'city' => $data[4],
'state' => $data[5],
'zip_code' => $data[6],
'company' => $data[7],
'note' => $data[8],
'full_name' => $data[1] . ' ' . $data[2],
];
}
return response()->json(['status' => 'success', 'data' => $import_contact_contact_array]);
}
public function import_contacts_store(Request $request)
{
$request->validate([
'import_name' => 'required',
'import_contact_csv' => 'required|mimes:csv,txt'
]);
DB::beginTransaction();
try {
$preGroup = auth('customer')->user()->groups()->where('name', $request->import_name)->first();
if ($preGroup) return back()->withErrors(['msg' => "Import name already exists"]);
$importContact = new Group();
$importContact->customer_id = auth('customer')->id();
$importContact->name = $request->import_name;
$importContact->save();
setActivity(auth('customer')->user()->id, 'add', 'contact_group', $importContact->id, 'Contact Group Created');
if ($request->hasFile('import_contact_csv')) {
$data = $request->file('import_contact_csv');
$fileName = $importContact->id . '.' . $data->getClientOriginalExtension();
$data->move(public_path() . '/uploads', $fileName);
$file_url = public_path() . '/uploads/' . $fileName;
$fp = file($file_url);
$contacts = auth('customer')->user()->contacts()->count();
$importedContact = (count($fp) - 1) + $contacts;
$current_plan = auth('customer')->user()->plan;
if (!$current_plan)
return redirect()->route('customer.contacts.index')->with('fail', 'Doesn\'t have any plan right now');
$planContactLimit = $current_plan->contact_limit;
if ($importedContact >= $planContactLimit) {
return redirect()->route('customer.contacts.index')->with('fail', 'Doesn\'t have enough contact limit');
}
try {
Excel::import(new ContactsImport($importContact->id, auth('customer')->user()), $file_url);
DB::commit();
} catch (\Exception $ex) {
if (isset($ex->validator)) {
return redirect()->back()->withErrors($ex->validator->errors());
} else {
return redirect()->back()->withErrors(['msg' => $ex->getMessage()]);
}
}
}
}catch (\Exception $ex) {
Log::error($ex);
DB::rollBack();
return back()->with('fail', $ex->getMessage());
}
return back()->with('success', 'Import Contact Successfully Created');
}
public function search(Request $request)
{
$contacts = auth('customer')->user()->contacts();
$contactsForCount=auth('customer')->user()->contacts();
if ($request->ajax())
{
$page = $request->page;
$resultCount = 25;
$offset = ($page - 1) * $resultCount;
if ($request->search) {
$contacts->where('email', 'like', "%" . $request->search . "%")
->orWhere('first_name', 'like', "%" . $request->search . "%")
->orWhere('zip_code', 'like', "%" . $request->search . "%")
->orWhere('address', 'like', "%" . $request->search . "%")
->orWhere('last_name', 'like', "%" . $request->search . "%");
$contactsForCount->where('email', 'like', "%" . $request->search . "%")
->orWhere('first_name', 'like', "%" . $request->search . "%")
->orWhere('zip_code', 'like', "%" . $request->search . "%")
->orWhere('address', 'like', "%" . $request->search . "%")
->orWhere('last_name', 'like', "%" . $request->search . "%");
}
$results=$contacts->skip($offset)->take($resultCount)->get();
$count = $contactsForCount->count();
$endCount = $offset + $resultCount;
$morePages = $count > $endCount;
$finalResults = [];
foreach ($results as $contact) {
$finalResults[] = [
'id' => $contact->id,
'text' => $contact->email.' '.($contact->first_name?'('.$contact->first_name.' '.$contact->last_name.')':'')
];
}
$results = array(
"results" => $finalResults,
"pagination" => array(
"more" => $morePages
)
);
return response()->json($results);
}
}
}
|