public function run()
{
// Initialize empty array
$license_seats = array();
$date = new DateTime();
$license_seats[] = array('license_id' => '1', 'assigned_to' => '1', 'created_at' => $date->modify('-10 day')->format('Y-m-d H:i:s'), 'updated_at' => $date->modify('-3 day')->format('Y-m-d H:i:s'), 'deleted_at' => NULL, 'notes' => '', 'user_id' => '1', 'asset_id' => '1');
$license_seats[] = array('license_id' => '1', 'assigned_to' => '1', 'created_at' => $date->modify('-10 day')->format('Y-m-d H:i:s'), 'updated_at' => $date->modify('-3 day')->format('Y-m-d H:i:s'), 'deleted_at' => NULL, 'notes' => '', 'user_id' => '1', 'asset_id' => '2');
$license_seats[] = array('license_id' => '1', 'assigned_to' => '1', 'created_at' => $date->modify('-10 day')->format('Y-m-d H:i:s'), 'updated_at' => $date->modify('-3 day')->format('Y-m-d H:i:s'), 'deleted_at' => NULL, 'notes' => '', 'user_id' => '1', 'asset_id' => '3');
$license_seats[] = array('license_id' => '1', 'assigned_to' => NULL, 'created_at' => $date->modify('-10 day')->format('Y-m-d H:i:s'), 'updated_at' => $date->modify('-3 day')->format('Y-m-d H:i:s'), 'deleted_at' => NULL, 'notes' => '', 'user_id' => '1', 'asset_id' => NULL);
$license_seats[] = array('license_id' => '1', 'assigned_to' => '1', 'created_at' => $date->modify('-10 day')->format('Y-m-d H:i:s'), 'updated_at' => $date->modify('-3 day')->format('Y-m-d H:i:s'), 'deleted_at' => NULL, 'notes' => '', 'user_id' => '1', 'asset_id' => NULL);
$license_seats[] = array('license_id' => '2', 'assigned_to' => '1', 'created_at' => $date->modify('-10 day')->format('Y-m-d H:i:s'), 'updated_at' => $date->modify('-3 day')->format('Y-m-d H:i:s'), 'deleted_at' => NULL, 'notes' => '', 'user_id' => '1', 'asset_id' => NULL);
$license_seats[] = array('license_id' => '2', 'assigned_to' => NULL, 'created_at' => $date->modify('-10 day')->format('Y-m-d H:i:s'), 'updated_at' => $date->modify('-3 day')->format('Y-m-d H:i:s'), 'deleted_at' => NULL, 'notes' => '', 'user_id' => '1', 'asset_id' => NULL);
// Delete all the old data
DB::table('license_seats')->truncate();
// Insert the new posts
LicenseSeat::insert($license_seats);
}
public function freeSeat()
{
$seat = LicenseSeat::where('license_id', '=', $this->id)->whereNull('deleted_at')->whereNull('assigned_to')->whereNull('asset_id')->first();
return $seat->id;
}
public function approve()
{
//check the users group
$authorizers = Sentry::findGroupByName('Authorizers');
$admins = Sentry::findGroupByName('Admin');
//DLN authorizers
if (Sentry::getUser()->inGroup($authorizers)) {
$this->request_code = 1;
$this->save();
return array('success' => 1, 'message' => 'Request Approved', 'type' => $this->type);
} elseif (Sentry::getUser()->inGroup($admins)) {
//get all license types for request
$lcnsNames = $this->licenseTypes()->lists('name');
//get available license seats for each license type
$that = $this;
$toAdd = [];
if ($this->type == 'license') {
//TODO:: remove and place in seperate method - this will need to be used to update a request
foreach ($lcnsNames as $lcnsName) {
$lcnsSeat = DB::table('licenses')->join('license_types', 'licenses.type_id', '=', 'license_types.id')->join('license_seats', 'licenses.id', '=', 'license_seats.license_id')->orwhere(function ($query) use($lcnsName, $that) {
$query->where('license_types.name', '=', $lcnsName)->where('licenses.role_id', $that->role_id)->whereNull('license_seats.assigned_to');
})->first();
//if seats available add it to array for later processing, else return with error message
if ($lcnsSeat) {
$toAdd[$lcnsName] = $lcnsSeat;
} else {
$messageKey = str_replace(' ', '', strtolower($lcnsName));
$error = Lang::get('request.message_no_lcns.' . $lcnsName);
return array('success' => 0, 'message' => $error);
}
}
foreach ($toAdd as $key => $lcnsSeat) {
if ($key == 'SABA Publisher') {
//create computer name as an asset if it doesnt exist
if ($obj = DB::table('assets')->where('serial', $this->pc_name)->first(array('id'))) {
$asset = Asset::find($obj->id);
} else {
$asset = new Asset();
$asset->name = "DWAN PC";
$asset->serial = $this->pc_name;
$asset->asset_tag = $this->pc_name;
$asset->model_id = 7;
//TODO: Remove this hard coding for model id
$asset->status_id = 1;
$asset->assigned_to = $this->account->id;
}
$asset->role_id = $this->role_id;
$asset->save();
License::checkOutToAsset($lcnsSeat->id, $asset->id);
}
//checkout to account the request has been made for
License::checkOutToAccount($lcnsSeat->id, $this->account_id);
}
} elseif ($this->type == 'checkin') {
//clear license fields
$seat = LicenseSeat::find($this->license_id);
$seat->checkIn();
}
//detach requested licenses
$this->licenseTypes()->detach();
$type = $this->type;
//marked as closed
$this->delete();
return array('success' => 1, 'message' => 'Request Approved', 'type' => $type);
}
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$filename = $this->argument('filename');
if (!$this->option('testrun') == 'true') {
$this->comment('======= Importing Licenses from ' . $filename . ' =========');
} else {
$this->comment('====== TEST ONLY License Import for ' . $filename . ' ====');
$this->comment('============== NO DATA WILL BE WRITTEN ==============');
}
if (!ini_get("auto_detect_line_endings")) {
ini_set("auto_detect_line_endings", '1');
}
$csv = Reader::createFromPath($this->argument('filename'));
$csv->setNewline("\r\n");
$csv->setOffset(1);
$duplicates = '';
// Loop through the records
$nbInsert = $csv->each(function ($row) use($duplicates) {
$status_id = 1;
// Let's just map some of these entries to more user friendly words
if (array_key_exists('0', $row)) {
$user_name = trim($row[0]);
} else {
$user_name = '';
}
if (array_key_exists('1', $row)) {
$user_email = trim($row[1]);
} else {
$user_email = '';
}
if (array_key_exists('2', $row)) {
$user_username = trim($row[2]);
} else {
$user_username = '';
}
if (array_key_exists('3', $row)) {
$user_license_name = trim($row[3]);
} else {
$user_license_name = '';
}
if (array_key_exists('4', $row)) {
$user_license_serial = trim($row[4]);
} else {
$user_license_serial = '';
}
if (array_key_exists('5', $row)) {
$user_licensed_to_name = trim($row[5]);
} else {
$user_licensed_to_name = '';
}
if (array_key_exists('6', $row)) {
$user_licensed_to_email = trim($row[6]);
} else {
$user_licensed_to_email = '';
}
if (array_key_exists('7', $row)) {
$user_license_seats = trim($row[7]);
} else {
$user_license_seats = '';
}
if (array_key_exists('8', $row)) {
$user_license_reassignable = trim($row[8]);
if ($user_license_reassignable != '') {
if (strtolower($user_license_reassignable) == 'yes' || strtolower($user_license_reassignable) == 'true' || $user_license_reassignable == '1') {
$user_license_reassignable = 1;
}
} else {
$user_license_reassignable = 0;
}
} else {
$user_license_reassignable = 0;
}
if (array_key_exists('9', $row)) {
$user_license_supplier = trim($row[9]);
} else {
$user_license_supplier = '';
}
if (array_key_exists('10', $row)) {
$user_license_maintained = trim($row[10]);
if ($user_license_maintained != '') {
if (strtolower($user_license_maintained) == 'yes' || strtolower($user_license_maintained) == 'true' || $user_license_maintained == '1') {
$user_license_maintained = 1;
}
} else {
$user_license_maintained = 0;
}
} else {
$user_license_maintained = '';
}
if (array_key_exists('11', $row)) {
$user_license_notes = trim($row[11]);
} else {
$user_license_notes = '';
}
if (array_key_exists('12', $row)) {
if ($row[12] != '') {
$user_license_purchase_date = date("Y-m-d 00:00:01", strtotime($row[12]));
} else {
$user_license_purchase_date = '';
}
} else {
$user_license_purchase_date = 0;
}
// A number was given instead of a name
if (is_numeric($user_name)) {
$this->comment('User ' . $user_name . ' is not a name - assume this user already exists');
$user_username = '';
// No name was given
} elseif ($user_name == '') {
$this->comment('No user data provided - skipping user creation, just adding license');
$first_name = '';
$last_name = '';
$user_username = '';
} else {
$name = explode(" ", $user_name);
$first_name = $name[0];
$email_last_name = '';
$email_prefix = $first_name;
if (!array_key_exists(1, $name)) {
$last_name = '';
$email_last_name = $last_name;
$email_prefix = $first_name;
} else {
$last_name = str_replace($first_name, '', $user_name);
if ($this->option('email_format') == 'filastname') {
$email_last_name .= str_replace(' ', '', $last_name);
$email_prefix = $first_name[0] . $email_last_name;
} elseif ($this->option('email_format') == 'firstname.lastname') {
$email_last_name .= str_replace(' ', '', $last_name);
$email_prefix = $first_name . '.' . $email_last_name;
} elseif ($this->option('email_format') == 'firstname') {
$email_last_name .= str_replace(' ', '', $last_name);
$email_prefix = $first_name;
}
}
$user_username = $email_prefix;
// Generate an email based on their name if no email address is given
if ($user_email == '') {
if ($first_name == 'Unknown') {
$status_id = 7;
}
$email = strtolower($email_prefix) . '@' . $this->option('domain');
$user_email = str_replace("'", '', $email);
}
}
$this->comment('Full Name: ' . $user_name);
$this->comment('First Name: ' . $first_name);
$this->comment('Last Name: ' . $last_name);
$this->comment('Username: '******'Email: ' . $user_email);
$this->comment('License Name: ' . $user_license_name);
$this->comment('Serial No: ' . $user_license_serial);
$this->comment('Licensed To Name: ' . $user_licensed_to_name);
$this->comment('Licensed To Email: ' . $user_licensed_to_email);
$this->comment('Seats: ' . $user_license_seats);
$this->comment('Reassignable: ' . $user_license_reassignable);
$this->comment('Supplier: ' . $user_license_supplier);
$this->comment('Maintained: ' . $user_license_maintained);
$this->comment('Notes: ' . $user_license_notes);
$this->comment('Purchase Date: ' . $user_license_purchase_date);
$this->comment('------------- Action Summary ----------------');
if ($user_username != '') {
if ($user = User::where('username', $user_username)->whereNotNull('username')->first()) {
$this->comment('User ' . $user_username . ' already exists');
} else {
// Create the user
$user = Sentry::createUser(array('first_name' => $first_name, 'last_name' => $last_name, 'email' => $user_email, 'username' => $user_username, 'password' => substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 10), 'activated' => true, 'permissions' => array('admin' => 0, 'user' => 1), 'notes' => 'User importerd through license importer'));
// Find the group using the group id
$userGroup = Sentry::findGroupById(3);
// Assign the group to the user
$user->addGroup($userGroup);
$this->comment('User ' . $first_name . ' created');
}
} else {
$user = new User();
$user->user_id = NULL;
}
// Check for the supplier match and create it if it doesn't exist
if ($supplier = Supplier::where('name', $user_license_supplier)->first()) {
$this->comment('Supplier ' . $user_license_supplier . ' already exists');
} else {
$supplier = new Supplier();
$supplier->name = e($user_license_supplier);
$supplier->user_id = 1;
if ($supplier->save()) {
$this->comment('Supplier ' . $user_license_supplier . ' was created');
} else {
$this->comment('Something went wrong! Supplier ' . $user_license_supplier . ' was NOT created');
}
}
// Add the license
$license = new License();
$license->name = e($user_license_name);
if ($user_license_purchase_date != '') {
$license->purchase_date = $user_license_purchase_date;
} else {
$license->purchase_date = NULL;
}
$license->serial = e($user_license_serial);
$license->seats = e($user_license_seats);
$license->supplier_id = $supplier->id;
$license->user_id = 1;
if ($user_license_purchase_date != '') {
$license->purchase_date = $user_license_purchase_date;
} else {
$license->purchase_date = NULL;
}
$license->license_name = $user_licensed_to_name;
$license->license_email = $user_licensed_to_email;
$license->notes = e($user_license_notes);
if ($license->save()) {
$this->comment('License ' . $user_license_name . ' with serial number ' . $user_license_serial . ' was created');
$license_seat_created = 0;
for ($x = 0; $x < $user_license_seats; $x++) {
// Create the license seat entries
$license_seat = new LicenseSeat();
$license_seat->license_id = $license->id;
$license_seat->assigned_to = $user->id;
if ($license_seat->save()) {
$license_seat_created++;
}
}
if ($license_seat_created > 0) {
$this->comment($license_seat_created . ' seats were created');
} else {
$this->comment('Something went wrong! NO seats for ' . $user_license_name . ' were created');
}
} else {
$this->comment('Something went wrong! License ' . $user_license_name . ' was NOT created');
}
$this->comment('=====================================');
return true;
});
}
/**
* Get the number of assigned seats
*
*/
public function assignedcount()
{
return LicenseSeat::where('license_id', '=', $this->id)->where(function ($query) {
$query->whereNotNull('assigned_to')->orWhereNotNull('asset_id');
})->count();
}
public static function getByRole($roleId)
{
$licenses = DB::table('licenses')->join('license_seats', 'licenses.id', '=', 'license_seats.license_id')->where('licenses.role_id', $roleId)->orderBy('license_seats.updated_at', 'DESC')->orderBy('name', 'ASC')->select('licenses.name', 'license_seats.*')->get();
$lcnsObj = array();
foreach ($licenses as $key => $lcns) {
$lcnsObj[$key] = new \stdClass();
$lcnsObj[$key]->id = $lcns->id;
$lcnsObj[$key]->name = $lcns->name;
$lcnsObj[$key]->assignedUser = '';
$lcnsObj[$key]->assignedAsset = '';
$lcnsObj[$key]->request = '';
$lcnsObj[$key]->updatedAt = $lcns->updated_at;
//get assigned user and assigned asset, if applicable
$seat = LicenseSeat::find($lcns->id);
if ($user = $seat->account) {
$lcnsObj[$key]->assignedUser = $user->first_name . " " . $user->last_name;
}
if ($asset = $seat->asset) {
$lcnsObj[$key]->assignedAsset = $asset->name . " - " . $asset->asset_tag;
}
if ($request = $seat->request) {
if ($request->request_code != 2) {
$lcnsObj[$key]->request = $request;
}
}
}
return $lcnsObj;
}
