public function getNinjaClient($account)
{
$account->load('users');
$ninjaAccount = $this->getNinjaAccount();
$ninjaUser = $ninjaAccount->getPrimaryUser();
$client = Client::whereAccountId($ninjaAccount->id)->wherePublicId($account->id)->first();
$clientExists = $client ? true : false;
if (!$client) {
$client = new Client();
$client->public_id = $account->id;
$client->account_id = $ninjaAccount->id;
$client->user_id = $ninjaUser->id;
$client->currency_id = 1;
}
foreach (['name', 'address1', 'address2', 'city', 'state', 'postal_code', 'country_id', 'work_phone', 'language_id', 'vat_number'] as $field) {
$client->{$field} = $account->{$field};
}
$client->save();
if ($clientExists) {
$contact = $client->getPrimaryContact();
} else {
$contact = new Contact();
$contact->user_id = $ninjaUser->id;
$contact->account_id = $ninjaAccount->id;
$contact->public_id = $account->id;
$contact->is_primary = true;
}
$user = $account->getPrimaryUser();
foreach (['first_name', 'last_name', 'email', 'phone'] as $field) {
$contact->{$field} = $user->{$field};
}
$client->contacts()->save($contact);
return $client;
}
public function fire() { $this->info(date('Y-m-d') . ' Running SendRenewalInvoices...'); // get all accounts with plans expiring in 10 days $companies = Company::whereRaw('datediff(plan_expires, curdate()) = 10')->orderBy('id')->get(); $this->info(count($companies) . ' companies found renewing in 10 days'); foreach ($companies as $company) { if (!count($company->accounts)) { continue; } $account = $company->accounts->sortBy('id')->first(); $plan = []; $plan['plan'] = $company->plan; $plan['term'] = $company->plan_term; $plan['num_users'] = $company->num_users; $plan['price'] = min($company->plan_price, Utils::getPlanPrice($plan)); if ($company->pending_plan) { $plan['plan'] = $company->pending_plan; $plan['term'] = $company->pending_term; $plan['num_users'] = $company->pending_num_users; $plan['price'] = min($company->pending_plan_price, Utils::getPlanPrice($plan)); } if ($plan['plan'] == PLAN_FREE || !$plan['plan'] || !$plan['term'] || !$plan['price']) { continue; } $client = $this->accountRepo->getNinjaClient($account); $invitation = $this->accountRepo->createNinjaInvoice($client, $account, $plan, 0, false); // set the due date to 10 days from now $invoice = $invitation->invoice; $invoice->due_date = date('Y-m-d', strtotime('+ 10 days')); $invoice->save(); $term = $plan['term']; $plan = $plan['plan']; if ($term == PLAN_TERM_YEARLY) { $this->mailer->sendInvoice($invoice); $this->info("Sent {$term}ly {$plan} invoice to {$client->getDisplayName()}"); } else { $this->info("Created {$term}ly {$plan} invoice for {$client->getDisplayName()}"); } } $this->info('Done'); }