public function getCountrySlug() { $currencies = []; $countries = CountryQuery::create()->filterByBorrowerCountry(true)->orderByName()->find(); foreach ($countries as $country) { $currencies[$country->getSlug()] = $country->getCurrency()->getName() . " in " . $country->getName(); } return $currencies; }
public function getBorrowerCountries() { $borrowerCountries = CountryQuery::create()->filterByBorrowerCountry(1); $countries = []; foreach ($borrowerCountries as $country) { $countries[$country->getId()] = $country->getName(); } return $countries; }
public function getVolunteerMentorCity() { $countryCode = \Session::get('BorrowerJoin.countryCode'); $country = CountryQuery::create()->filterByCountryCode($countryCode)->findOne(); $con = Propel::getWriteConnection(TransactionTableMap::DATABASE_NAME); $sql = "SELECT DISTINCT city FROM borrower_profiles WHERE borrower_id IN " . "(SELECT borrower_id FROM volunteer_mentor WHERE country_id = :country_id AND status = :status\n AND mentee_count < :mentee_count)"; $stmt = $con->prepare($sql); //TODO to make mentee_count = 50 $stmt->execute(array(':country_id' => $country->getId(), ':status' => '1', ':mentee_count' => '25')); $cities = $stmt->fetchAll(\PDO::FETCH_COLUMN); return array_combine($cities, $cities); }
public function getBorrowersByCountry() { $list = []; $list[0] = null; $countryCode = \Session::get('BorrowerJoin.countryCode'); $country = CountryQuery::create()->findOneByCountryCode($countryCode); $borrowers = BorrowerQuery::create()->filterByCountry($country)->orderByFirstName()->filterByActive(true)->joinWith('Profile')->find(); foreach ($borrowers as $borrower) { $list[$borrower->getId()] = $borrower->getName() . " ( " . $borrower->getProfile()->getCity() . " )"; } return $list; }
public function updateExchangeRateForCountry($data) { $country = CountryQuery::create()->filterBySlug($data['countrySlug'])->findOne(); $currencyCode = $country->getCurrency()->getCode(); $lastRate = ExchangeRateQuery::create()->filterByCurrencyCode($currencyCode)->filterByEndDate(null)->findone(); if ($lastRate) { $lastRate->setEndDate(new \DateTime()); $lastRate->save(); } $newRate = new ExchangeRate(); $newRate->setStartDate(new \DateTime())->setCurrencyCode($currencyCode)->setRate($data['newRate']); $newRate->save(); return $newRate; }
public function postCountry() { $form = $this->countryForm; $form->handleRequest(Request::instance()); if ($form->isValid()) { $country = CountryQuery::create()->findOneById($form->getData()['country']); Session::put('BorrowerJoin.countryCode', $country->getCountryCode()); Session::put('BorrowerJoin.countryId', $country->getId()); $this->setCurrentStep('facebook'); return Redirect::action('BorrowerJoinController@getFacebook'); } Flash::error('You can only select from list of available countries.'); return Redirect::action('BorrowerJoinController@getCountry'); }
public static function getCountryCodeByIP() { $country['code'] = ''; $country['name'] = ''; $country['id'] = ''; $ip = \Request::getClientIp(); if (!empty($ip)) { $reader = new Reader(app_path() . '/storage/external/GeoLite2-Country.mmdb'); $record = $reader->country('103.7.80.62'); $country = array(); $country['code'] = $record->country->isoCode; $country['name'] = $record->country->name; $dbCountry = CountryQuery::create()->findOneByCountryCode($country['code']); $country['id'] = $dbCountry->getId(); } return $country; }
public function postEditCountry($id) { $country = CountryQuery::create()->findOneById($id); if (!$country) { \App::abort(404, 'fatal error.'); } $form = $this->editForm; $form->handleRequest(Request::instance()); if ($form->isValid()) { $data = $form->getData(); $country->setBorrowerCountry($data['borrower_country'])->setDialingCode($data['dialing_code'])->setPhoneNumberLength($data['phone_number_length'])->setRegistrationFee($data['registration_fee'])->setInstallmentPeriod($data['installment_period'])->setRepaymentInstructions($data['repayment_instructions']); $country->save(); \Flash::success('Changes have been updated.'); return Redirect::route('admin:edit:country', $id); } \Flash::error('Please use proper options.'); return Redirect::route('admin:edit:country', $id)->withForm($form); }
public function getCountries() { $countries = \Zidisha\Country\CountryQuery::create()->filterByBorrowerCountry(1)->find(); return $countries; }
/** * 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 getCountries() { return CountryQuery::create()->orderByName()->find()->toKeyValue('id', 'name'); }
public function getPage() { $countries = CountryQuery::create()->filterByBorrowerCountry(true)->find(); return View::make('pages.borrow', compact('countries')); }
public function filterBorrowerLanguages() { $languageCodes = CountryQuery::create()->filterByBorrowerCountry(true)->distinct()->select(['language_code'])->find(); return $this->filterByLanguageCode($languageCodes->getData()); }