PDA

View Full Version : Problem in table format



newphpbees
16 Feb 2012, 06:14 PM
Hi...

Good day!

I just want to know how can I change the format of my table. here is my code:




<?php
include 'config.php';

$sql = "SELECT DATE_FORMAT(d.FROM_DATE, '%M %c') AS FROM_DATE, DATE_FORMAT(d.TO_DATE, '%M %c, %Y') AS TO_DATE, g.EMP_NO, g.fullName, g.Rate, g.Reg_Hours, g.Basic_Pay, g.OTReg_Hours, g.SunReg_Hours, g.OTSun_Hours, g.HolReg_Hours, g.HolRegOT_Hours, g.HolLeave_Hours_Tot, SUM(g.NPReg_Hours + g.NPSun_Hours + g.NPHol_Hours) AS NIGHT_PREMIUM, SUM(g.MealReg_Hours + g.MealSun_Hours) AS MEAL_ALLOWANCE, g.Cola_Hours, g.Basic_Pay, g.OTReg_Amt, g.SunReg_Amt, g.OTSun_Amt, g.HolReg_Amt, g.HolRegOT_Amt, g.HolLeave_Amt, g.NP_Amt, g.Meal_Amt, g.Cola_Amt, p.COMPANY_NAME, p.PERIOD, p.NAME, p.FIRST_LINE, p.RATE_Label, p.EARNINGS, p.HRS, p.AMOUNT, p.BASIC_PAY_Label, p.REGULAR_OVERTIME, p.SUN_SPEC_HOLIDAY, p.SUN_SPEC_HOL_OT, p.REG_HOLIDAY, p.REG_HOLIDAY_OT, p.HOLIDAY_LEAVE, p.NIGHT_PREMIUM_Label, p.MEAL_ALLOWANCE_Label, p.COLA, p.13TH_MONTH, p.SECOND_LINE FROM $PAYROLL.casual_payslip_label p, $PAYROLL.casual_generate_payroll g, $PAYROLL.casual_date_upload d GROUP BY g.EMP_NO"or die(mysql_error());
$rs_label = $conn2->GetAll($sql);

$smarty->assign('rs_label', $rs_label);
$smarty->display('payslip.tpl');
$smarty->display('casual_payslip.tpl');
?>

<div>
{section name=att loop=$rs_label}
<table class="stat">
<tr>
<td>{$rs_label[att].COMPANY_NAME}</td>
<tr/>

<tr>
<td>{$rs_label[att].PERIOD} {$rs_label[att].FROM_DATE}-{$rs_label[att].TO_DATE}</td>
<tr/>

<tr>
<td>{$rs_label[att].NAME} {$rs_label[att].fullName}</td>
</tr>

<tr>
<td>{$rs_label[att].FIRST_LINE}</td>
</tr>

<tr>
<td>{$rs_label[att].RATE_Label} {$rs_label[att].Rate}</td>
</tr>

<tr>
&nbsp;&nbsp;<td>{$rs_label[att].EARNINGS}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].HRS}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].AMOUNT}</td>
</tr>

<tr>
<td>{$rs_label[att].BASIC_PAY_Label}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].Reg_Hours}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].Basic_Pay}</td>
</tr>

<tr>
<td>{$rs_label[att].REGULAR_OVERTIME}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].OTReg_Hours}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].OTReg_Amt}</td>
</tr>

<tr>
<td>{$rs_label[att].SUN_SPEC_HOLIDAY}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].SunReg_Hours}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].SunReg_Amt}</td>
</tr>

<tr>
<td>{$rs_label[att].SUN_SPEC_HOL_OT}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].OTSun_Hours}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].OTSun_Amt}</td>
</tr>

<tr>
<td>{$rs_label[att].REG_HOLIDAY}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].HolReg_Hours}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].HolReg_Amt}</td>
</tr>

<tr>
<td>{$rs_label[att].REG_HOLIDAY_OT}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].HolRegOT_Hours}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].HolRegOT_Amt}</td>
</tr>

<tr>
<td>{$rs_label[att].HOLIDAY_LEAVE}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].HolLeave_Hours_Tot}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].HolLeave_Amt}</td>
</tr>

<tr>
<td>{$rs_label[att].NIGHT_PREMIUM_Label}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].NIGHT_PREMIUM}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].NP_Amt}</td>
</tr>

<tr>
<td>{$rs_label[att].MEAL_ALLOWANCE_Label}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].MEAL_ALLOWANCE}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{$rs_label[att].Meal_Amt}</td>
</tr>

<tr>
<td>{$rs_label[att].COLA}{$rs_label[att].Cola_Hours}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {$rs_label[att].Cola_Amt}</td>
</tr>

<tr>
<td>{$rs_label[att].SECOND_LINE}</td>
</tr>
</table>
{/section}
</div>


the output of this code:

Company Name
Period : jul 09- July 22,2011
Name : Juan Dela Cruz

Rate : 339.80
EARNINGS HRS AMOUNT
Basic Pay 91.45 3,884.34
Regular Overtime 0.00 0.00
Sun/Spec Holiday 0.00 0.00
Sun/Spec Hol. OT 0.00 0.00
Reg. Holiday 0.00 0.00
Reg. Holiday OT 0.00 0.00
Holiday/Leave 0.00 0.00
Night Premium 0.00 0.00
Meal Allowance 0.00 0.00
COLA (P28 Allow) 0.00 0.00
13th Month 0.00


Company Name
Period : jul 09- July 22,2011
Name : Ann Chin

Rate : 339.80
EARNINGS HRS AMOUNT
Basic Pay 100.00 4247.5
Regular Overtime 0.00 0.00
Sun/Spec Holiday 0.00 0.00
Sun/Spec Hol. OT 0.00 0.00
Reg. Holiday 0.00 0.00
Reg. Holiday OT 0.00 0.00
Holiday/Leave 0.00 0.00
Night Premium 0.00 0.00
Meal Allowance 0.00 0.00
COLA (P28 Allow) 0.00 0.00
13th Month 0.00


Company Name
Period : jul 09- July 22,2011
Name : John Lee

Rate : 339.80
EARNINGS HRS AMOUNT
Basic Pay 101 4289.96
Regular Overtime 0.00 0.00
Sun/Spec Holiday 0.00 0.00
Sun/Spec Hol. OT 0.00 0.00
Reg. Holiday 0.00 0.00
Reg. Holiday OT 0.00 0.00
Holiday/Leave 0.00 0.00
Night Premium 0.00 0.00
Meal Allowance 0.00 0.00
COLA (P28 Allow) 0.00 0.00
13th Month 0.00


Company Name
Period : jul 09- July 22,2011
Name : Mary Ann Chan

Rate : 339.80
EARNINGS HRS AMOUNT
Basic Pay 90 3,882.75
Regular Overtime 0.00 0.00
Sun/Spec Holiday 0.00 0.00
Sun/Spec Hol. OT 0.00 0.00
Reg. Holiday 0.00 0.00
Reg. Holiday OT 0.00 0.00
Holiday/Leave 0.00 0.00
Night Premium 0.00 0.00
Meal Allowance 0.00 0.00
COLA (P28 Allow) 0.00 0.00
13th Month 0.00

I have a lot of employee so the data is long.

I attach the format I want to happen.

Thank you

jassmee
08 Apr 2012, 11:58 PM
you are facing table format problem then check in Dreamweaver.in design mode you can check the table..