/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$qb = \GoProp\Models\User::orderBy('id', 'ASC');
$qb->whereHas('roles', function ($query) {
$query->where('slug', 'agent');
});
$agents = $qb->get();
foreach ($agents as $idx => $agent) {
$agent->username = time() + $idx;
$agent->save();
$agent->username = \GoProp\Facades\AgentHelper::formatAgentCode($idx + 1);
$agent->save();
}
}
public function getNextAgentCode()
{
$prefix = 'agent';
$qb = User::orderBy('username', 'DESC');
$qb->whereHas('roles', function ($query) {
$query->where('slug', 'agent');
});
$lastAgent = $qb->first();
if (!$lastAgent) {
$lastAgentNumber = 0;
} else {
$lastAgentNumber = intval(str_replace($prefix, '', $lastAgent->username));
}
return $this->formatAgentCode($lastAgentNumber + 1);
}
