Reports
| S.No |
Receipt No |
Name |
Booked Date |
Mobile Number |
Appointment Date |
Country |
State |
Tax Value |
HSN |
GST % |
CGST |
SGST |
IGST |
Fees |
='".$date_paid1."' and DATE(appointment_date) <='".$date_paid12."' ";
}
if($_REQUEST['from']!="" && $_REQUEST['to']=="" )
{
$cond9.="and DATE(appointment_date) ='".$date_paid1."'";
}
if($_REQUEST['from']!="" && $_REQUEST['to']=="" )
{
$cond9.="and DATE(appointment_date) ='".$date_paid12."'";
}
if($_REQUEST['from']!="" && $_REQUEST['to']!="" )
{
$cond9.="and DATE(appointment_date) >='".$date_paid1."' and DATE(appointment_date) <='".$date_paid12."' ";
}
$mann =0;
$table_name="tbl_appointment ";
$Query = "SELECT * from tbl_appointment where status>0 and status<=3 and payment_type!='Cash' $cond9 order by id asc ";
$namesss=$DB->query($Query);
$nsssss=mysql_num_rows($namesss);
$manssss='0';
$pundai=1;
while ($rowsss = mysql_fetch_array($namesss)) {
$date=$rowsss['date'];
$me_id=$rowsss['mem_id'];
$status=$rowsss['status'];
$document_name=$rowsss['document_name'];
$Query = "SELECT * from `tbl_member` where id='$me_id' ";
$name=$DB->query($Query);
$no=mysql_num_rows($name);
$row = mysql_fetch_array($name);
$skypeid=$row['skypeid'];
sprintf("%02d", $to_hour);
$docname=$rowsss['document_name'];
$user = "SELECT * FROM shop_user where phone='".$row['phone']."'";
$user_info=$DB->query($user);
$user_row = mysql_fetch_array($user_info);
$cgst='';
$sgst = '';
$igst='';
$gst = '';
$tax_amount='';
$my_tax='';
$gst_percent = '';
$gst_rate = 18; // GST percentage
if($row['country'] == 'India'){
$base_price = $rowsss['amount'] / (1 + $gst_rate / 100);
$my_tax = $rowsss['amount'] - $base_price;
$temp_tax_amount = $rowsss['amount'] - $my_tax;
$cgst = number_format((float)$my_tax / 2, 2, '.', '');
$sgst = number_format((float)$my_tax / 2, 2, '.', '');
$tax_amount = number_format((float)$temp_tax_amount, 2, '.', '');
}
if($row['country'] == 'India'){
$state = $user_row['state'];
$country = $user_row['contry'];
$gst_percent = '18';
if($user_row['state'] != 'Tamilnadu'){
$cgst='';
$sgst = '';
$igst = number_format((float)($rowsss['amount'] - $base_price), 2, '.', '');;
}else{
$igst = "0.00";
}
}else{
$state = $user_row['contry'];
$country = $user_row['contry'];
$gst_percent = '';
}
?>
|
OC- |
|
|
|
:
|
|
|
|
999319 |
18 |
|
|
|
|
| |
|
|
|
|
|
Total |
|
|