|
Server IP : 2a02:4780:3:1378:0:3736:a38e:10 / Your IP : 18.222.142.215 Web Server : LiteSpeed System : Linux sg-nme-web1278.main-hosting.eu 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/demo/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// First we execute our common code to connection to the database and start the session
require("common.php");
// At the top of the page we check to see whether the user is logged in or not
if(empty($_SESSION['user']))
{
// If they are not, we redirect them to the login page.
header("Location: login.php");
// Remember that this die statement is absolutely critical. Without it,
// people can view your members-only content without logging in.
die("Redirecting to login.php");
}
// Everything below this point in the file is secured by the login system
// We can display the user's username to them by reading it from the session array. Remember that because
// a username is user submitted content we must use htmlentities on it before displaying it to the user.
$a=$_SESSION['user'];
include("config/dbconnect.php");
$SchoolCode=$_SESSION['code'];
$sel_school=mysqli_query($con,"select * from schools where schoolCode='$SchoolCode'");
$schoolformatfile="pay_fees_process_calcu_preview.php";
$smsId="";
$smsAPI="";
$smsURL="";
$smsTempId="";
$smsown_num="";
$smsIsActive=0;
$sms_schoolname="";
$wpIsActive = 0;
while($school_row=mysqli_fetch_array($sel_school))
{
$schoolformatfile=$school_row['Receipt_file'];
$smsId=$school_row['smsId'];
$smsAPI=$school_row['smsAPI'];
$smsURL=$school_row['smsURL'];
$smsTempId=$school_row['smsTempId'];
$smsown_num=$school_row['feesAlertNumbers'];
$smsIsActive=$school_row['smsIsActive'];
$sms_schoolname=$school_row['sms_schoolname'];
$wpIsActive = $school_row['whatsappIsActive'];
}
?>
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script>
//
$("#loading").ajaxStart(function () {
$(this).show();
});
$("#loading").ajaxStop(function () {
$(this).hide();
});
document.location="<?php echo $schoolformatfile; ?>";
</script>
</head>
<body>
<div id="loading" style="display:none;">
Loading Please Wait....
<img src="ajax-loader.gif" alt="Loading" />
</div>
<div>
<?php
//include "config/config.php";
mysqli_close($con);
include "config/config.php";
$countCC=$_SESSION['subamount'];
include_once 'sms.php';
$today= $_POST["today"];
$_SESSION['today']=$today;
//$today= date("Y-m-d");
$reci=$_POST["optionsRadios"];
$_SESSION['reci']=$reci;
$hdr=array();
$h=array();
$subAr=array();
$gt=0;
$ctr=0;
$headAmt="";
$ReciptList="";
$sublist="";
$totaa=0;
$reptview="";
$reptviewBook="";
$qq3=$_POST["ReceiptHead"];
$_SESSION['ReceiptHead']=$qq3;
if (isset($_SESSION['subAr']))
if ($_SESSION['subAr'] != NULL)
{
$subAr=$_SESSION['subAr'];
}
if (isset($_SESSION['headAr']))
if ($_SESSION['headAr'] != NULL){
$headAr=$_SESSION["headAr"];
}
if (isset($_SESSION['key']))
if ($_SESSION['key'] != NULL){
$sid=$_SESSION['key'];
}
$paymentmode=$_POST["paymentmode"];
$_SESSION['MainMode']=$paymentmode;
$Fine=$_POST["Fine"];
$total=$_POST['total'];
$Grand_Total=$_POST["Grand_Total"];
$smsbl="";
$dn="";
if($paymentmode == "Cash")
{
$Cash=$_POST["Cash"];
$flag=1;
$dn=$_POST["cash_details"];
}
if($paymentmode == "Online")
{
$dn=$_POST["transaction_id_date"];
$flag=1;
}
if($paymentmode == "Cheque")
{
$dn=$_POST["Cheque_date_number"];
$flag=0;
}
if($paymentmode == "DD")
{
$dn=$_POST["DD_date_number"];
$flag=1;
}
if($paymentmode == "Challan")
{
$dn=$_POST["Challan_date_number"];
$flag=1;
}
if($paymentmode == "ChallanTP")
{
$paymentmode= "Challan";
$dn=$_POST["Challan_date_number"];
$flag=0;
}
//echo"<pre>"; print_r($subAr); exit;
foreach ($subAr as $id)
{
$sub_res1=mysqli_query($con,"select * from `stud_basic2` where `Subhead_Id` = '$id' and `Stud_Id` = '$sid'");
$sub1=mysqli_fetch_array($sub_res1);
array_push($hdr, $sub1['Head_Id']);
}
foreach ($subAr as $key => $value)
{
$h[$hdr[$key]][] = $value;
}
foreach ($headAr as $headId)
{
$subheadid="";
$c_due=0;
$totaa=0;
for ($i=0; $i < count($h[$headId]); $i++)
{
$id1=$h[$headId][$i]; //sub head
$sub_res=mysqli_query($con,"select * from `stud_basic2` where `Subhead_Id` = '$id1' and `Stud_Id` = '$sid'");
$sub=mysqli_fetch_array($sub_res);
/* $sub['Head_Id'] //Head Id
$sub['Subhead_Id'] //Subhead ID
$sub['Total_Amount'] //Total Amount
$sub['Paid'] //Paid Amount
$sub['Balance'] //Balance */
//for sms
$HeadNm=mysqli_query($con,"SELECT * from `head` where `Head_Id` = '$sub[Head_Id]' ");
$head_res_sms=mysqli_fetch_array($HeadNm);
$smsbl= $smsbl.$head_res_sms["Name"]." / TOT:".$sub['Total_Amount'] ."/ PD: ".$sub['Paid']." / BLC :".$sub['Balance'];
if($flag==1)
{
if($paymentmode=='Cash')
$Dr_Ledger_Name='Cash';
if($paymentmode !='Cash')
{
$BankGet_res=mysqli_query($con,"SELECT * from `head` where `Head_Id` = '$sub[Head_Id]' ");
$BankGet_Details=mysqli_fetch_array($BankGet_res);
$Bank_res=mysqli_query($con,"SELECT * from `bankaccounts` where `Id` = '$BankGet_Details[Bank_Code]' ");
$Bank_Details=mysqli_fetch_array($Bank_res);
$AccountNumber_RightFour=substr($Bank_Details['Account_Number'], -4);
$Dr_Ledger_Name="$Bank_Details[Bank_Name]"."-"."$AccountNumber_RightFour";
}
$Paid=$sub['Paid'];
$Balance=$sub['Balance'];
$Paid=$Paid+$countCC[$ctr];
$Balance=$Balance-$countCC[$ctr];
//echo "PD=".$Paid."/ID=".$id1."<br />";
if($_SESSION['Total_Amount'.$id1]=="0")
{
//echo "UPDATE `stud_basic2` SET `Paid` = '$Paid', Total_Amount= '0', `Balance` = '0' WHERE `Subhead_Id` = '$id1' and `Stud_Id`='$sid'"."<br>";
$savedata=mysqli_query($con,"UPDATE `stud_basic2` SET `Paid` = '$Paid', Total_Amount= '0', `Balance` = '0' WHERE `Subhead_Id` = '$id1' and `Stud_Id`='$sid'");
}
else
{
//echo "UPDATE `stud_basic2` SET `Paid` = '$Paid', `Balance` = '$Balance' WHERE `Subhead_Id` = '$id1' and `Stud_Id`='$sid'"."<br>";
$savedata=mysqli_query($con,"UPDATE `stud_basic2` SET `Paid` = '$Paid', `Balance` = '$Balance' WHERE `Subhead_Id` = '$id1' and `Stud_Id`='$sid'");
}
if(!$savedata)
{
echo("Error description: er1" . mysqli_error($con));
}
// Accounts Vochers Pass Start
$subn_res=mysqli_query($con,"select `Name` from `sub_head` where `Sub_Id` = '$id1'");
$subn=mysqli_fetch_array($subn_res);
$ExitsOrNot_res=mysqli_query($con,"SELECT * FROM `vochers` where `Date` = '$today' and `Cr_Ledger` = '$subn[0]'
and `Dr_Ledger` = '$Dr_Ledger_Name' ");
$ExitsOrNot=mysqli_num_rows($ExitsOrNot_res);
$ExistedAmount=mysqli_fetch_array($ExitsOrNot_res);
// $subn[0] - Subhead Name
if($ExitsOrNot > 0 ) // Update
{
$ExistedAmount['Cr_Amount']+=$countCC[$ctr];
// `Dr_Amount` = '$ExistedAmount[Cr_Amount]' WHERE `V_Id` = '$ExistedAmount[V_Id]'";
if($SchoolCode != "MGMS") {
if(!mysqli_query($con,"UPDATE `vochers` SET `Cr_Amount` = '$ExistedAmount[Cr_Amount]',
`Dr_Amount` = '$ExistedAmount[Cr_Amount]' WHERE `V_Id` = '$ExistedAmount[V_Id]'"))
{
echo("Error description:1 " . mysqli_error($con));
}
}
}
else // Insert
{
if(!$v_counter_res=mysqli_query($con,"select MAX(`v_counter`) from `vochers` where `Type` = 'Recipt'"))
{
echo("Error description:2 " . mysqli_error($con));
}
$rep_code=mysqli_fetch_array($v_counter_res);
$v_counter=$rep_code['0']+1;
if($SchoolCode != "MGMS") {
if(!mysqli_query($con,"INSERT INTO `vochers` (`Date`, `v_counter`, `Type`, `Cr_Ledger`, `Dr_Ledger`, `Cr_Ledger_Type`, `Dr_Ledger_Type`, `Cr_Amount`, `Dr_Amount`, `Nrtn`) VALUES ('$today','$v_counter','Recipt','$subn[0]',
'$Dr_Ledger_Name','Income/Revenue','Current Assets','$countCC[$ctr]','$countCC[$ctr]','Fees Collected')"))
{
echo("Error description:3 " . mysqli_error($con));
}
}
}
//Accounts Vocher End
}
$subheadid=$subheadid."/".$sub['Subhead_Id'];
$subb_res=mysqli_query($con,"select * from `sub_head` where Sub_Id = '$sub[Subhead_Id]'");
$subb=mysqli_fetch_array($subb_res);
//$totaa=$totaa+$subb['Amount'];
$totaa=$totaa+$countCC[$ctr]; //Imp
$sublist=$sublist."/".$sub['Subhead_Id'];
$headAmt=$headAmt."/".$countCC[$ctr];
$ctr++;
} // subheadloop
$rep_code_res=mysqli_query($con,"select * from `head` where Head_Id = '$headId'");
$rep_code=mysqli_fetch_array($rep_code_res);
/*Head Recp Name*/
$Recp_Book_Name=$rep_code['ReciptName'];
if(!$rep_code_res1=mysqli_query($con,"select MAX(`ReciptCounter`) AS MaxReciptCounter, MAX(`Recp_Book_Counter`) AS MaxRecp_Book_Counter from `paid_fees` where `Recp_Book_Name` = '$Recp_Book_Name'"))
{
echo("Error description: " . mysqli_error($con));
}
$rep_code1=mysqli_fetch_array($rep_code_res1);
$cnt=$rep_code1['MaxReciptCounter']+1;
$Recp_Book_Counter=$rep_code1['MaxRecp_Book_Counter']+1;
$Recp_Book_No="$rep_code[ReciptName]"."-"."$cnt";
$ReciptCounter="$rep_code[ReciptName]"."-"."$cnt";
$reptview="$ReciptCounter"."/"."$reptview";
$reptviewBook="$Recp_Book_No"."/"."$reptviewBook";
$due_res=mysqli_query($con,"SELECT * FROM `head` where `Head_Id` = '$headId'");
$due=mysqli_fetch_array($due_res);
if($due['Last_Date'] < $today)
{
$date1=date_create("$due[Last_Date]");
$date2=date_create("$today");
$diff=date_diff($date1,$date2);
$difff= $diff->format("%a");
$c_due=$due['Fine_Amount']*$difff;
}
$g_t=$totaa+$c_due;
$ReciptList="$ReciptList"."/"."$ReciptCounter";
if(mysqli_query($con,"INSERT INTO `paid_fees`
(`Stud_Id`,`Recipt_No`,`ReciptCounter`,`Recp_Book_Name`, `Recp_Book_No`, `Recp_Book_Counter`, `Head_Id`, `Subhead_Ids`,`Sub_Amounts`, `Paid_date`, `Mode`,`DateNumber`, `Fine_Amount`, `Online_Charge`, `Total_Amount`, `Grand_Total`, `flag`,`user`)
VALUES
('$sid','$ReciptCounter','$cnt','$Recp_Book_Name','$Recp_Book_No','$Recp_Book_Counter', '$headId', '$subheadid','$headAmt', '$today','$paymentmode','$dn', '$c_due', '0', '$totaa', '$g_t', '$flag','$a[username]')"))
{
//header("location:pay_fees_process_calcu.php");
}
else
{
echo("Error description: " . mysqli_error($con));
}
$headAmt="";
$_SESSION['ReciptList']=$ReciptList;
$_SESSION['ReciptBookNumbers']=$reptviewBook;
} // head loop
//header("Location: login.php");
// header("Location: pay_fees_process_calcu_preview.php");
//Send SMS To Student
if($smsIsActive=="1")
{
$r1=mysqli_query($con,"select * from `stud_basic` where `Stud_Id` = '$sid'");
$row1=mysqli_fetch_array($r1);
//$receiver="9898244359,8050482213";
$receiver=$row1['Phone'];
if($smsown_num!="")
{
$receiver=$receiver.",".$smsown_num;
}
$today= date("d-m-Y");
if($SchoolCode=="smvclg")
{
$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$paymentmode." Thanking You- EVIHBL";
//$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$paymentmode." Thanking You. -smv pu college -smv pu college";
}
else
{
$newText = $paymentmode." ".$sms_schoolname;
$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$newText." Thanking You- EVIHBL";
//$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$newText." Thanking You";
//$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$paymentmode." Thanking You -".$sms_schoolname;
}
$smsResult=SendSMSToUser($smsURL,$smsAPI,$smsId,$smsTempId,$receiver,$msg);
}
if($wpIsActive=="1")
{
$r1=mysqli_query($con,"select * from `stud_basic` where `Stud_Id` = '$sid'");
$row1=mysqli_fetch_array($r1);
//$receiver="9898244359,8050482213";
$receiver=$row1['Phone'];
if($smsown_num!="")
{
$receiver=$receiver.",".$smsown_num;
}
$today= date("d-m-Y");
if($SchoolCode=="smvclg")
{
$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$paymentmode." Thanking You- EVIHBL";
//$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$paymentmode." Thanking You. -smv pu college -smv pu college";
}
else
{
$newText = $paymentmode." ".$sms_schoolname;
$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$newText." Thanking You- EVIHBL";
//$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$newText." Thanking You";
//$msg="Dears ". $row1['Name']." We Received Rs ".$Grand_Total." on ".$today." in the Mode of ".$paymentmode." Thanking You -".$sms_schoolname;
}
$smsResult=sendWhatsappWithGlobal($receiver, $msg);
}
?>
</div>
</body>
</html>