public static function upload($filepath)
{
\DB::beginTransaction();
try {
$reader = ReaderFactory::create(Type::XLSX);
// for XLSX files
$reader->open($filepath);
$cnt = 0;
Store::where('active', 1)->update(['active' => 0]);
foreach ($reader->getSheetIterator() as $sheet) {
foreach ($sheet->getRowIterator() as $row) {
if ($cnt > 0) {
// dd($row);
$area = Area::firstOrCreate(['area' => strtoupper($row[0])]);
$enrollment = Enrollment::firstOrCreate(['enrollment' => strtoupper($row[1])]);
$distributor = Distributor::firstOrCreate(['distributor_code' => strtoupper($row[2]), 'distributor' => strtoupper($row[3])]);
$client = Client::firstOrCreate(['client_code' => strtoupper($row[8]), 'client_name' => strtoupper($row[9])]);
$channel = Channel::firstOrCreate(['channel_code' => strtoupper($row[10]), 'channel_desc' => strtoupper($row[11])]);
$agency = Agency::firstOrCreate(['agency_code' => strtoupper($row[19]), 'agency_name' => strtoupper($row[20])]);
$region = Region::firstOrCreate(['region_code' => strtoupper($row[16]), 'region' => strtoupper($row[15]), 'region_short' => strtoupper($row[14])]);
$customer = Customer::firstOrCreate(['customer_code' => strtoupper($row[12]), 'customer_name' => strtoupper($row[13])]);
$user = User::where('username', strtoupper($row[22]))->first();
if (empty($user) && !empty($row[22])) {
// dd($row);
$user = User::firstOrCreate(['username' => strtoupper($row[22]), 'name' => strtoupper($row[22]), 'email' => strtoupper($row[22]) . '@pcount.com', 'password' => \Hash::make($row[22])]);
$user->roles()->attach(2);
}
$storeExist = Store::where('store_code', strtoupper($row[5]))->first();
if (empty($storeExist) && !empty($row[22])) {
$store = Store::create(['storeid' => strtoupper($row[4]), 'store_code' => strtoupper($row[5]), 'store_code_psup' => strtoupper($row[6]), 'store_name' => strtoupper($row[7]), 'area_id' => $area->id, 'enrollment_id' => $enrollment->id, 'distributor_id' => $distributor->id, 'client_id' => $client->id, 'channel_id' => $channel->id, 'customer_id' => $customer->id, 'region_id' => $region->id, 'agency_id' => $agency->id, 'active' => 1]);
if (!empty($row[22])) {
StoreUser::insert(['store_id' => $store->id, 'user_id' => $user->id]);
}
} else {
$storeExist->storeid = strtoupper($row[4]);
$storeExist->store_code = strtoupper($row[5]);
$storeExist->store_code_psup = strtoupper($row[6]);
$storeExist->store_name = strtoupper($row[7]);
$storeExist->area_id = $area->id;
$storeExist->enrollment_id = $enrollment->id;
$storeExist->distributor_id = $distributor->id;
$storeExist->client_id = $client->id;
$storeExist->channel_id = $channel->id;
$storeExist->customer_id = $customer->id;
$storeExist->region_id = $region->id;
$storeExist->agency_id = $agency->id;
$storeExist->active = 1;
$storeExist->save();
StoreUser::where('store_id', $storeExist->id)->delete();
StoreUser::insert(['store_id' => $storeExist->id, 'user_id' => $user->id]);
}
}
$cnt++;
}
}
\DB::commit();
} catch (Exception $e) {
dd($e);
\DB::rollback();
}
}
public function login($username = '', $password = '', $remember = '')
{
$user = $this->find($username);
if (!$username && !$password && $this->exists()) {
Session::put($this->_sessionName, $this->data()->id);
} else {
$this->find($username);
if ($user) {
if ($this->data()->password === Hash::make($password)) {
Session::put($this->_sessionName, $this->data()->id);
if ($remember) {
$hash = Hash::unique();
$hashCheck = $this->_db->get('users_session', ['user_id', '=', $this->data()->id]);
if (!$hashCheck->count()) {
$this->_db->insert('users_session', ['user_id' => $this->data()->id, 'hash' => $hash]);
} else {
$hash = $hashCheck->first()->hash;
}
Cookie::put($this->_cookieName, $hash, Config::get('remember/cookie_expiry'));
}
return true;
}
}
}
return false;
}
function saving($model)
{
if (Hash::needsRehash($model->password)) {
$hashed = Hash::make($model->password);
$model->password = $hashed;
}
}
public function save($options = [])
{
if ($this->isDirty()) {
$changed = $this->getDirty();
if ($changed['password']) {
$this->password = \Hash::make($changed['password']);
}
}
parent::save($options);
}
public function setAPIAccessToken()
{
$user = null;
do {
$code = md5(\Hash::make($this->id . $this->email . $this->password . time() . mt_rand()));
$user = static::whereApiAccessToken($code)->first();
} while (isset($user));
$this->api_access_token = $code;
return $code;
}
public static function addOrModify($data, $id = null)
{
$d = parent::addOrModify($data, $id);
$d->nama = $data['nama'];
$d->password = \Hash::make($data['password']);
$d->username = $data['username'];
$d->email = $data['email'];
$d->role_id = $data['role_id'];
$d->save();
}
/**
* This method will set model values
*
* @param array $attributes
*/
public function fill(array $attributes)
{
parent::fill($attributes);
if (!empty($attributes)) {
if ($this->id == NULL) {
// ok this is new member, so we need password for it
$this->password = \Hash::make($attributes['passwd']);
} else {
// updating admin
if (!empty($attributes['changePassword']) && $attributes['changePassword'] == 1) {
$this->password = \Hash::make($attributes['passwd']);
}
}
}
}
public function getRequestArray($request)
{
return array('first_name' => $request->first_name, 'last_name' => $request->last_name, 'email' => $request->email, 'password' => \Hash::make($request->password));
}
public function setPasswordAttribute($password)
{
$this->attributes['password'] = \Hash::make($password);
}
public function getRequestArraySignUp($request)
{
return array('first_name' => $request->first_name, 'last_name' => $request->last_name, 'company' => $request->company, 'client_url' => $request->client_url, 'email' => $request->email, 'password' => \Hash::make($request->password));
}
public function setPasswordAttribute($value)
{
if ($value) {
$this->attributes['password'] = \Hash::make($value);
}
}
