Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache

System:

Linux 4.18.0-553.100.1.el8_10.x86_64

PHP Version:

7.2.34

User:

jaindirectory

Directory:

/home/jaindirectory/public_html/jainsociety

Free Space:

32.42 GB

🔧 Quick Actions

✏️ Editing: generate_card_pdf_all_temple_new.php

<?php

require 'QR/QRCode.class.php'; // Include the QRCode class

use PHPMailer\PHPMailer\PHPMailer;

use PHPMailer\PHPMailer\Exception;

// Load Composer's autoloader

//require 'vendor/autoload.php';

require 'PHPMailer/src/Exception.php';

require 'PHPMailer/src/PHPMailer.php';

require 'PHPMailer/src/SMTP.php';

// Include autoloader

require_once 'dompdf/autoload.inc.php';

// Reference the Dompdf namespace

use Dompdf\Dompdf;

// Instantiate and use the dompdf class

$dompdf = new Dompdf();

if(!isset($_REQUEST['Submit1']))

{

date_default_timezone_set("Asia/Kolkata");

date_default_timezone_get();

$tname=$_REQUEST['temp_name'].' '.time();

include 'Database.php';

$crud = new Database();

$data='';

//print_r($_REQUEST['list']);

//$mid = implode(',', $_REQUEST['list']);

/*  function my_ucfirst($string, $e ='utf-8') {

if (function_exists('mb_strtoupper') && function_exists('mb_substr') && !empty($string)) {

$string = mb_strtolower($string, $e);

$upper = mb_strtoupper($string, $e);

preg_match('#(.)#us', $upper, $matches);

$string = $matches[1] . mb_substr($string, 1, mb_strlen($string, $e), $e);

} else {

$string = ucfirst($string);

}

return $string;

} */

function my_ucfirst($string) {

$string =ucwords(strtolower($string));

foreach (array('-', '\'') as $delimiter) {

if (strpos($string, $delimiter)!==false) {

$string =implode($delimiter, array_map('ucfirst', explode($delimiter, $string)));

}

return $string;

}

$files = glob('qr_images/*'); // get all file names

foreach($files as $file){ // iterate files

if(is_file($file))

unlink($file); // delete file

}

//$res = $crud->update('member',array('card_status'=>1),'id in ('.$mid.')');

$query = "select * from member where family_id in (232100100037,232100000038) order by relation_temple  ";

$result = $crud->getAllData($query);

$data.='

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Jain Society</title>

<style>

@media print {

body {-webkit-print-color-adjust: exact;}

}

.list{

width:100%;

}

.list th td {

cellpadding:5px;

}

body{

font-family:Calibri, sans-serif;

text-transform: capitalize;

color:black !important;

}

#card{

padding:15px 5px 15px 5px;

}

.card-number{

font-family:Calibri, sans-serif;

position:absolute;

left:90px;

top:30px;

font-weight:bolder;

font-size:22px;

color:black;

letter-spacing: 0px;

}

#qr-code{

position: absolute;

height: 55px;

top: 109px;

left: 20px;

}

#table{

position: absolute;

top: 74px;

font-size: 10px;

left: 90px;

line-height: 12px;

}

th{

font-size: 10px;

font-weight: 800;

}

#address{

position: absolute;

top: 211px;

font-size: 10px;

left: 10px;

color:#ffffff !important;

text-align:center !important;

width: 324px;

line-height: 8px;

}

#new{

margin-right:18px;

}

</style>

</head>';

$data.='<body>

<div class="row">';

$j=0;

$i=1;

$row_num=0;

