public function getAvaiableUserMetaDetails()
{
try {
$result = Usersmeta::join('users', function ($join) {
$join->on('usersmeta.user_id', '=', 'users.id');
})->join('location', function ($join) {
$join->on('location.location_id', '=', 'usersmeta.country');
})->select()->get();
return $result;
} catch (QueryException $e) {
echo $e;
}
}
public function supplierAjaxHandler(Request $request)
{
$inputData = $request->input();
$method = $request->input('method');
$ObjUser = User::getInstance();
$objModelLocation = Location::getInstance();
$ObjUsermeta = Usersmeta::getInstance();
if ($method) {
switch ($method) {
case 'availableSupplier':
$objuser = User::getInstance();
$where = array('rawQuery' => 'role = ?', 'bindParams' => [3]);
$available_supplier = $objuser->getAvailableSupplierDetails($where);
// echo"<pre>";print_r($available_supplier);die("gvj");
// foreach ($available_supplier as $key => $val) {
// $vail[$key] = $val->id;
// $available_supplier[$key] = $val;
// $available_supplier[$key]->usermeta = array();
// $available_supplier[$key] = $val;
// $available_supplier[$key]->filter = array();
// }
// $supplier = implode(",",$vail);
// echo"<pre>";print_r($supplier);die("cvjh");
// $whereuser = ['rawQuery' => 'user_id = ?', 'bindParams' => $vail];
// $usermetaInfo = $ObjUsermeta->getAvaiableUserMetaDetails();
// foreach($usermetaInfo as $keymeta => $valmeta){
// $usermetaInfo[$keymeta] = $valmeta;
//// $usermetaInfo[$keymeta]->filter = array();
// }
//
// if(!empty($usermetaInfo)){
//
// $available_supplier[$key]->usermeta = $usermetaInfo;
//
// }
// echo"<pre>";print_r($available_supplier);die("cvjh");
// echo"<pre>";print_r($usermetaInfo);die("cvjh");
//
// $whereuser = array('rawQuery' => 'user_id IN('.$supplier.')');
// $available_supplier[$key] = $usermetadescription;
//// echo"<pre>";print_r($available_customers);die("cvjh");
//
// $usermetaInfo = $ObjUsermeta->getAvaiableUserMetaDetails($whereuser);
// foreach ($usermetaInfo as $filtergroupkey => $filtergroupvalue) {
// $usermetaInfo[$filtergroupkey]->filtergroup = array();
// if ($filtergroupvalue->permission_ids != '') {
// $catfilterName = array_values(array_unique(explode(',', $filtergroupvalue->permission_ids)));
// $per = implode(",", $catfilterName);
// $where = ['rawQuery' => 'permission_id IN(' . $per . ')'];
// $getcategory = $objPermissionModel->getPermissionNameByIds($where);
//
// foreach ($getcategory as $catkey => $catval) {
// $availPermissionRelation[$filtergroupkey]->filter = $catval;
// $available_customers[$key]->filter = $availPermissionRelation[$filtergroupkey]->filter;
// }
// $available_supplier[$key]->filter = $usermetaInfo[$filtergroupkey]->filtergroup;
//
// }
// }
// echo"<pre>";print_r($available_supplier);die("gvj");
return Datatables::of($available_supplier)->addColumn('action', function ($available_supplier) {
$action = '<span class="tooltips" title="Edit Supplier Details." data-placement="top"> <a href="/admin/edit-supplier/' . $available_supplier->id . '" class="btn btn-sm grey-cascade" style="margin-left: 10%;">';
$action .= '<i class="fa fa-pencil-square-o"></i></a>';
$action .= '</span> ';
$action .= '<span class="tooltips" title="Delete Supplier Details." data-placement="top"> <a href="#" data-cid="' . $available_supplier->id . '" class="btn btn-danger delete-supplier" style="margin-left: 10%;">';
$action .= '<i class="fa fa-trash-o"></i>';
$action .= '</a></span>';
return $action;
})->addColumn('status', function ($available_supplier) {
$button = '<td style="text-align: center">';
$button .= '<button class="btn ' . ($available_supplier->status == 1 ? "btn-success" : "btn-danger") . ' supplier-status" data-id="' . $available_supplier->id . '">' . ($available_supplier->status == 1 ? "Active" : "Inactve") . ' </button>';
$button .= '<td>';
return $button;
})->addColumn('supplierdetail', function ($available_supplier) {
return '<td style = "text-align: center" ><div class="container" style = "width: 50px " >
<span class="tooltips" title = "Review Description." data-placement = "top" ><button data-id = "' . $available_supplier->id . '" type = "button" class="btn btn-sm btn-default modaldescription" data-toggle = "modal" data-target = "#mymodel" ><i class="fa fa-expand" ></i ></button ></span >
</div >
</td >';
})->removeColumn('name')->removeColumn('updated_at')->make();
break;
case 'pendingSupplier':
$objuser = User::getInstance();
$where = array('rawQuery' => 'role = ? and status = ?', 'bindParams' => [3, 0]);
// $status = array('rawQuery' => 'status = ?', 'bindParams' => [0]);
$pending_supplier = $objuser->getPendingUserDetails($where);
return Datatables::of($pending_supplier)->addColumn('status', function ($pending_supplier) {
return ' < td style = "text-align: center" >
<button class="btn btn-primary customer-status"
data - id = ' . $pending_supplier->id . ' > Pending
</button >
</td > ';
})->removeColumn('name')->removeColumn('updated_at')->make();
break;
case 'deletedSupplier':
$objuser = User::getInstance();
$where = array('rawQuery' => 'role = ?', 'bindParams' => [3]);
$status = array('rawQuery' => 'status = ?', 'bindParams' => [4]);
$deleted_supplier = $objuser->getDeletedUserDetails($where, $status);
return Datatables::of($deleted_supplier)->addColumn('status', function ($deleted_supplier) {
return ' < td style = "text-align: center" >
<button class="btn btn-primary customer-status"
data - id = ' . $deleted_supplier->id . ' > Deleted
</button >
</td > ';
})->removeColumn('name')->removeColumn('updated_at')->make();
break;
case 'changeSupplierStatus':
$userId = $inputData['UserId'];
$whereForUpdate = ['rawQuery' => 'id =?', 'bindParams' => [$userId]];
$dataToUpdate['status'] = $inputData['status'];
$updateResult = $ObjUser->updateUserWhere($dataToUpdate, $whereForUpdate);
if ($updateResult == 1) {
echo json_encode(['status' => 'success', 'msg' => 'Status has been changed . ']);
} else {
echo json_encode(['status' => 'error', 'msg' => 'Something went wrong, please reload the page and try again . ']);
}
break;
case 'deleteSupplierStatus':
$userId = $inputData['UserId'];
$where = ['rawQuery' => 'id = ?', 'bindParams' => [$userId]];
$deleteStatus = $ObjUser->deleteUserDetails($where);
if ($deleteStatus) {
echo json_encode(['status' => 'success', 'msg' => 'User Deleted']);
} else {
echo json_encode(['status' => 'error', 'msg' => 'Something went wrong, please reload the page and try again . ']);
}
break;
case "locationinfo":
$where = ['rawQuery' => 'location_type = ?', 'bindParams' => [0]];
$locationdetail = $objModelLocation->getAllCountryDetails($where);
echo json_encode($locationdetail);
break;
case 'stateInfoByLocation':
$countryId = $request->input('countryId');
$where = array('rawQuery' => 'parent_id = ? and location_type = ?', 'bindParams' => [$countryId, 1]);
$stateInfo = $objModelLocation->getStateByCountryId($where);
echo json_encode($stateInfo);
break;
case 'cityInfoByLocation':
$countryId = $request->input('countryId');
$where = array('rawQuery' => 'parent_id = ? and location_type = ?', 'bindParams' => [$countryId, 1]);
$cityInfo = $objModelLocation->getCityByCountryId($where);
echo json_encode($cityInfo);
break;
case 'getUsermetaInfoByUserId':
$UserId = $request->input('UserId');
$where = array('rawQuery' => 'user_id = ?', 'bindParams' => [$UserId]);
$selectedColumns = ['location.*', 'usersmeta.addressline1', 'usersmeta.addressline2', 'usersmeta.city', 'usersmeta.state', 'usersmeta.zipcode', 'usersmeta.phone', 'usersmeta.user_id'];
$userMetaInfo = $ObjUsermeta->getUserMetaInfoByUserId($where, $selectedColumns);
// echo"<pre>";print_r($userMetaInfo);die("Cfh");
echo json_encode($userMetaInfo);
break;
default:
break;
}
}
}
