public function nthInstallmentDate($n = 1)
{
$date = $this->installmentGraceDate()->copy();
if ($this->loan->isWeeklyInstallment()) {
$date->addWeeks($n);
} else {
if ($date->day == 31) {
$date->firstOfMonth()->addMonths($n)->lastOfMonth();
} else {
$date->addMonths($n);
}
}
return $date;
}
public function repaymentAmountForLenders()
{
// TODO use disbursed amount in lenderInterest
$totalLendersAmount = $this->loan->getNativeDisbursedAmount()->add($this->lenderInterest());
$ratio = $this->loan->getNativeDisbursedAmount()->divide($totalLendersAmount);
$repaymentAmountForLenders = $this->repaymentAmount->subtract($this->installmentServiceFee());
return $repaymentAmountForLenders->multiply($ratio);
}
public function getPreviousLoans(Borrower $borrower, Loan $loan)
{
$loans = LoanQuery::create()->filterByBorrower($borrower)->orderByAcceptedDate('desc')->find();
$previousLoans = [];
foreach ($loans as $oneLoan) {
if ($loan->getId() != $oneLoan->getId()) {
array_push($previousLoans, $oneLoan);
}
}
return $previousLoans;
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
try {
$settings = Setting::getAll();
} catch (\Exception $e) {
$settings = [];
}
$model = $this->argument('model');
$size = $this->argument('size');
$faker = Faker::create();
$countries = [['KE', 'Kenya', 'KES', '1000'], ['BJ', 'Benin', 'XOF', '0'], ['BF', 'Burkina Faso', 'XOF', '0'], ['GH', 'Ghana', 'GHS', '0'], ['ID', 'Indonesia', 'IDR', '0'], ['SN', 'Senegal', 'XOF', '0'], ['IN', 'India', 'INR', '0']];
$temp = true;
$allCity = [];
if ($model == 'new') {
$this->line('Rebuild database');
DB::statement('drop schema public cascade');
DB::statement('create schema public');
exec('rm -rf app/database/migrations');
exec('./propel diff');
exec('./propel migrate');
exec('./propel build');
$this->line('Delete loans index');
exec("curl -XDELETE 'http://*****:*****@mail.com';
$user = new \Zidisha\User\User();
$user->setUsername($userName);
$user->setPassword($password);
$user->setEmail($email);
$user->setRole('admin');
$user->setLastLoginAt(new Carbon());
$user->save();
$user = new \Zidisha\User\User();
$user->setUsername('YC');
$user->setPassword('1234567890');
$user->setEmail('*****@*****.**');
$user->setLastLoginAt(new Carbon());
$user->save();
}
if ($model == "Language") {
$languages = [['in', 'Bahasa Indonesia', true], ['fr', 'Français', true], ['hi', 'Hindi', false], ['en', 'English', false]];
foreach ($languages as $language) {
$lang = new Language();
$lang->setLanguageCode($language[0]);
$lang->setName($language[1]);
$lang->setActive($language[2]);
$lang->save();
}
}
if ($model == "CategoryTranslation") {
$allCategories = CategoryQuery::create()->filterByAdminOnly(false)->find();
$allLanguages = \Zidisha\Country\LanguageQuery::create()->filterByActive(true)->find();
foreach ($allCategories as $Category) {
foreach ($allLanguages as $language) {
$translation = new CategoryTranslation();
$translation->setCategory($Category)->setLanguage($language)->setTranslation($Category->getName() . $language->getLanguageCode());
$translation->save();
}
}
}
if ($model == "ExchangeRate") {
foreach (['KES' => 80, 'XOF' => 20, 'GHS' => 50, 'IDR' => 40, 'INR' => 80] as $currencyCode => $rate) {
$dateMonthAgo = new DateTime();
$dateMonthAgo->modify('-1 month');
$dateNow = new DateTime();
$dateNow->modify('-1 second');
$exchangeRate = new \Zidisha\Currency\ExchangeRate();
$exchangeRate->setCurrencyCode($currencyCode)->setRate($rate - 5)->setStartDate($dateMonthAgo)->setEndDate($dateNow);
$exchangeRate->save();
$exchangeRate = new \Zidisha\Currency\ExchangeRate();
$exchangeRate->setCurrencyCode($currencyCode)->setRate($rate)->setStartDate($dateNow);
$exchangeRate->save();
}
}
for ($i = 1; $i <= $size; $i++) {
if ($model == "Invite") {
do {
$lender = $allLenders[array_rand($allLenders->getData())];
$invitee = $allLenders[array_rand($allLenders->getData())];
} while ($lender->getId() == $invitee->getId());
$lenderInvite = new Invite();
$lenderInvite->setLender($lender);
if (is_int($i / 4)) {
$lenderInvite->setEmail($faker->email);
} else {
$lenderInvite->setInvitee($invitee);
$lenderInvite->setInvited(true);
$lenderInvite->setEmail($invitee->getUser()->getEmail());
}
$lenderInvite->save();
}
if ($model == "Lender") {
$userName = '******' . $i;
$password = '******';
$email = 'lender' . $i . '@mail.com';
$oneCountry = $allCountries[array_rand($allCountries->getData())];
$user = new \Zidisha\User\User();
$user->setUsername($userName);
$user->setPassword($password);
$user->setEmail($email);
$user->setRole('lender');
if ($i < 5) {
$user->setLastLoginAt(new Carbon('first day of July 2013'));
} elseif ($i < 10) {
$user->setLastLoginAt(new Carbon('first day of June 2013'));
} else {
$user->setLastLoginAt(new Carbon());
}
$firstName = 'lender' . $i;
$lastName = 'last' . $i;
$lender = new \Zidisha\Lender\Lender();
$lender->setFirstName($firstName);
$lender->setLastName($lastName);
$lender->setCountry($oneCountry);
$lender->setUser($user);
$lender_profile = new \Zidisha\Lender\Profile();
$lender_profile->setAboutMe($faker->paragraph(7));
$lender_profile->setLender($lender);
$lender_profile->save();
}
if ($model == "Borrower") {
$userName = '******' . $i;
$password = '******';
$email = 'borrower' . $i . '@mail.com';
$isMentor = $randArray[array_rand($randArray)];
if ($i <= 40 && $isMentor) {
$oneCountry = $allCountries[3];
} else {
$oneCountry = $allCountries[array_rand($allCountries->getData())];
}
$user = new \Zidisha\User\User();
$user->setUsername($userName);
$user->setPassword($password);
$user->setEmail($email);
$user->setLastLoginAt(new Carbon());
$user->setRole('borrower');
$firstName = 'borrower' . $i;
$lastName = 'last' . $i;
$borrower = new \Zidisha\Borrower\Borrower();
$borrower->setFirstName($firstName);
$borrower->setLastName($lastName);
if ($isMentor) {
$oneCountry = $allCountries[2];
}
$borrower->setCountry($oneCountry);
$borrower->setUser($user);
$borrower->setVerified($faker->boolean());
foreach (['communityLeader', 'familyMember', 'familyMember', 'familyMember', 'neighbor', 'neighbor', 'neighbor'] as $contactType) {
$contact = new \Zidisha\Borrower\Contact();
$contact->setPhoneNumber($faker->numberBetween(100000000, 1000000000))->setFirstName($faker->firstName)->setLastName($faker->lastName)->setDescription($faker->sentence())->setType($contactType);
$borrower->addContact($contact);
}
$borrower_profile = new \Zidisha\Borrower\Profile();
$borrower_profile->setAboutMe($faker->paragraph(7));
$borrower_profile->setAboutBusiness($faker->paragraph(7));
$borrower_profile->setAddress($faker->paragraph(3));
$borrower_profile->setAddressInstructions($faker->paragraph(6));
if ($isMentor) {
$borrower_profile->setCity("Experimento");
} elseif ($i <= 20) {
$city = $faker->city;
array_push($allCity, $city);
$borrower_profile->setCity($city);
} else {
$borrower_profile->setCity($allCity[array_rand($allCity)]);
}
$borrower_profile->setPhoneNumber($faker->phoneNumber);
$borrower_profile->setAlternatePhoneNumber($faker->phoneNumber);
$borrower_profile->setNationalIdNumber($faker->randomNumber(10));
$borrower_profile->setBorrower($borrower);
if ($i <= 40) {
$user->setSubRole('volunteerMentor');
$mentor = new VolunteerMentor();
$borrower->setCountry($allCountries[2]);
$mentor->setBorrowerVolunteer($borrower)->setCountry($borrower->getCountry())->setStatus(1)->setGrantDate(new \DateTime());
} else {
$allMentors = VolunteerMentorQuery::create()->find();
$oneMentor = $allMentors[array_rand($allMentors->getData())];
$borrower->setVolunteerMentor($oneMentor);
}
$borrower_profile->save();
$joinLog = new JoinLog();
$joinLog->setIpAddress($faker->ipv4)->setVerificationCode($faker->randomNumber(20))->setBorrower($borrower);
if ($borrower->getVerified()) {
$joinLog->setVerifiedAt(new \DateTime());
}
$joinLog->save();
}
if ($model == "Country") {
if ($i > sizeof($countries)) {
continue;
}
$oneCountry = $countries[$i - 1];
$country = new Country();
$country->setName($oneCountry[1]);
$country->setCountryCode($oneCountry[0]);
$country->setContinentCode('AF');
$country->setDialingCode('000');
$country->SetRegistrationFee($oneCountry[3]);
$country->SetBorrowerCountry(true);
$country->setCurrencyCode($oneCountry[2]);
$country->setPhoneNumberLength(9);
$country->setInstallmentPeriod($faker->randomElement([Loan::WEEKLY_INSTALLMENT, Loan::MONTHLY_INSTALLMENT]));
if ($i < 3) {
$language = \Zidisha\Country\LanguageQuery::create()->filterByLanguageCode('fr')->findOne();
$country->setLanguage($language);
} elseif ($i > 2) {
$language = \Zidisha\Country\LanguageQuery::create()->filterByLanguageCode('in')->findOne();
$country->setLanguage($language);
}
$country->save();
}
if ($model == "Category") {
if ($i >= 17) {
continue;
}
$oneCategory = $categories[$i - 1];
$category = new Category();
$category->setName($oneCategory[0]);
$category->setWhatDescription($oneCategory[1]);
$category->setWhyDescription($oneCategory[2]);
$category->setHowDescription($oneCategory[3]);
$category->setAdminOnly($oneCategory[4]);
$category->save();
}
if ($model == "Loan") {
if ($i >= 30) {
$installmentDay = $i - (int) (25 - $i);
$amount = 30 + $i * 100;
} else {
$installmentDay = $i;
$amount = 30 + $i * 200;
}
$loanCategory = $allCategories[array_rand($allCategories)];
$status = floatval($size / 7);
if ($i > 50 && $i < 55) {
$borrower = $allBorrowers[50];
} else {
$borrower = $allBorrowers[$i - 1];
}
$data = array();
$data['summary'] = $faker->sentence(8);
$data['proposal'] = $faker->paragraph(7);
$data['nativeAmount'] = $amount;
$data['currencyCode'] = 'KES';
$data['amount'] = $amount / 2;
$installmentAmount = (int) $data['amount'] / 12;
$data['installmentAmount'] = $installmentAmount;
$data['registrationFeeRate'] = '5';
$data['applicationDate'] = new \DateTime();
$data['installmentDay'] = $installmentDay;
$data['categoryId'] = $loanCategory->getId();
$data['amountRaised'] = 40;
if ($i < $status) {
$data['amountRaised'] = 0;
$loanService->applyForLoan($borrower, $data);
continue;
}
$Loan = Loan::createFromData($data);
$Loan->setCategory($loanCategory);
$Loan->setBorrower($borrower);
$Stage = new Stage();
$Stage->setLoan($Loan);
$Stage->setBorrower($borrower);
if ($i < $status * 3) {
$borrower->setLoanStatus(Loan::FUNDED);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::FUNDED);
$Loan->setNativeDisbursedAmount($amount);
$Loan->setDisbursedDate(new \DateTime());
$Stage->setStatus(Loan::FUNDED);
} elseif ($i < $status * 4) {
$borrower->setLoanStatus(Loan::ACTIVE);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::ACTIVE);
$Loan->setAmountRaised($amount - $amount / 3);
$Loan->setDisbursedDate(new \DateTime());
$Stage->setStatus(Loan::ACTIVE);
} elseif ($i < $status * 5) {
$borrower->setLoanStatus(Loan::REPAID);
$borrower->setActiveLoan($Loan);
$Loan->setNativeDisbursedAmount($amount);
$Loan->setDisbursedDate(strtotime("-1 year"));
$Loan->setStatus(Loan::REPAID);
$Stage->setStatus(Loan::REPAID);
} elseif ($i < $status * 6) {
$borrower->setLoanStatus(Loan::DEFAULTED);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::DEFAULTED);
$Stage->setStatus(Loan::DEFAULTED);
} elseif ($i < $status * 7) {
$borrower->setLoanStatus(Loan::CANCELED);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::CANCELED);
$Stage->setStatus(Loan::CANCELED);
} else {
$borrower->setLoanStatus(Loan::EXPIRED);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::EXPIRED);
$Stage->setStatus(Loan::EXPIRED);
}
$Stage->setStartDate(new \DateTime());
$Stage->save();
$borrower->save();
$loanService->addToLoanIndex($Loan);
}
if ($model == "Transaction") {
$oneLender = $allLenders[array_rand($allLenders->getData())];
$oneLoan = $allLoans[array_rand($allLoans->getData())];
$transaction = new Transaction();
$transaction->setUser($oneLender->getUser());
$transaction->setAmount(Money::create(rand(-100, 200), 'USD'));
$transaction->setLoan($oneLoan);
$transaction->setDescription('description');
$transaction->setTransactionDate(new \DateTime());
$transaction->setType(Transaction::FUND_WITHDRAW);
$transaction->save();
if ($temp == true) {
$yc = \Zidisha\User\UserQuery::create()->findOneById(2);
$transaction = new Transaction();
$transaction->setUser($yc);
$transaction->setAmount(Money::create(10000, 'USD'));
$transaction->setDescription($faker->sentence(4));
$transaction->setTransactionDate(new \DateTime());
$transaction->setType(Transaction::DONATE_BY_ADMIN);
$transaction->save();
$temp = false;
}
}
if ($model == "Bid") {
$openLoans = LoanQuery::create()->filterByStatus(0)->find();
$oneLoan = $openLoans[array_rand($openLoans->getData())];
$oneLender = $allLenders[array_rand($allLenders->getData())];
$oneBid = new Bid();
$oneBid->setBidDate(new \DateTime());
$oneBid->setBidAmount(Money::create(rand(0, 30), 'USD'));
$oneBid->setInterestRate(rand(0, 15));
$oneBid->setLoan($oneLoan);
$oneBid->setLender($oneLender);
$oneBid->setBorrower($oneLoan->getBorrower());
$oneBid->save();
}
if ($model == "Comment") {
$borrower = $allBorrowers[array_rand($allBorrowers)];
$user = $allBorrowers[array_rand($allBorrowers)];
$isTranslated = $randArray[array_rand($randArray)];
$comment = new Comment();
$comment->setBorrower($borrower)->setUser($user->getUser())->setMessage($faker->paragraph(3))->setLevel(0);
if ($isTranslated) {
$comment->setMessageTranslation($faker->paragraph(3))->setTranslatorId(1);
} elseif ($i < 100) {
$comment->setUser($borrower->getUser());
}
$comment->save();
}
if ($model == "GiftCard") {
$lender = $allLenders[array_rand($allLenders->getData())];
$amount = Money::create(rand(15, 1000), 'USD');
$faker = Faker::create();
$isClaimed = $randArray[array_rand($randArray)];
$giftCard = new GiftCard();
$giftCard->setLender($lender)->setOrderType(array_rand([0, 1]))->setCardAmount($amount)->setFromName($lender->getName())->setMessage($faker->sentence(10))->setRecipientEmail($faker->email)->setDate(new \DateTime())->setExpireDate(strtotime('+1 year'))->setCardCode($faker->creditCardNumber);
if ($isClaimed) {
$recipient = $allLenders[array_rand($allLenders->getData())];
$giftCard->setClaimed(1)->setRecipientName($recipient->getName())->setRecipient($recipient);
}
$giftCard->save();
}
if ($model == "LenderGroup") {
$leader = $allLenders[array_rand($allLenders->getData())];
$group = new LendingGroup();
$group->setCreator($leader)->setLeader($leader)->setCreator($leader)->setAbout($faker->paragraph(2))->setName($faker->sentence(2));
$groupMember = new LendingGroupMember();
$groupMember->setMember($leader)->setLendingGroup($group);
$groupMember->save();
}
if ($model == "LenderGroupMember") {
$member = $allLenders[array_rand($allLenders->getData())];
$group = $allGroups[array_rand($allGroups->getData())];
$groupMember = new LendingGroupMember();
$groupMember->setMember($member)->setLendingGroup($group);
$groupMember->save();
}
}
}
public function AddTranslations(Loan $loan, $data)
{
$profile = $loan->getBorrower()->getProfile();
$profile->setAboutMeTranslation($data['translateAboutMe'])->setAboutBusinessTranslation($data['translateAboutBusiness']);
$loan->setProposalTranslation($data['translateProposal']);
$profile->save();
$loan->save();
}
public static function createFromData($data)
{
$currency = $data['currencyCode'];
$loan = new Loan();
$loan->setSummary($data['summary']);
$loan->setProposal($data['proposal']);
$loan->setCurrencyCode($data['currencyCode']);
$loan->setNativeAmount(Money::create($data['nativeAmount'], $currency));
$loan->setAmount(Money::create($data['amount'], 'USD'));
$loan->setRegistrationFeeRate('5');
$loan->setInstallmentPeriod('monthly');
// TODO $borrower->getCountry()->getInstallmentPeriod()
$loan->setInterestRate(20);
// TODO
$loan->setInstallmentDay($data['installmentDay']);
$loan->setApplicationDate(new \DateTime());
$loan->calculateInstallmentCount(Money::create($data['installmentAmount'], $currency));
return $loan;
}