Ejemplo n.º 1
0
 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;
 }
Ejemplo n.º 2
0
 public function getBorrowerCountries()
 {
     $borrowerCountries = CountryQuery::create()->filterByBorrowerCountry(1);
     $countries = [];
     foreach ($borrowerCountries as $country) {
         $countries[$country->getId()] = $country->getName();
     }
     return $countries;
 }
Ejemplo n.º 3
0
 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);
 }
Ejemplo n.º 4
0
 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;
 }
Ejemplo n.º 5
0
 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;
 }
Ejemplo n.º 6
0
 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');
 }
Ejemplo n.º 7
0
 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;
 }
Ejemplo n.º 8
0
 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);
 }
Ejemplo n.º 9
0
 public function getCountries()
 {
     $countries = \Zidisha\Country\CountryQuery::create()->filterByBorrowerCountry(1)->find();
     return $countries;
 }
Ejemplo n.º 10
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();
         }
     }
 }
Ejemplo n.º 11
0
 public function getCountries()
 {
     return CountryQuery::create()->orderByName()->find()->toKeyValue('id', 'name');
 }
Ejemplo n.º 12
0
 public function getPage()
 {
     $countries = CountryQuery::create()->filterByBorrowerCountry(true)->find();
     return View::make('pages.borrow', compact('countries'));
 }
Ejemplo n.º 13
0
 public function filterBorrowerLanguages()
 {
     $languageCodes = CountryQuery::create()->filterByBorrowerCountry(true)->distinct()->select(['language_code'])->find();
     return $this->filterByLanguageCode($languageCodes->getData());
 }