<?php require_once '/wamp/www/DemoRest/common/define.php'; require_once '/wamp/www/DemoRest/common/SmartySetup.class.php'; require_once '/wamp/www/DemoRest_data/common/DbMgr.php'; //require_once('/wamp/www/DemoRest/calendar/classes/tc_calendar.php'); //require_once('calendar/classes/tc_calendar.php'); session_start(); //$errorMessage = ''; //Select Data and set in Table $sql1 = "SELECT supplier_id, supplier_name, supply_material, delivery_date, payment_pending, paid_amount FROM supplier_master"; try { $dbh1 = DbMgr::getDB(); $stmt1 = $dbh1->prepare($sql1); $ret1 = $stmt1->execute(); if (!$ret1) { print "Error in Selection"; exit; } } catch (Exception $e) { print 'Error:' . $e->getMessage(); die; } $result = array(); $number = 0; while ($row = $stmt1->fetch(PDO::FETCH_ASSOC)) { $number = $number + 1; $result[] = array('number' => $number, 's_ID' => $row['supplier_id'], 's_name' => $row['supplier_name'], 's_material' => $row['supply_material'], 'd_date' => $row['delivery_date'], 'payment_pen' => $row['payment_pending'], 'pd_amount' => $row['paid_amount']); } $smartyObj = new SmartySetup(); $smartyObj->assign('userdata_json', json_encode($result, JSON_UNESCAPED_UNICODE));
$vendtype = $_POST["ventype"]; $vendor_id_selected = $_POST["vendor_id_select"]; $pending_payment1 = $_POST["paymentpen1"]; $paid_amount1 = $_POST["paydone1"]; $pay_recieved1 = $_POST["payreceived1"]; unset($_SESSION['ventype']); unset($_SESSION['vendor_id_select']); unset($_SESSION['paymentpen1']); unset($_SESSION['paydone1']); unset($_SESSION['payreceived1']); session_destroy(); echo $vendtype; echo $vendor_id_selected; $sql = "INSERT INTO daily_transaction(transaction_date, vendor_type, vendor_id,pay_pending,pay_done,pay_received) VALUES (\n\tNow(),'{$vendtype}','{$vendor_id_selected}','{$pending_payment1}','{$paid_amount1}','{$pay_recieved1}')"; try { $dbh = DbMgr::getDB(); $stmt = $dbh->prepare($sql); $ret = $stmt->execute(); if (!$ret) { print "Error in Registraion"; exit; } } catch (Exception $e) { print 'Error:' . $e->getMessage(); die; } } } header("Location: ./vendor_transaction.php"); //$smartyObj = new SmartySetup(); //$smartyObj->assign('userdata_json', json_encode($result,JSON_UNESCAPED_UNICODE));