foreach($result as $row){

$query_info = "select * from member_info where member_id='".$row['id']."' and name!='' order by id limit 10 ";

$result_info = $crud->getAllData($query_info);

if(isset($row['state']))

{

$state=$row['state'];

$s1 = "select * from state where state_name='".$state."' ";

$r1 = $crud->getSingleRow($s1);

$statecode = $r1['state_code'];

}

if(isset($row['city']))

{

$s2 = "select * from `city` where `city_name`='".$row['city']."'";

$r2 = $crud->getSingleRow($s2);

$citycode=$r2['district_code'];

}

if(isset($row['town']))

{

if($row['town']=='ujjain')

{

$towncode ='00';

}

if($row['town']=='tarana')

{

$towncode ='01';

}

if($row['town']=='badnagar')

{

$towncode ='02';

}

if($row['town']=='mahidpur')

{

$towncode ='03';

}

if($row['town']=='khachrod')

{

$towncode ='04';

}

if($row['town']=='ghatiya')

{

$towncode ='05';

}

if(isset($row['relation_temple']))

{

$t = "select * from `temple` where `id`='".$row['relation_temple']."'";

$r3 = $crud->getSingleRow($t);

$templecode = $r3['sub_community_id'];

}

$ii=$row['id'];

if(strlen($ii)==1)

{

$ii="0000".$ii;

}

if(strlen($ii)==2)

{

$ii="000".$ii;

}

if(strlen($ii)==3)

{

$ii="00".$ii;

}

if(strlen($ii)==4)

{

$ii="0".$ii;

}

if(strlen($ii)==5)

{

$family_id=$statecode.$citycode.$towncode.$templecode.$ii;

//echo $family_id ;

}

$i++;

$row_num++;

$data.='

<div class="col-xs-6 col-sm-4" id="card" >';

$n1=$url=substr($family_id,0,4);

$n2=$url=substr($family_id,4,4);

$n3=$url=substr($family_id,8,4);

try {

/**

* If you have PHP 5.4 or higher, you can instantiate the object like this:

* (new QRCode)->fullName('...')->... // Create vCard Object

$oQRC = new QRCode; // Create vCard Object

$oQRC->note($family_id)// Add Note

->finish(); // End vCard

$content = file_get_contents($oQRC->get(300));

file_put_contents('qr_images/'.$family_id.'.png', $content);

$qrcode= '<img id="qr-code" src="qr_images/'.$family_id.'.png" alt="QR Code" />'; // Generate and display the QR Code

//$oQRC->display(); // Display

} catch (Exception $oExcept) {

$qrcode= '<p><b>Exception launched!</b><br /><br />' .

'Message: ' . $oExcept->getMessage() . '<br />' .

'File: ' . $oExcept->getFile() . '<br />' .

'Line: ' . $oExcept->getLine() . '<br />' .

'Trace: <p/><pre>' . $oExcept->getTraceAsString() . '</pre>';

}

$data.=' <img src="image/card_blank.png" style="height:205px;" alt="">';

$data.='<h3 class="card-number">'. $n1.' '.$n2.' '.$n3.'</h3>'.$qrcode;

$data.='<table id="table">

<tr>

<th id="th1" style="width:50%;">Name</th><th id="th2" style="text-align:center; width:20%;">Age</th><th id="th3" style="text-align:center; width:28%;">Blood Group</th>

</tr>';

foreach($result_info as $row1){

# object oriented

$from = new DateTime($row1['dob']);

$to   = new DateTime('today');

$age=$from->diff($to)->y;

$data.='  <tr>

<td style="width:110px;">'. my_ucfirst($row1['name']).'</td>';

if($age=='0' || $age>'150') {

$age='-';

}

$blood_grp=$row1['blood_group'];

if($blood_grp=='none')

{

$blood_grp='-';

}

$data.='<td width="50px" align="center">'.$age.'</td>

<td width="45px" align="center">'.$blood_grp.'</td>

</tr>';

}

$data.=' </table>

<p id="address">'. my_ucfirst($row["address"]) .'</p>

</div>

$j++;

if($row_num==2){

$data.='</div>

<div class="row">';

$row_num=0; }

if($j==8)

{

$j=0;

$data.='<p style="page-break-before: always"></p>';

}

$data.='

</div>

</center>

</div>

</body>

</html>';

//echo $data; die;

$dompdf->loadHtml($data);

// (Optional) Setup the paper size and orientation

$dompdf->setPaper('A4', 'portrait');

$dompdf->set_option('defaultMediaType', 'all');

$dompdf->set_option('isFontSubsettingEnabled', true);

// Render the HTML as PDF

$dompdf->render();

// Output the generated PDF to Browser

//$dompdf->stream();

// Output the generated PDF (1 = download and 0 = preview)

$dompdf->stream("$tname.pdf", array("Attachment" =>false));

//$dompdf->stream("",array("Attachment"=>0));

$file_to_save = 'pdf_card/'.$tname.'.pdf';

//save the pdf file on the server

file_put_contents($file_to_save, $dompdf->output());

//print the pdf file to the screen for saving

/* header('Content-type: application/pdf');

header('Content-Disposition: inline; filename="'.$tname.'.pdf"');

header('Content-Transfer-Encoding: binary');

header('Content-Length: ' . filesize($file_to_save));

header('Accept-Ranges: bytes');

readfile($file_to_save);

/* $query = "select * from member where family_id in (232100100921,232100101029) order by id  ";

$result = $crud->getAllData($query); */

$f = fopen("pdf_card/generated_card_list.csv", "w");

//echo "hello"; die;

$head=array("S.No","Name","Address","Family ID","Mobile No","Temple","Sign");

fputcsv($f, $head);

$ii=1;

foreach($result as $row) {

$query_info = "select * from member_info where member_id='".$row['id']."' and relation='self' and name!='' order by id limit 1 ";

$result_info = $crud->getAllData($query_info);

foreach($result_info as $row1){

$from = new DateTime($row1['dob']);

$to   = new DateTime('today');

$age=$from->diff($to)->y;

$name=my_ucfirst($row1['name']);

if($age=='0' || $age>'150') {

$age='-';

}

$query_info12 = "select * from temple where id='".$row['relation_temple']."' ";

$result_info12 = $crud->getSingleRow($query_info12);

$temple=my_ucfirst(substr($result_info12['name'],0,30));

$address= my_ucfirst(substr($row["address"],0,35));

$array=array(

$ii,$name,$address,$row['family_id'],$row['family_mo'],$temple,"");

fputcsv($f, $array);

$ii++;	}

}

fclose($f);

$file1 = fopen('pdf_card/generated_card_list.csv', 'r');

while(!feof($file1)) {

echo fgets($file1);

}

fclose($file1);

$mail = new PHPMailer(true);

try {

//Server settings

$mail->SMTPDebug = 2;                                       // Enable verbose debug output

$mail->isSMTP();                                            // Set mailer to use SMTP

$mail->Host       = 'jaindirectory.in';  // Specify main and backup SMTP servers

$mail->SMTPAuth   = true;                                   // Enable SMTP authentication

$mail->Username   = 'test@jaindirectory.in';                     // SMTP username

$mail->Password   = 'jaindir@123';                               // SMTP password

$mail->SMTPSecure = 'tls';                                  // Enable TLS encryption, `ssl` also accepted

$mail->Port       = 587;                                    // TCP port to connect to

//Recipients

$mail->setFrom('test@jaindirectory.in', 'jain directory');

//$mail->addAddress('b2b@jaindirectory.in');     // Add a recipient

//$mail->addAddress('deepakjain0734@gmail.com');     // Add a recipient

$mail->addAddress('eway.dev1@gmail.com');     // Add a recipient

// Attachments

$mail->addAttachment('pdf_card/'.$tname.'.pdf');         // Add attachments

$mail->addAttachment('pdf_card/generated_card_list.csv');

// Content

$mail->isHTML(true);                                  // Set email format to HTML

$mail->Subject = 'Temple Pdf';

$mail->Body    = 'jain card attached';

$mail->AltBody = 'card';

$mail->send();

echo 'Message has been sent';

} catch (Exception $e) {

echo "Message could not be sent";

//echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generate_card_pdf_all_temple_new.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation