Example #1
0
 /**
  * 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();
         }
     }
 }