Jump to content

neilfurry

Members
  • Posts

    107
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

neilfurry's Achievements

Regular Member

Regular Member (3/5)

0

Reputation

4

Community Answers

  1. I have two entities: Members and Loans namespace App\Entity; use App\Repository\MembersRepository; use Doctrine\ORM\Mapping as ORM; /** * @ORM\Entity(repositoryClass=MembersRepository::class) */ class Members { /** * @ORM\Id * @ORM\GeneratedValue * @ORM\Column(type="integer") * @ORM\ManyToOne(targetEntity="Loans", inversedBy="Loanee") */ private $id; /** * @ORM\Column(type="string", length=255) */ private $LastName; /** * @ORM\Column(type="string", length=255) */ private $FirstName; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $MiddleName; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $ResidencePhone; /** * @ORM\Column(type="string", length=255) */ private $Address; /** * @ORM\Column(type="string", length=255) */ private $Barangay; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $Email; /** * @ORM\Column(type="string", length=255) */ private $MobileNumber; /** * @ORM\Column(type="date") */ private $Birthday; /** * @ORM\Column(type="string", length=255) */ private $BirthPlace; /** * @ORM\Column(type="string", length=255) */ private $CivilStatus; /** * @ORM\Column(type="string", length=255) */ private $Sex; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $Citizenship; /** * @ORM\Column(type="string", length=255) */ private $EmployeeNumber; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $TIN; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $GSIS; /** * @ORM\Column(type="string", length=255) */ private $Agency; /** * @ORM\Column(type="string", length=255) */ private $Designation; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $OfficePhone; /** * @ORM\Column(type="string", length=255) */ private $EmployeeStatus; /** * @ORM\Column(type="string", length=255) */ private $SourceOfIncome; /** * @ORM\Column(type="string", length=255) */ private $MonthlyIncome; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $EducationalAttainment; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $Spouse; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $Dependents; /** * @ORM\Column(type="datetime") */ private $DateRegistered; /** * @ORM\Column(type="datetime") */ private $DateLastUpdated; /** * @ORM\Column(type="string", length=255) */ private $BoardAction; public function getId(): ?int { return $this->id; } public function getLastName(): ?string { return $this->LastName; } public function setLastName(string $LastName): self { $this->LastName = $LastName; return $this; } public function getFirstName(): ?string { return $this->FirstName; } public function setFirstName(string $FirstName): self { $this->FirstName = $FirstName; return $this; } public function getMiddleName(): ?string { return $this->MiddleName; } public function setMiddleName(?string $MiddleName): self { $this->MiddleName = $MiddleName; return $this; } public function getResidencePhone(): ?string { return $this->ResidencePhone; } public function setResidencePhone(?string $ResidencePhone): self { $this->ResidencePhone = $ResidencePhone; return $this; } public function getAddress(): ?string { return $this->Address; } public function setAddress(string $Address): self { $this->Address = $Address; return $this; } public function getBarangay(): ?string { return $this->Barangay; } public function setBarangay(string $Barangay): self { $this->Barangay = $Barangay; return $this; } public function getEmail(): ?string { return $this->Email; } public function setEmail(?string $Email): self { $this->Email = $Email; return $this; } public function getMobileNumber(): ?string { return $this->MobileNumber; } public function setMobileNumber(string $MobileNumber): self { $this->MobileNumber = $MobileNumber; return $this; } public function getBirthday(): ?\DateTimeInterface { return $this->Birthday; } public function setBirthday(\DateTimeInterface $Birthday): self { $this->Birthday = $Birthday; return $this; } public function getBirthPlace(): ?string { return $this->BirthPlace; } public function setBirthPlace(string $BirthPlace): self { $this->BirthPlace = $BirthPlace; return $this; } public function getCivilStatus(): ?string { return $this->CivilStatus; } public function setCivilStatus(string $CivilStatus): self { $this->CivilStatus = $CivilStatus; return $this; } public function getSex(): ?string { return $this->Sex; } public function setSex(string $Sex): self { $this->Sex = $Sex; return $this; } public function getCitizenship(): ?string { return $this->Citizenship; } public function setCitizenship(?string $Citizenship): self { $this->Citizenship = $Citizenship; return $this; } public function getEmployeeNumber(): ?string { return $this->EmployeeNumber; } public function setEmployeeNumber(string $EmployeeNumber): self { $this->EmployeeNumber = $EmployeeNumber; return $this; } public function getTIN(): ?string { return $this->TIN; } public function setTIN(?string $TIN): self { $this->TIN = $TIN; return $this; } public function getGSIS(): ?string { return $this->GSIS; } public function setGSIS(?string $GSIS): self { $this->GSIS = $GSIS; return $this; } public function getAgency(): ?string { return $this->Agency; } public function setAgency(string $Agency): self { $this->Agency = $Agency; return $this; } public function getDesignation(): ?string { return $this->Designation; } public function setDesignation(string $Designation): self { $this->Designation = $Designation; return $this; } public function getOfficePhone(): ?string { return $this->OfficePhone; } public function setOfficePhone(?string $OfficePhone): self { $this->OfficePhone = $OfficePhone; return $this; } public function getEmployeeStatus(): ?string { return $this->EmployeeStatus; } public function setEmployeeStatus(string $EmployeeStatus): self { $this->EmployeeStatus = $EmployeeStatus; return $this; } public function getSourceOfIncome(): ?string { return $this->SourceOfIncome; } public function setSourceOfIncome(string $SourceOfIncome): self { $this->SourceOfIncome = $SourceOfIncome; return $this; } public function getMonthlyIncome(): ?string { return $this->MonthlyIncome; } public function setMonthlyIncome(string $MonthlyIncome): self { $this->MonthlyIncome = $MonthlyIncome; return $this; } public function getEducationalAttainment(): ?string { return $this->EducationalAttainment; } public function setEducationalAttainment(?string $EducationalAttainment): self { $this->EducationalAttainment = $EducationalAttainment; return $this; } public function getSpouse(): ?string { return $this->Spouse; } public function setSpouse(?string $Spouse): self { $this->Spouse = $Spouse; return $this; } public function getDependents(): ?string { return $this->Dependents; } public function setDependents(?string $Dependents): self { $this->Dependents = $Dependents; return $this; } public function getDateRegistered(): ?\DateTimeInterface { return $this->DateRegistered; } public function setDateRegistered(\DateTimeInterface $DateRegistered): self { $this->DateRegistered = $DateRegistered; return $this; } public function getDateLastUpdated(): ?\DateTimeInterface { return $this->DateLastUpdated; } public function setDateLastUpdated(\DateTimeInterface $DateLastUpdated): self { $this->DateLastUpdated = $DateLastUpdated; return $this; } public function getBoardAction(): ?string { return $this->BoardAction; } public function setBoardAction(string $BoardAction): self { $this->BoardAction = $BoardAction; return $this; } } namespace App\Entity; use App\Repository\LoansRepository; use Doctrine\ORM\Mapping as ORM; /** * @ORM\Entity(repositoryClass=LoansRepository::class) */ class Loans { /** * @ORM\Id * @ORM\GeneratedValue * @ORM\Column(type="integer") */ private $id; /** * @ORM\Column(type="string", length=255) */ private $LoanApplicationNumber; /** * @ORM\Column(type="string", length=255) * @ORM\OneToMany(targetEntity="Members", mappedBy="id") */ private $Loanee; /** * @ORM\Column(type="string", length=255) */ private $LoanAmount; /** * @ORM\Column(type="string", length=255) */ private $MonthsToPay; /** * @ORM\Column(type="string", length=255) */ private $LoanPurpose; /** * @ORM\Column(type="string", length=255) */ private $ModeOfPayment; /** * @ORM\Column(type="date") */ private $DateApplied; /** * @ORM\Column(type="datetime") */ private $DateEncoded; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $ChairApproved; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $GenApproved; /** * @ORM\Column(type="string", length=255, nullable=true) */ private $TeasApproved; /** * @ORM\Column(type="string", length=255) */ private $LoanType; /** * @ORM\Column(type="integer") */ private $Principal; /** * @ORM\Column(type="integer") */ private $MonthlyInstallment; /** * @ORM\Column(type="decimal", precision=10, scale=3) */ private $ContractRate; /** * @ORM\Column(type="integer") */ private $OtherCharges; /** * @ORM\Column(type="integer") */ private $NoOfInstallment; /** * @ORM\Column(type="decimal", precision=10, scale=2) */ private $InterestRate; /** * @ORM\Column(type="integer") */ private $MonthlyRate; /** * @ORM\Column(type="integer") */ private $PMR; /** * @ORM\Column(type="integer") */ private $BaseInterestRate; /** * @ORM\Column(type="date") */ private $DeductionStart; /** * @ORM\Column(type="date") */ private $DeductionEnd; /** * @ORM\Column(type="decimal", precision=10, scale=2) */ private $ProcessingFee; /** * @ORM\Column(type="decimal", precision=10, scale=2) */ private $ComputerFee; /** * @ORM\Column(type="decimal", precision=10, scale=2) */ private $Capital; /** * @ORM\Column(type="decimal", precision=10, scale=2) */ private $NetLoan; public function getId(): ?int { return $this->id; } public function getLoanApplicationNumber(): ?string { return $this->LoanApplicationNumber; } public function setLoanApplicationNumber(string $LoanApplicationNumber): self { $this->LoanApplicationNumber = $LoanApplicationNumber; return $this; } public function getLoanee(): ?string { return $this->Loanee; } public function setLoanee(string $Loanee): self { $this->Loanee = $Loanee; return $this; } public function getLoanAmount(): ?string { return $this->LoanAmount; } public function setLoanAmount(string $LoanAmount): self { $this->LoanAmount = $LoanAmount; return $this; } public function getMonthsToPay(): ?string { return $this->MonthsToPay; } public function setMonthsToPay(string $MonthsToPay): self { $this->MonthsToPay = $MonthsToPay; return $this; } public function getLoanPurpose(): ?string { return $this->LoanPurpose; } public function setLoanPurpose(string $LoanPurpose): self { $this->LoanPurpose = $LoanPurpose; return $this; } public function getModeOfPayment(): ?string { return $this->ModeOfPayment; } public function setModeOfPayment(string $ModeOfPayment): self { $this->ModeOfPayment = $ModeOfPayment; return $this; } public function getDateApplied(): ?\DateTimeInterface { return $this->DateApplied; } public function setDateApplied(\DateTimeInterface $DateApplied): self { $this->DateApplied = $DateApplied; return $this; } public function getDateEncoded(): ?\DateTimeInterface { return $this->DateEncoded; } public function setDateEncoded(\DateTimeInterface $DateEncoded): self { $this->DateEncoded = $DateEncoded; return $this; } public function getChairApproved(): ?string { return $this->ChairApproved; } public function setChairApproved(string $ChairApproved): self { $this->ChairApproved = $ChairApproved; return $this; } public function getGenApproved(): ?string { return $this->GenApproved; } public function setGenApproved(string $GenApproved): self { $this->GenApproved = $GenApproved; return $this; } public function getTeasApproved(): ?string { return $this->TeasApproved; } public function setTeasApproved(string $TeasApproved): self { $this->TeasApproved = $TeasApproved; return $this; } public function getLoanType(): ?string { return $this->LoanType; } public function setLoanType(string $LoanType): self { $this->LoanType = $LoanType; return $this; } public function getPrincipal(): ?int { return $this->Principal; } public function setPrincipal(int $Principal): self { $this->Principal = $Principal; return $this; } public function getMonthlyInstallment(): ?int { return $this->MonthlyInstallment; } public function setMonthlyInstallment(int $MonthlyInstallment): self { $this->MonthlyInstallment = $MonthlyInstallment; return $this; } public function getContractRate(): ?string { return $this->ContractRate; } public function setContractRate(string $ContractRate): self { $this->ContractRate = $ContractRate; return $this; } public function getOtherCharges(): ?int { return $this->OtherCharges; } public function setOtherCharges(int $OtherCharges): self { $this->OtherCharges = $OtherCharges; return $this; } public function getNoOfInstallment(): ?int { return $this->NoOfInstallment; } public function setNoOfInstallment(int $NoOfInstallment): self { $this->NoOfInstallment = $NoOfInstallment; return $this; } public function getInterestRate(): ?string { return $this->InterestRate; } public function setInterestRate(string $InterestRate): self { $this->InterestRate = $InterestRate; return $this; } public function getMonthlyRate(): ?int { return $this->MonthlyRate; } public function setMonthlyRate(int $MonthlyRate): self { $this->MonthlyRate = $MonthlyRate; return $this; } public function getPMR(): ?int { return $this->PMR; } public function setPMR(int $PMR): self { $this->PMR = $PMR; return $this; } public function getBaseInterestRate(): ?string { return $this->BaseInterestRate; } public function setBaseInterestRate(string $BaseInterestRate): self { $this->BaseInterestRate = $BaseInterestRate; return $this; } public function getDeductionStart(): ?\DateTimeInterface { return $this->DeductionStart; } public function setDeductionStart(\DateTimeInterface $DeductionStart): self { $this->DeductionStart = $DeductionStart; return $this; } public function getDeductionEnd(): ?\DateTimeInterface { return $this->DeductionEnd; } public function setDeductionEnd(\DateTimeInterface $DeductionEnd): self { $this->DeductionEnd = $DeductionEnd; return $this; } public function getProcessingFee(): ?string { return $this->ProcessingFee; } public function setProcessingFee(string $ProcessingFee): self { $this->ProcessingFee = $ProcessingFee; return $this; } public function getComputerFee(): ?string { return $this->ComputerFee; } public function setComputerFee(string $ComputerFee): self { $this->ComputerFee = $ComputerFee; return $this; } public function getCapital(): ?string { return $this->Capital; } public function setCapital(string $Capital): self { $this->Capital = $Capital; return $this; } public function getNetLoan(): ?string { return $this->NetLoan; } public function setNetLoan(string $NetLoan): self { $this->NetLoan = $NetLoan; return $this; } } I need to display the name of the member instead of the id on the name column Please help. Thank you
  2. Thanks so much Barand. i figured it out, i forgot to include $font value on the code you gave.
  3. Now it does not write anything on the id cards when i run that code.
  4. Hi, I need some help please. here is what i want to do: 1. im making a script which will generate bulk id card populating the data from the database and displaying data to a single template and will generate that id cards in return. here is my script: $sql = mysqli_query($con, "SELECT * FROM employees"); header('Content-type: image/png'); $image = imagecreatefrompng('id-template.png'); $color = imagecolorallocate($image, 0, 0, 0); imagepng($image); while($rs = mysqli_fetch_assoc($sql)){ imagettftext($image, 13, 0, 60,117, $color, $font, $rs['empname']); //employee name location of the template $save = "id/".strtolower($rs['id']).".png"; imagepng($image, $save, 9, PNG_NO_FILTER); } This produces id card, but the data passed to each id card overlaps with the other. Please help me fix this problem. Thank you
  5. im wrong with the group structure. here is the correct grouping of array. <div class='fldgroup'> <input type="text" name="fld[0]"> <input type="text" name="fld[0]"> <input type="text" name="fld[0]"> <input type="text" name="sumfld[0]"> <button>Add Another Field</button> </div> <div class='fldgroup'> <input type="text" name="fld[1]"> <input type="text" name="fld[1]"> <input type="text" name="fld[1]"> <input type="text" name="sumfld[1]"> <button>Add Another Field</button> </div> <button>Add Another Field Group</button>
  6. Hello, Im hoping to get help from here, i have arrays of text fields that i need to get sums,.. <div class='fldgroup'> <input type="text" name="fld[0]"> <input type="text" name="fld[0]"> <input type="text" name="fld[0]"> <input type="text" name="sumfld[0]"> <button>Add Another Field</button> <input type="text" name="fld[1]"> <input type="text" name="fld[1]"> <input type="text" name="fld[1]"> <input type="text" name="sumfld[1]"> <button>Add Another Field</button> </div> <button>Add Another Group</button> how can i get the sum of all fld[0] and put it to sumfld[0] same as the fld[1] to sumfld[1],.. every text field is dynamically added using clone., i hope somebody can help me with this.... Thank you in advance...
  7. hi im not having a problem on the time format here.. my only problem is how to implement the "invoice_total != 0" for 30% and it will not be used for 20%
  8. I would like to simplify my request... here is my query SELECT emp_id, ROUND(SUM((Invoice.invoiceTotal-NewQuote.total)*.30),2) AS thirtypercent, ROUND(SUM(NewQuote.total*.20),2) AS twentypercent FROM `NewQuote` INNER JOIN Invoice ON Invoice.quoteID=NewQuote.quoteID INNER JOIN schedules ON schedules.quoteId=NewQuote.quoteID WHERE (rem=1 OR rem=2) AND (schedules.redo IS NULL) AND invoiceTotal!=0 AND (DATE_FORMAT(date_start, '%m/%d/%Y') >= '07/01/2016') AND ((DATE_FORMAT(date_start, '%m/%d/%Y')<='07/31/2016')) GROUP BY emp_id What im aiming here is this line "AND invoiceTotal!=0" should only be used in getting the thirtypercent and should not be applied in getting the twentypercent. Can you help me on how i can do this? Thank you
  9. hi there, can i ask some help please. i need to get the addon percentage on my database... add on is being computed based on the difference between an invoice and estimate. my query goes like this: SELECT COUNT(estimate) as est, SUM(invoice-estimate) as addons, SUM(addons / est) * 100 as Percentage FROM tblestimates What is the best way to do this? i know that i cant use aliases on the computation i made. Thank you
  10. Hi Here is my problem https://jsfiddle.net/mphur5eq/14/ I have two tables on the left section1 on top and section2 at the bottom each section has its own button to insert row section 1 has different number of fields than that on section 2. the problem is when i clicked on New Row on section 2 it clones the row from section 1 which is wrong, it should clone the row of the section where it belongs. can you help me with this? Thank you
  11. Solved https://jsfiddle.net/mphur5eq/12/
  12. Hi Thank you for the response. COPY button will be used only once. so the only change i made is in the New Row button which will be used multiple times so i make use class instead of id on it. https://jsfiddle.net/mphur5eq/9/ however when i tested, when i clicked on the New Row button on the form on the right the left rows increases instead of the right row where the button is clicked can you provide an edit to the jsfiddle. thank you
  13. updated version https://jsfiddle.net/mphur5eq/5/
  14. hi mate its me again asking questions on jquery clone. As solved before, i have a form that contains rows that is being cloned. (works perfect). Make a Copy of that form to the right side (Works great) here is my problem, when i make a copy of that form to the right the click event is lost on the New Row button to the form on the right. can you help me with this? Here is a working jsfiddle: https://jsfiddle.net/mphur5eq/5/
  15. Thank you so much Muddy... that works with charm...
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.