public function postEditBid() { $data = \Input::all(); $lender = \Auth::user()->getLender(); $loan = LoanQuery::create()->filterById($data['loanId'])->findOne(); $totalLoanAmount = $loan->getAmount(); $amount = Money::valueOf($data['amount'], Currency::valueOf('USD')); $oldBid = BidQuery::create()->filterByLender($lender)->filterByLoan($loan)->findOne(); if ($oldBid->getBidAmount()->compare($amount) != -1) { \Flash::error(\Lang::get('Loan.edit-bid.amount')); return Redirect::back()->withInput(); } if ($totalLoanAmount->getAmount() <= $data['amount']) { \Flash::error(\Lang::get('Loan.edit-bid.interest-rate')); return Redirect::back()->withInput(); } if ($data['interestRate'] <= $oldBid->getInterestRate()) { \Flash::error(\Lang::get('Loan.edit-bid.bid-amount-exceded')); return Redirect::back()->withInput(); } $bid = BidQuery::create()->filterByLoan($loan)->filterByLender($lender)->findOne(); $this->loanService->editBid($bid, $data); Flash::success(\Lang::get('Loan.edit-bid.success') . $data['amount']); return Redirect::route('loan:index', $data['loanId']); }
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; }
public function getTranslationFeed($type = null) { $languageCode = Request::query('language') ?: null; if ($type == 'loans') { $loans = LoanQuery::create()->condition('summery', 'Loan.SummaryTranslation IS NULL')->condition('proposal', 'Loan.ProposalTranslation IS NULL')->where(array('summery', 'proposal'), 'or')->_or()->useBorrowerQuery()->useProfileQuery()->condition('aboutMe', 'Profile.AboutMeTranslation IS NULL')->condition('aboutBusiness', 'Profile.AboutBusinessTranslation IS NULL')->where(array('aboutMe', 'aboutBusiness'), 'or')->endUse()->endUse(); if ($languageCode) { $loans->filterByLanguageCode($languageCode); } $page = Request::query('page') ?: 1; $paginator = $loans->paginate($page, 10); } else { $type = 'comments'; $comments = CommentQuery::create()->where('Comment.BorrowerId = Comment.UserId')->filterByMessageTranslation(null); if ($languageCode) { $comments->useBorrowerQuery()->useCountryQuery()->useLanguageQuery()->filterByLanguageCode($languageCode)->endUse()->endUse()->endUse(); } $page = Request::query('page') ?: 1; $paginator = $comments->paginate($page, 10); } return View::make('admin.translation-feed', compact('type', 'loans', 'comments', 'paginator'), ['form' => $this->translationFeedForm]); }
/** * 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 testRefundLenders(UnitTester $I) { $method = new ReflectionMethod($this->loanService, 'refundLenders'); $method->setAccessible(true); $con = Propel::getWriteConnection(TransactionTableMap::DATABASE_NAME); $con->beginTransaction(); $loan = \Zidisha\Loan\LoanQuery::create()->findOneById(5); $lender1 = \Zidisha\Lender\LenderQuery::create()->findOneById(203); $lender2 = \Zidisha\Lender\LenderQuery::create()->findOneById(204); $lender3 = \Zidisha\Lender\LenderQuery::create()->findOneById(205); try { $this->transactionService->addPlaceBidTransaction($con, Money::create(50), $loan, $lender1); $this->transactionService->addPlaceBidTransaction($con, Money::create(30), $loan, $lender2); $this->transactionService->addPlaceBidTransaction($con, Money::create(40), $loan, $lender3); $this->transactionService->addOutBidTransaction($con, Money::create(20), $loan, $lender1); $this->transactionService->addUpdateBidTransaction($con, Money::create(10), $loan, $lender2); $this->transactionService->addOutBidTransaction($con, Money::create(10), $loan, $lender1); $refunds = $method->invoke($this->loanService, $con, $loan, Loan::EXPIRED); verify($refunds[$lender1->getId()]['refundAmount'])->equals(Money::create(20)); verify($refunds[$lender2->getId()]['refundAmount'])->equals(Money::create(40)); verify($refunds[$lender3->getId()]['refundAmount'])->equals(Money::create(40)); $lender1VerifyRefund = \Zidisha\Balance\TransactionQuery::create()->filterByUserId($lender1->getId())->filterByType(Transaction::LOAN_OUTBID)->filterBySubType(Transaction::LOAN_BID_EXPIRED)->count(); $lender2VerifyRefund = \Zidisha\Balance\TransactionQuery::create()->filterByUserId($lender2->getId())->filterByType(Transaction::LOAN_OUTBID)->filterBySubType(Transaction::LOAN_BID_EXPIRED)->count(); $lender3VerifyRefund = \Zidisha\Balance\TransactionQuery::create()->filterByUserId($lender1->getId())->filterByType(Transaction::LOAN_OUTBID)->filterBySubType(Transaction::LOAN_BID_EXPIRED)->count(); verify($lender1VerifyRefund)->equals(1); verify($lender2VerifyRefund)->equals(1); verify($lender3VerifyRefund)->equals(1); $con->rollBack(); } catch (\Exception $e) { $con->rollBack(); throw $e; } }