} $fieldlist = "topic"; $r1 = Model::view($tablename, $cond, $fieldlist); $i = 0; $pdf->AddPage(); $pdf->SetFont("Arial", "B", "15"); $pdf->Cell(0, 5, $erp_course, 0, 1, "L"); $pdf->SetFont("Arial", "", "10"); $pdf->Cell(0, 5, "", 0, 1, "C"); while ($rr = mysql_fetch_assoc($r1)) { $i++; $pdf->Cell(0, 5, '(' . $i . '). ' . $rr['topic'], 0, 1); //$pdf->Cell(60,-5,$rr['topic'],0,1,"C"); } if ($course == 'Foundation Level ') { $r1 = Model::view($tablename, $cond2, $fieldlist); $pdf->Cell(0, 5, "", 0, 1, "C"); $pdf->SetFont("Arial", "B", "15"); $pdf->Cell(0, 5, preg_replace('/[0-9]/', '2', $erp_course), 0, 1, "L"); $pdf->SetFont("Arial", "", "10"); $pdf->Cell(0, 5, "", 0, 1, "C"); $i = 0; while ($rr = mysql_fetch_assoc($r1)) { $i++; $pdf->Cell(0, 5, '(' . $i . '). ' . $rr['topic'], 0, 1); //$pdf->Cell(60,-5,$rr['topic'],0,1,"C"); } } $pdf->Output("Certificate", 'I'); } ?>
public function sittings() { $model = new Model(); $model->view(); $model->sittings(); }
<!-- ####################################################################################################### --> <!-- ####################################################################################################### --> <!-- ####################################################################################################### --> <!-- InstanceBeginEditable name="Contents" --> <!-- Yogesh --> <div class="wrapper row4"> <div id="container" class="clear"> <h2>View Applications for Training Centres/Partners</h2> <h2 class="title"></h2> <p> <div align="right"><b>Status Code :</b> <font color="green">Confirmed</font> Pending <font color="#FF0000">Deleted</font></div> <?php require '../model.php'; require '../database.php'; $r = Model::view('trarningcentre order by type,city, name', '', '*'); echo "<table border=\"2\">"; echo "<tr>"; echo "<th> Application No</th>"; echo "<th> Type</th>"; echo "<th> City</th>"; echo "<th> Institute Name</th>"; echo "<th> Address</th>"; echo "<th> Contact Person</th>"; echo "<th> Contact Number</th>"; echo "<th> Email</th>"; echo "<th> Area</th>"; echo "<th> Action</th>"; echo "<th> Current Status</th>"; echo "</tr>"; while ($row = mysql_fetch_array($r)) {
<div id="container" class="clear"> <h2>Excel To Database</h2> <h2 class="title"></h2> <p> <form name="form1" method="post" enctype="multipart/form-data" action="ExcelToDatabase_php.php"> <table align="center"> <tr> <td>Choose Xls File</td> <td><input type="file" require name="xls" /></td> </tr> <tr> <td>Select College Name</td> <td><select require name="cl_name" onchange="batch(this.value,'batch','s_batch','getValue()');"> <option value="">Select College Name</option> <?php $result = Model::view('register', "type='cl'", "name,ID"); while ($row = mysql_fetch_array($result)) { echo "<option value='" . $row['ID'] . "'>" . $row['name'] . "</option>"; } ?> </select></td> </tr> <tr> <td>Select Batch ID</td> <td id="batch"></td> </tr> <tr> <td></td> <td> <input type="text" required name="batches_id" /> </td>
<!-- ####################################################################################################### --> <!-- InstanceBeginEditable name="Contents" --> <!-- Yogesh --> <div class="wrapper row4"> <div id="container" class="clear"> <h2>Study Material</h2> <h2 class="title"></h2> <p> <table> <form method="post" action="#" enctype="multipart/form-data"> <tr> <td>Session ID</td> <?php $get = $_GET['session_id']; $get = explode('_', $get); $result = Model::view($table, "session_id='{$get['0']}'", '*'); ?> <td><input type="hidden" name="session_id" value="<?php echo $get[0]; ?> " /><?php echo $get[0]; ?> </td> </tr> <tr> <td>E-Learning URL</td> <td><input type="url" name="e_learning_url" /> <?php while ($row = mysql_fetch_array($result)) { $url = $row['e_learning_url'];
$actual_end_time = explode(':', date('G:i:s')); $h1 = $end_time[0]; $m1 = $end_time[1]; $h2 = $actual_end_time[0]; $m2 = $actual_end_time[1]; $hm1 = $h1 * 60 + $m1; $hm2 = $h2 * 60 + $m2; $df = $hm2 - $hm1; $res = Model::view('session_entry', "ID='" . $_POST['id'] . "'", 'duration'); //$sql1="SELECT duration FROM session_entry WHERE ID='".$_POST['id']."'"; //$res=mysql_query($sql1)or die(mysql_error()); $row = mysql_fetch_array($res); $limit = $row['duration']; if ($df <= $limit) { if ($_POST['test_id'] == $_POST['cr_test_id']) { $res = Model::view('test_paper', "session_id='{$session_id}' order by ID asc limit 15", '*'); //$sql1="SELECT * FROM test_paper WHERE session_id='$session_id' order by ID asc limit 15"; //$res=mysql_query($sql1)or die(mysql_error()); $i = 0; while ($row = mysql_fetch_array($res)) { $i++; ?> <tr bgcolor="#336699" style="color:#FFFFFF"> <td width="80px"><input type="hidden" value="<?php echo $row['question_no']; ?> " name="question_no[]" /><?php echo "Question-" . $row['question_no']; ?> </td>
?> </td></tr> <tr><td colspan="2" align="center"><input type="submit" name="submit" value="Claim" /></td></tr> </form--> </table> <table> <tr style="color:#FFFFFF; background:#9933CC"><td>BDM ID</td><td>Claim Point</td><td>Apply Date</td><td>Cashed Point</td><td>Payed Date</td><td>Balance</td><td>Action</td></tr> <?php $id = ''; if (isset($_GET['id'])) { $id = $_GET['id']; } if ($id != '') { $s = Model::view("bdm_payment", "bdm_id='{$id}' order by cashed_point asc", "*"); } else { $s = Model::view("bdm_payment", "", "*"); } while ($row = mysql_fetch_array($s)) { ?> <tr><td><?php echo $row['bdm_id']; ?> </td><td><?php echo $row['claim_point']; ?> </td><td><?php echo $row['apply_date']; ?> </td><td><?php echo $row['cashed_point']; ?>
$s = mysql_num_rows($r1); $s = $s + 1; $tablename = 'register'; $field_list = "ID,register_id,course_type,course_level"; $condition = "ID=(select ID from {$tablename} where email='{$id}' and type='cl')"; $result = Model::view($tablename, $condition, $field_list); $row = mysql_fetch_array($result); $no = str_pad("{$s}", 4, "0", STR_PAD_LEFT); echo $row['register_id'] . "-" . "{$no}"; ?> "></td></tr> <tr><td>Student From Batch</td><td><select name="pre_batch"> <option value="">Select Batch</option> <?php $condition = "ID='" . $row['ID'] . "' and record_status!='Deleted'"; $r1 = Model::view($table, $condition, '*'); while ($s = mysql_fetch_array($r1)) { echo "<option>" . $s['erp_course_code'] . "</option>"; } ?> </select> </td> </tr> <tr> <td> </td> <td align="right"> <input type="submit" name="transfer_student" value="Submit" /> </td> </tr> </table>
$course = $_POST['erp_course_' . "{$i}"]; } else { $course = str_replace('Advanced Level', 'Module Specialization', $_POST['erp_course_' . "{$i}"]); } $tablename = 'erp_course'; $field = 'no_of_session'; $condition = "name_of_erpcourse='{$course}'"; $res = Model::view($tablename, $condition, $field); //$sql="select * from erp_course where name_of_erpcourse='$course'"; //$res=mysql_query($sql)or die(mysql_error()); $row = mysql_fetch_array($res); $session = $row['no_of_session']; $tablename = 'session_entry'; $field = '*'; $condition = "batch_id='" . $_POST['batch_id_' . "{$i}"] . "' and name_of_erp_course='{$course}'"; $res1 = Model::view($tablename, $condition, $field); //$sql1="select * from session_entry where batch_id='".$_POST['batch_id_'."$i"]."' and name_of_erp_course='".$_POST['erp_course_'."$i"]."'"; //$res1=mysql_query($sql1)or die(mysql_error()); $total = mysql_num_rows($res1); if ($total < $session || $total == 0) { $set_value = "batch_id='" . $_POST['batch_id_' . "{$i}"] . "', name_of_erp_course='{$course}', email='{$id}', session_no='" . $_POST['session_no_' . "{$i}"] . "', date='" . $_POST['year_' . "{$i}"] . "/" . $_POST['month_' . "{$i}"] . "/" . $_POST['day_' . "{$i}"] . "', start_time='" . $_POST['hour_' . "{$i}"] . ":" . $_POST['minute_' . "{$i}"] . "'"; $result = Model::save($tablename, $set_value); //$query="insert into session_entry set batch_id='".$_POST['batch_id_'."$i"]."', name_of_erp_course='".$_POST['erp_course_'."$i"]."', email='$id', session_no='".$_POST['session_no_'."$i"]."', date='".$_POST['year_'."$i"]."/".$_POST['month_'."$i"]."/".$_POST['day_'."$i"]."', start_time='".$_POST['hour_'."$i"].":".$_POST['minute_'."$i"]."'"; //$result=mysql_query($query)or die(mysql_error()); header('location:college panel.php'); } else { if ($total == $session) { echo "<script>alert('This batch session limit is full');window.location.assign('college panel.php');</script>"; } } }
$ro = mysql_fetch_array($rs); ?> <td align="left">Your Answer--<?php echo str_replace(",", ", ", $ro['user_answer']); ?> </td> <td align="right">Marks Obtained--<?php echo $ro['marks_to_ten']; ?> /15</td> </tr> </table> <table> <tr><td align="center" colspan="2">Correct Answer</td></tr> <?php $res = Model::view('test_paper', "session_id='" . $url[2] . "' order by ID asc limit 15", "*"); //$sql1="SELECT * FROM test_paper WHERE session_id='".$url[2]."' order by ID asc limit 15"; //$res=mysql_query($sql1)or die(mysql_error()); $i = 0; while ($row = mysql_fetch_array($res)) { $i++; ?> <tr bgcolor="#336699" style="color:#FFFFFF"> <td width="80px"><input type="hidden" value="<?php echo $row['question_no']; ?> " name="question_no[]" /><?php echo "Question-" . $row['question_no']; ?> </td>
" <?php if ($row['payment_status'] == 'Yes') { echo "checked"; } ?> name="session_id[]" /></td> <td><?php echo $row['batch_id']; ?> </td> <td><?php echo $row['session_no']; ?> </td> <td><?php $r1 = Model::view('register', "email='" . $row['actual_trainer_id'] . "' and type='tr'", "name"); $row1 = mysql_fetch_array($r1); echo $row1['name']; ?> </td> <td><?php echo $row['actual_trainer_id']; ?> </td> </tr> <?php } ?> <input type="hidden" name="sid" value="<?php echo $s_id; ?>
<td></td> </tr> </table> <table width="100%"> <tr><td align="center" bgcolor="#666666"><font color="#FFFFFF"><b>Motivational Video</b></font></td></tr> <tr> <td> <?php $result = Model::view('study_material_video order by ID', "", '*'); //$query="select * from study_material_video order by ID"; //$result=mysql_query($query)or die(mysql_error()); $total1 = mysql_fetch_array($result); $total = mysql_num_rows($result); $id = rand($total1['ID'], $total); $id1 = $id + 1; $result1 = Model::view('study_material_video', "ID='{$id}' or ID='{$id1}'", '*'); //$query1="select * from study_material_video where ID='$id' or ID='$id1'"; //$result1=mysql_query($query1)or die(mysql_error()); while ($r = mysql_fetch_array($result1)) { /*$contents = scandir("../ProVideo"); if($contents!=FALSE) sort($contents); $ran_no=rand(2,count($contents)-2); */ echo "<a target='_parent' href='vedio/video.php?path=" . $r['file'] . "_" . $r['title'] . "'>" . $r['title'] . "</a><br>"; } ?> </td> </tr> </table> </td>
<form name="form1" method="post" action="genrate_certificate.php" target="_new"> <?php $batch = explode('_', $_GET['batch_id']); ?> <tr><input type="hidden" name="batch_id" value="<?php echo $batch[0]; ?> " /> <input type="hidden" name="type" value="<?php echo $batch[1]; ?> " /> <td>Select Student</td><td><select name="student_id"> <option value="all" selected="selected">All Student</option> <?php $r = Model::view('register', "batch='" . $batch[0] . "' and type='st'", "ID,email,name"); $i = 0; while ($row = mysql_fetch_array($r)) { if ($row['email'] != "email") { $i++; } echo "<option value='" . $row['ID'] . "'>" . $row['name'] . " (" . $row['email'] . ")</option>"; } ?> </select></td> </tr> <tr> <td>Issued Date</td><td><input type="text" name="date" id="dt" readonly="true" value="<?php echo date('d/m/Y'); ?> " />
</div> <!-- InstanceEndEditable --> <!-- ####################################################################################################### --> <!-- ####################################################################################################### --> <!-- ####################################################################################################### --> <!-- InstanceBeginEditable name="Contents" --> <!-- Yogesh --> <div class="wrapper row4"> <div id="container" class="clear"> <h2>Pay Earn Points</h2> <h2 class="title"></h2> <p> <table style="color:#000000"> <?php $id = $_GET['id']; $s = Model::view("bdm_payment", "ID='{$id}'", "claim_point,cashed_point"); $row = mysql_fetch_array($s); $bl = $row['claim_point'] - $row['cashed_point']; ?> <form name="form1" method="post" action="#" onsubmit="return co();"> <input type="hidden" name="id" value="<?php echo $id; ?> " /> <input type="hidden" name="cash" value="<?php echo $row['cashed_point']; ?> " /> <tr><td>Balance Point</td><td><input type="hidden" name="bl_point" value="<?php echo $bl; ?>
echo 'Data Successfuly Saved !!!!'; } ?> </label> <table> <form name="form" method="post" action="change_payment_status.php"> <tr> <input type="hidden" name="batch_id" value="<?php if (isset($_GET['batch_id'])) { $batch = $_GET['batch_id']; } echo $batch; ?> "/> <?php $result = Model::view('session_entry', "batch_id='{$batch}'", "ID,session_no,amount_status"); $i = 0; $s_id = ''; while ($row = mysql_fetch_array($result)) { $i++; $id = $row['ID']; if ($i > 1) { $s_id .= ',' . $id; } else { $s_id = $id; } ?> <td><input type="checkbox" name="session_id[]" value="<?php echo $row['ID']; ?> " <?php
if ($row['action'] == 'Pending') { echo "bgcolor='#F4F865'"; } if ($row['action'] == 'Rejected') { echo "bgcolor='#FF5E69'"; } ?> ><td><?php echo $row['date']; ?> </td><td><?php echo $row['action']; ?> </td> <td><?php $s1 = Model::view("bdm_task", "ID='{$task}'", "amount"); $row1 = mysql_fetch_array($s1); echo $row1['amount'] * 2; if ($row['action'] == 'Approved') { $total = $total + $row1['amount']; } ?> </td></tr> <?php } ?> <tr bgcolor="#9900FF" style="color:#FFFFFF;"><td colspan="3" align="right">Total = <?php echo $total * 2; ?> </td></tr> </table>
?> name="check1[]" value="<?php echo $row1['module_name']; ?> "> <?php echo $row1['module_name']; if ($c % 3 == 0) { echo "</br>"; } } ?> </td></tr> <tr><td>Select SAP Modules For Advanced Level</td><td> <?php $res = Model::view('sap_module', "level='Advanced'", '*'); /*$sql="select * from sap_module where level='Advanced'"; $res=mysql_query($sql);*/ $c = 0; while ($row1 = mysql_fetch_array($res)) { $c++; $module = $row1['module_name']; $tr_module = explode(',', $row['course_type']); ?> <input type="checkbox" <?php foreach ($tr_module as $values) { if ($values == $module) { $check = "checked"; echo $check; } }
if ($_POST['status'] == "") { $email = ""; } else { if ($_POST['status'] == "email") { $email = " and email!=''"; } else { $email = " and email IS NULL"; } } $result = Model::view("register", "type='st'{$email} and register_id in (select student_id from student_batch where batch_id='" . $_POST['batch_id'] . "') order by name asc", "*"); } $i = 0; while ($row = mysql_fetch_array($result)) { $i++; $res = Model::view("register", "ID=(select ID from batch_entry where erp_course_code=(select batch_id from student_batch where student_id='" . $row['register_id'] . "'))", "name"); $res1 = Model::view("student_batch", "student_id='" . $row['register_id'] . "'", "batch_id"); $ro = mysql_fetch_array($res); $ro1 = mysql_fetch_array($res1); ?> <tr> <td><?php echo $i; ?> </td> <td><?php echo $row['name']; ?> </td> <td><?php echo $ro['name']; ?>
$r = Model::view('trarningcentre order by city', "", 'distinct city'); while ($row = mysql_fetch_array($r)) { echo "<option>"; echo $row['city']; echo "</option>"; } ?> </select> </td> </tr> <tr> <td>Training Center</td> <td> <select name="centre"> <?php $r = Model::view('trarningcentre', "deleted <>'1' order by name", 'distinct name'); while ($row = mysql_fetch_array($r)) { echo "<option>"; echo $row['name']; echo "</option>"; } ?> </select> </td> </tr> <tr> <td>Topic</td><td><input type="text" size="100" name="topic"/></td> </tr> <tr>
if ($cl != '') { ?> <tr><td> <form method="post" name="theform" action="assign_php.php"> <input type="hidden" readonly="true" name="id" value="<?php echo $row1['name']; ?> "> <input type="hidden" readonly="true" name="user_type" value="tc/tp"> <?php echo $row1['name']; } ?> </td><td> <input type="hidden" readonly="true" name="erp_course" value="<?php $result2 = Model::view('erp_course', "ID='" . $row['erp_course_id'] . "'", 'name_of_erpcourse'); /*$query2="select name_of_erpcourse from erp_course where ID='".$row['erp_course_id']."'"; $result2=mysql_query($query2);*/ $row2 = mysql_fetch_array($result2); echo $row2['name_of_erpcourse']; ?> "><?php echo $row2['name_of_erpcourse']; ?> </td><td><input type="hidden" readonly="true" name="batch_id" value="<?php echo $row['erp_course_code']; ?> "><?php echo $row['erp_course_code']; ?> <input type="hidden" readonly="true" name="batch_id" value="<?php
<tr bgcolor="#669933" style="color:#FFFFFF"><td></td><td>City</td><td>College Name</td><td>Contact Person</td><td>Contact Number</td><td>Email ID</td><td>Task</td><td>Date of Task</td><td>Next Task</td><td>Next Task Date</td><td>Comment</td><td width="70px">Action</td></tr> <?php $tablename = 'bdm_report'; $condition = "status='0' and ref_id='" . $_GET['history'] . "' and bdm_id='{$email}' order by date"; $r = Model::view($tablename, $condition, '*'); //$sql="select * from bdm_report where status='0' and ref_id='".$_GET['history']."' and bdm_id='$email' order by date"; //$result=mysql_query($sql); while ($row = mysql_fetch_array($r)) { $tablename = 'bdm_task'; $condition = "ID='" . $row['task'] . "'"; $r1 = Model::view($tablename, $condition, 'task_name'); //$sql1="select task_name from bdm_task where ID='".$row['task']."'"; //$result1=mysql_query($sql1); $row1 = mysql_fetch_array($r1); $condition = "ID='" . $row['next_task'] . "'"; $r2 = Model::view($tablename, $condition, 'task_name'); //$sql2="select task_name from bdm_task where ID='".$row['next_task']."'"; //$result2=mysql_query($sql2); $row2 = mysql_fetch_array($r2); ?> <tr> <td> <?php if ($row['action'] == 'Pending') { echo "<div style='background:#E4D305; height:10px; width:10px;'></div>"; } if ($row['action'] == 'Approved') { echo "<div style='background:#00FF00; height:10px; width:10px;'></div>"; } if ($row['action'] == 'Rejected') { echo "<div style='background:#FF0000; height:10px; width:10px;'></div>";
</tr> <tr> <td align="left">Your Answer--<?php echo str_replace(",", ", ", $ro['user_answer']); ?> </td> <td align="right">Marks Obtained--<?php echo $ro['marks_to_ten']; ?> /15</td> </tr> </table> <table> <tr><td align="center" colspan="2">Correct Answer</td></tr> <?php $res = Model::view('test_paper', "session_id='" . $_POST['contant_id'] . "' order by ID asc limit 15", "*"); $i = 0; while ($row = mysql_fetch_array($res)) { $i++; ?> <tr bgcolor="#336699" style="color:#FFFFFF"> <td width="80px"><input type="hidden" value="<?php echo $row['question_no']; ?> " name="question_no[]" /><?php echo "Question-" . $row['question_no']; ?> </td> <td><input type="hidden" value="<?php echo $row['question'];
<!-- InstanceEndEditable --> <!-- ####################################################################################################### --> <!-- ####################################################################################################### --> <!-- ####################################################################################################### --> <!-- InstanceBeginEditable name="Contents" --> <!-- Yogesh --> <div class="wrapper row4"> <div id="container" class="clear"> <h2>Edit Profile</h2> <h2 class="title"></h2> <p> <form method="post" name="theform" action="edit_profile_php.php" enctype="multipart/form-data" onSubmit="return bdm_check(theform);"> <table> <?php $s = Model::view("register", "email='{$email}' and type='bdm'", "*"); $row = mysql_fetch_array($s); ?> <tr><td width="200px"></td><td>Upload Profile Picture</td><td><input type="file" name="upload_photo"><img src="upload_photo/<?php echo $row['image']; ?> " width="30" height="40" ></td><td width="200px"></td></tr><input type="hidden" name="id" value="<?php echo $row['ID']; ?> "> <tr><td width="200px"></td><td>Upload Resume</td><td><input type="file" name="upload_resume"><a href="upload_resume/<?php echo $row['resume']; ?> "</td><td width="200px"></td></tr> <tr><td width="200px"></td><td>Associate Type</td><td><select name="associate_type"> <option value="">Select Associate Type</option>
if (isset($set)) { ?> <label style="color:#FF0000">Data Successfuly Saved !!!</label> <?php } ?> <table> <tr bgcolor="#CC3399" style="color:#FFFFFF"> <td>Trainer Name</td> <td>Email</td> <td>Amount Per Session</td> <td>Amount Per Day</td> <td>Action</td> </tr> <?php $result = Model::view('register', "type='tr'", 'name,email,url,batch'); while ($row = mysql_fetch_array($result)) { ?> <form name="form1" method="post" action="manage_trainer_earning.php"> <tr> <td><?php echo $row['name']; ?> </td> <td><input type="hidden" name="id" value="<?php echo $row['email']; ?> " /><?php echo $row['email']; ?> </td>
<td><input type="file" name="e_book" /></td> </tr> <tr> <td></td> <td><input type="submit" name="upload" value="Upload File" /></td> </tr> </form> </table> <center><h3>Uploded E-Book</h3></center> <table> <tr bgcolor="#618A48" style="color:#FFFFFF"><td>File</td><td>Action</td></tr> <?php $table = 'e_book'; $condition = ""; $field = "*"; $r = Model::view($table, $condition, $field); while ($s = mysql_fetch_array($r)) { ?> <tr> <td><a href="e_book/<?php echo $s['file']; ?> "><?php echo $s['title']; ?> </a></td> <td> <form name="file_upload1" method="post" action="upload_e_book_php.php"> <input type="hidden" name="file_name" value="<?php echo $s['file']; ?>
$set_value = "user_name='" . $_POST['uname'] . "',password='******'password'] . "', ip_address='{$ip}', status='True', date='" . date('d/m/Y H:i:s') . "', type='admin', text='{$subject}'"; $q = Model::save($table, $set_value); $massege = "Login from Ip address - " . $ip . " and user_name - " . $_POST['uname'] . " and password - " . $_POST['password']; $table1 = 'users'; $re = Model::view($table1, '', 'type,password'); $email = $row['type']; $objMail = new Mail($subject, $massege, $email); $mail = $objMail->sendMail(); if ($mail) { header('Location: ../Admin/adminpanel.php'); } } if ($chk == 0) { $ip = $_SERVER['REMOTE_ADDR']; $table = 'login_detail'; $subject = "Invalid Attempt From IP Address - " . $ip; $set_value = "user_name='" . $_POST['uname'] . "',password='******'password'] . "', ip_address='{$ip}', status='True', date='" . date('d/m/Y H:i:s') . "', type='admin', text='{$subject}'"; $q = Model::save($table, $set_value); $massege = "Illegal login attempt from Ip address - " . $ip . " and user_name - " . $_POST['uname'] . " and password - " . $_POST['password']; $table1 = 'users'; $re = Model::view($table1, '', 'type,password'); while ($r = mysql_fetch_array($re)) { $email = $r['type']; $objMail = new Mail($subject, $massege, $email); $objMail->sendMail(); } echo "<script>alert('Illegal attampt from - " . $ip . "');window.location.assign('Admin Login.php');</script>"; } ?>
<tr bgcolor="#B9D2BA"> <td width="50%"><a target="_parent" href="total_earn_points.php"><u>Total Earned Points</u></a></td> <td> <?php $total = 0; $s = Model::view("bdm_report", "bdm_id='{$email}' and status='0'", "date,action,task"); while ($row = mysql_fetch_array($s)) { $task = $row['task']; $s1 = Model::view("bdm_task", "ID='{$task}'", "amount"); $row1 = mysql_fetch_array($s1); if ($row['action'] == 'Approved') { $total = $total + $row1['amount']; } } echo $total; $s = Model::view("bdm_payment", "bdm_id='{$email}' and cashed_point!=''", "cashed_point"); $cash = 0; while ($row2 = mysql_fetch_array($s)) { $cash = $cash + $row2['cashed_point']; } $balance = $total - $cash; ?> </td> </tr> <tr bgcolor="#FDAEA6"> <td><a target="_parent" href="bdm_cashed_point.php"><u>Cashed Earned Point</u></a></td> <td> <?php echo $cash; ?> </td>
<?php include '../database.php'; include '../model.php'; $batch = "<select name='s_batch' onchange='getValue();'><option value=''>Select Batch</option>"; $result = Model::view('batch_entry', "ID='" . $_GET['vlue'] . "' and record_status='New' order by erp_course_code", "erp_course_code"); while ($row = mysql_fetch_array($result)) { $bh = $row['erp_course_code']; $batch .= "<option>{$bh}</option>"; } $batch .= "<select>"; echo $batch;
} } else { if ($user_type == "Student") { $condition = "email='" . $_POST['email'] . "' and password='******' and type='st'"; $r = Model::view($tablename, $condition, $field_list); $row = mysql_num_rows($r); if ($row > 0) { $_SESSION['type'] = 'st'; header('Location:student/student panel.php'); } else { echo "<script>alert('Login Invalid !!!!');window.location.assign('App_index.php');</script>"; } } else { if ($user_type == "BDM") { $condition = "email='" . $_POST['email'] . "' and password='******' and type='bdm'"; $r = Model::view($tablename, $condition, $field_list); $row = mysql_num_rows($r); if ($row == 1) { $_SESSION['type'] = 'bdn'; header('Location:BDM/bdm_panel.php'); } else { echo "<script>alert('Login Invalid !!!!');window.location.assign('App_index.php');</script>"; } } else { echo "<script>alert('Login Invalid !!!!');window.location.assign('App_index.php');</script>"; } } } } } }
<!-- InstanceBeginEditable name="Contents" --> <!-- Yogesh --> <div class="wrapper row4"> <div id="container" class="clear"> <h2>Genrate Bill</h2> <h2 class="title"></h2> <p> <table> <form name="bill_genrate" method="post" action="genrate_bill.php"> <tr> <td>Select College Name</td> <td><select name="college_name"> <?php require '../database.php'; require '../model.php'; $result = Model::view('register', "type='cl' or type='tctp'", 'name,ID'); while ($row = mysql_fetch_array($result)) { echo "<option value='" . $row['ID'] . "'>" . $row['name'] . "</option>"; } ?> </select> </td> </tr> <tr> <td>Select Date</td> <td><select name="day_to"> <?php for ($i = 1; $i <= 31; $i++) { if (strlen($i) == 1) { echo "<option>0{$i}</option>"; } else {