}
    } else {
        if ($cboPayChargeType == "LocalChargeOnly") {
            if ($getcboincludeservice == "") {
                $update = $db->query("UPDATE tbltransaction SET \n\t\t\t\t\tAnother_BranchID = '" . $cboToBranch . "', \n\t\t\t\t\tPhoneSender= '" . $txtPhoneSender . "',\n\t\t\t\t\tPhoneReceiver= '" . $txtPhoneReciever . "',\n\t\t\t\t\t`Code`= '" . $txtcode . "',\n\t\t\t\t\tCurrencyNo= '" . $cboCurrency . "',\n\t\t\t\t\tAmt= '" . $txtamt . "',\n\t\t\t\t\tLocal_Branch_Charge= '" . $txtLocalCharge . "', \n\t\t\t\t\tAnother_Branch_Charge= '" . $txtAnnotherCharge . "', \n\t\t\t\t\tTotalCharge= '" . $txtTotalCharge . "',\n\t\t\t\t\tPayChargeType= '" . $cboPayChargeType . "',\n\t\t\t\t\tTotal_To_Paid= '" . $ifLocalChargenotinclude . "'\n\t\t\t\t\tWHERE TransactionID = '" . $txtTransactionID . "'");
            } else {
                $update = $db->query("UPDATE tbltransaction SET \n\t\t\t\t\tAnother_BranchID = '" . $cboToBranch . "', \n\t\t\t\t\tPhoneSender= '" . $txtPhoneSender . "',\n\t\t\t\t\tPhoneReceiver= '" . $txtPhoneReciever . "',\n\t\t\t\t\t`Code`= '" . $txtcode . "',\n\t\t\t\t\tCurrencyNo= '" . $cboCurrency . "',\n\t\t\t\t\tAmt= '" . $txtamt . "',\n\t\t\t\t\tLocal_Branch_Charge= '" . $txtLocalCharge . "', \n\t\t\t\t\tAnother_Branch_Charge= '" . $txtAnnotherCharge . "', \n\t\t\t\t\tTotalCharge= '" . $txtTotalCharge . "',\n\t\t\t\t\tPayChargeType= '" . $cboPayChargeType . "',\n\t\t\t\t\tTotal_To_Paid= '" . $ifLocalCharge . "'\n\t\t\t\t\tWHERE TransactionID = '" . $txtTransactionID . "'");
            }
        } else {
            if ($cboPayChargeType == "NotAll") {
                $update = $db->query("UPDATE tbltransaction SET \n\t\t\t\t\tAnother_BranchID = '" . $cboToBranch . "', \n\t\t\t\t\tPhoneSender= '" . $txtPhoneSender . "',\n\t\t\t\t\tPhoneReceiver= '" . $txtPhoneReciever . "',\n\t\t\t\t\t`Code`= '" . $txtcode . "',\n\t\t\t\t\tCurrencyNo= '" . $cboCurrency . "',\n\t\t\t\t\tAmt= '" . $txtamt . "',\n\t\t\t\t\tLocal_Branch_Charge= '" . $txtLocalCharge . "', \n\t\t\t\t\tAnother_Branch_Charge= '" . $txtAnnotherCharge . "', \n\t\t\t\t\tTotalCharge= '" . $txtTotalCharge . "',\n\t\t\t\t\tPayChargeType= '" . $cboPayChargeType . "',\n\t\t\t\t\tTotal_To_Paid= " . $ifLocalChargeinclude . "\n\t\t\t\t\tWHERE TransactionID = '" . $txtTransactionID . "'");
            }
        }
    }
    if ($update) {
        cRedirect('frmTransfer.php');
    } else {
        echo "<script type='text/javascript'>alert('មានបញ្ហាបន្តិចបន្តួច! សូមបញ្ចូលម្តងទៀត!')</script>";
    }
}
?>

    <body class="skin-blue">
        <!-- header logo: style can be found in header.less -->
         <?php 
include 'nav.php';
?>
        
            <!-- Left side column. contains the logo and sidebar -->
            <?php 
include 'menu.php';
$btnSave = get('btnSave');
// update
$gettxtServiceTypeID = get('txtServiceTypeID');
$gettxtservicename = get('txtservicename');
$gettxtDesc = get('txtDesc');
$getbtnSave = get('btnSave');
if ($btnSave == 'Save') {
    $InsertServiceType = $db->query("INSERT INTO tblservicetype( ServiceTypeID, ServiceTypeName, Description ) \n\t\tVALUES (" . $autoid . ",N'" . $txtservicename . "',N'" . $txtDesc . "');");
    if ($InsertServiceType) {
        cRedirect('frmServicesType.php');
    }
}
if ($getbtnSave == 'SaveUpdate') {
    $UpdateServiceType = $db->query("UPDATE tblservicetype SET  ServiceTypeName='" . $gettxtservicename . "', Description='" . $gettxtDesc . "' \n\t\t\tWHERE ServiceTypeID='" . $gettxtServiceTypeID . "';");
    if ($UpdateServiceType) {
        cRedirect('frmServicesType.php');
    }
}
?>

    <body class="skin-blue">
        <!-- header logo: style can be found in header.less -->
         <?php 
include 'nav.php';
?>
        
            <!-- Left side column. contains the logo and sidebar -->
            <?php 
include 'menu.php';
?>
<?php 
include 'header.php';
//==================== Insert New User =======================
if (isset($_POST['btnSave'])) {
    $cboBranch = $_POST['cboBranch'];
    $txtUserName = post('txtUserName');
    $txtPassword = post('txtPassword');
    $txtLevel = post('txtLevel');
    $txtDescription = post('txtDescription');
    $txtStatus = post('txtStatus');
    $encrypted_pass = encrypt_decrypt('encrypt', $txtPassword);
    $insert = $db->query("CALL sp_Insert_UserAccount(\n\t\t\t\t'" . time() . "',\n\t\t\t\t'" . $cboBranch . "',\n\t\t\t\tN'" . sql_quote($txtUserName) . "',\n\t\t\t\tN'" . sql_quote($encrypted_pass) . "',\n\t\t\t\t'" . sql_quote($txtLevel) . "',\n\t\t\t\tN'" . sql_quote($txtDescription) . "',\n\t\t\t\t'" . sql_quote($txtStatus) . "'\t\t\t\n\t\t\t\t)");
    if ($insert) {
        cRedirect('userAccount.php');
    }
}
?>

    <body class="skin-blue">
        <!-- header logo: style can be found in header.less -->
         <?php 
include 'nav.php';
?>
        
            <!-- Left side column. contains the logo and sidebar -->
            <?php 
include 'menu.php';
?>

            <!-- Right side column. Contains the navbar and content of the page -->
            <aside class="right-side">
        if ($getcboincludeservice == "") {
            $updated = $db->query("UPDATE tbltransaction set \n\t\t\t\t\tAnother_BranchID = '" . $cboFromBranch . "', \n\t\t\t\t\tPhoneSender = '" . $txtPhoneSender . "', \n\t\t\t\t\tPhoneReceiver = '" . $txtPhoneReciever . "', \n\t\t\t\t\t`Code` = '" . $txtcode . "', \n\t\t\t\t\tCurrencyNo = '" . $cboCurrency . "', \n\t\t\t\t\tAmt = " . $txtamt . ", \n\t\t\t\t\tLocal_Branch_Charge = " . $txtLocalCharge . ", \n\t\t\t\t\tAnother_Branch_Charge = " . $txtAnnotherCharge . ", \n\t\t\t\t\tTotalCharge = " . $txtTotalCharge . ", \n\t\t\t\t\tPayChargeType = '" . $cboPayChargeType . "', \n\t\t\t\t\tTotal_To_Paid = " . $ifallnotInclude . ",\n\t\t\t\t\tDate = '" . $date_now . "'\n\t\t\t\t\tWHERE TransactionID = '" . $txtgettransactionID . "'");
        } else {
            $updated = $db->query("UPDATE tbltransaction set \n\t\t\t\t\tAnother_BranchID = '" . $cboFromBranch . "', \n\t\t\t\t\tPhoneSender = '" . $txtPhoneSender . "', \n\t\t\t\t\tPhoneReceiver = '" . $txtPhoneReciever . "', \n\t\t\t\t\t`Code` = '" . $txtcode . "', \n\t\t\t\t\tCurrencyNo = '" . $cboCurrency . "', \n\t\t\t\t\tAmt = " . $txtamt . ", \n\t\t\t\t\tLocal_Branch_Charge = " . $txtLocalCharge . ", \n\t\t\t\t\tAnother_Branch_Charge = " . $txtAnnotherCharge . ", \n\t\t\t\t\tTotalCharge = " . $txtTotalCharge . ", \n\t\t\t\t\tPayChargeType = '" . $cboPayChargeType . "', \n\t\t\t\t\tTotal_To_Paid = " . $ifallInclude . ",\n\t\t\t\t\tDate = '" . $date_now . "'\n\t\t\t\t\tWHERE TransactionID = '" . $txtgettransactionID . "'");
        }
    } else {
        if ($cboPayChargeType == "LocalChargeOnly") {
            $updated = $db->query("UPDATE tbltransaction set \n\t\t\t\tAnother_BranchID = '" . $cboFromBranch . "', \n\t\t\t\tPhoneSender = '" . $txtPhoneSender . "', \n\t\t\t\tPhoneReceiver = '" . $txtPhoneReciever . "', \n\t\t\t\t`Code` = '" . $txtcode . "', \n\t\t\t\tCurrencyNo = '" . $cboCurrency . "', \n\t\t\t\tAmt = " . $txtamt . ", \n\t\t\t\tLocal_Branch_Charge = " . $txtLocalCharge . ", \n\t\t\t\tAnother_Branch_Charge = " . $txtAnnotherCharge . ", \n\t\t\t\tTotalCharge = " . $txtTotalCharge . ", \n\t\t\t\tPayChargeType = '" . $cboPayChargeType . "', \n\t\t\t\tTotal_To_Paid = " . $ifLocalCharge . ",\n\t\t\t\tDate = '" . $date_now . "'\n\t\t\t\tWHERE TransactionID = '" . $txtgettransactionID . "'");
        } else {
            if ($cboPayChargeType == "NotAll") {
                $updated = $db->query("UPDATE tbltransaction set \n\t\t\t\tAnother_BranchID = '" . $cboFromBranch . "', \n\t\t\t\tPhoneSender = '" . $txtPhoneSender . "', \n\t\t\t\tPhoneReceiver = '" . $txtPhoneReciever . "', \n\t\t\t\t`Code` = '" . $txtcode . "', \n\t\t\t\tCurrencyNo = '" . $cboCurrency . "', \n\t\t\t\tAmt = " . $txtamt . ", \n\t\t\t\tLocal_Branch_Charge = " . $txtLocalCharge . ", \n\t\t\t\tAnother_Branch_Charge = " . $txtAnnotherCharge . ", \n\t\t\t\tTotalCharge = " . $txtTotalCharge . ", \n\t\t\t\tPayChargeType = '" . $cboPayChargeType . "', \n\t\t\t\tTotal_To_Paid = " . $ifNotall . ",\n\t\t\t\tDate = '" . $date_now . "'\n\t\t\t\tWHERE TransactionID = '" . $txtgettransactionID . "'");
            }
        }
    }
    if ($updated) {
        cRedirect('frmReciever.php');
        //echo "<script type='text/javascript'>alert('Thank!')</script>";
    } else {
        echo "<script type='text/javascript'>alert('មានបញ្ហាបន្តិចបន្តួច! សូមបញ្ចូលម្តងទៀត!')</script>";
    }
}
?>

    <body class="skin-blue">
        <!-- header logo: style can be found in header.less -->
         <?php 
include 'nav.php';
?>
        
            <!-- Left side column. contains the logo and sidebar -->
            <?php 
<?php 
include 'header.php';
?>

<?php 
// Add new product to Produtct Tem
if (isset($_POST['btnSave'])) {
    $txtName = post('txtName');
    $txtDesc = post('txtDesc');
    $Updatestock = $db->query("UPDATE tblbranch SET\n\t\t\t\t\t\t\t\tBranchName = N'" . $txtName . "',\n\t\t\t\t\t\t\t\tDecription = N'" . $txtDesc . "'\n\t\t\t\t\t\t\t\tWHERE BranchID = '" . $getBranchID . "';");
    if ($Updatestock) {
        cRedirect('frmbranch.php');
    }
    $error = "Error Internet Connection!";
}
?>

    <body class="skin-blue">
        <!-- header logo: style can be found in header.less -->
         <?php 
include 'nav.php';
?>
        
            <!-- Left side column. contains the logo and sidebar -->
            <?php 
include 'menu.php';
?>

            <!-- Right side column. Contains the navbar and content of the page -->
            <aside class="right-side">
        $x = 1;
        while ($row = $db->fetch($InsertToTableBuyDetail)) {
            $ProductID = $row->ProductID;
            $QTY = $row->QTY;
            $BuyPrice = $row->BuyPrice;
            /*Insert to tblproducts_buydetail*/
            $newinsert = $db->query("INSERT INTO tblproducts_buydetail\n\t\t\t\t\t\t\t\t\t\t\t( BuyDetailID,\n\t\t\t\t\t\t\t\t\t\t\tBuyID, \n\t\t\t\t\t\t\t\t\t\t\tUserID,\n\t\t\t\t\t\t\t\t\t\t\tProductID,\n\t\t\t\t\t\t\t\t\t\t\tQty,\n\t\t\t\t\t\t\t\t\t\t\tBuyPrice,\n\t\t\t\t\t\t\t\t\t\t\tDecription )\n\t\t\t\t\t\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\t'" . time() . $x++ . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $buyid . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $U_id . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $ProductID . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $QTY . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $BuyPrice . "',\n\t\t\t\t\t\t\t\t\t\t\t''\n\t\t\t\t\t\t\t\t\t\t\t)");
            /*Update Qty of Products*/
            $updateproductsqty = $db->query("UPDATE tblproducts \n\t\t\t\t\t\t\t\t\t\t\tSET Qty = Qty + (SELECT Qty FROM tblprdtem WHERE ProductID = '" . $ProductID . "' )\n\t\t\t\t\t\t\t\t\t\t\tWHERE ProductID = '" . $ProductID . "'\n\t\t\t\t\t\t\t\t\t\t\t");
            /*Update Qty of ProductsBranch*/
            $updateproductsqty = $db->query("UPDATE `tblproductsbranch`SET\n\t\t\t\t\t\t\t\t\t\t\tBuyPrice = (SELECT BuyPrice FROM tblprdtem WHERE ProductID = '" . $ProductID . "' ) ,\n\t\t\t\t\t\t\t\t\t\t\tOtherCost = '0',\n\t\t\t\t\t\t\t\t\t\t\tSalePrice = (SELECT SalePrice FROM tblprdtem WHERE ProductID = '" . $ProductID . "' ) ,\n\t\t\t\t\t\t\t\t\t\t\tQty = Qty + (SELECT Qty FROM tblprdtem WHERE ProductID = '" . $ProductID . "' ) ,\n\t\t\t\t\t\t\t\t\t\t\tQtyInstock = (SELECT Qty FROM tblproducts WHERE ProductID = '" . $ProductID . "' ) ,\n\t\t\t\t\t\t\t\t\t\t\tTotalBuyPrice = TotalBuyPrice + (SELECT Qty * BuyPrice FROM tblprdtem WHERE ProductID = '" . $ProductID . "' )\n\t\t\t\t\t\t\t\t\t\t\tWHERE ProductID = '" . $ProductID . "'\n\t\t\t\t\t\t\t\t\t\t\t");
        }
    }
    if ($copy) {
        $delete = $db->query("DELETE FROM `tblprdtem` WHERE IP = '" . $ip . "'");
        cRedirect('index.php');
    }
}
?>

    <body class="skin-blue">
        <!-- header logo: style can be found in header.less -->
         <?php 
include 'nav.php';
?>
        
            <!-- Left side column. contains the logo and sidebar -->
            <?php 
include 'menu.php';
?>
<?php

include 'header.php';
$error = "";
$id = get('id');
$BranchName = get('BranchName');
$Decription = get('Decription');
$UserID = $_SESSION['UserID'];
//Update Branch
if (isset($_POST['btnSaveUpdate'])) {
    $txtbranchName = post('txtbranchName');
    $txtDescrpiton = post('txtDescrpiton');
    $update = $db->query("CALL sp_Branch_Update(\n\t\t\t\t\t'" . $id . "',\n\t\t\t\t\tN'" . sql_quote($txtbranchName) . "',\n\t\t\t\t\tN'" . sql_quote($txtDescrpiton) . "'\n\t\t\t\t\t)\t\t\t\n\t\t");
    if ($update) {
        cRedirect('Branch.php');
        //$error = 'Success';
    }
}
?>
      
            <div class="row">
                <div class="col-lg-12">
                    <h1 class="page-header">Update Branch</h1>
                    
                </div>
                <!-- /.col-lg-12 -->
            </div>
            <!-- /.row -->
            <div class="row">
               
                        <div class="panel-heading">
Esempio n. 8
0
<?php

session_start();
include 'connectionclass/connect.php';
include 'connectionclass/function.php';
$db = new MyConnection();
$db->connect();
mysql_query("SET NAMES 'UTF8'");
$LoginDate = $_SESSION['startDate'];
$UserID = $_SESSION['UserID'];
$date = new DateTime('now', new DateTimeZone('ICT'));
$_SESSION['LogoutNow'] = $date->format('d-m-Y H:i:s');
$LogoutDate = $_SESSION['LogoutNow'];
/*echo $UserID . '<br>';
echo $LoginDate.'<br>';
echo $LogoutDate;*/
$Insert = $db->query("INSERT INTO tbluserhistory (UserID,UserHistoryStartDate,UserHistoryEndDate) VALUES ('" . $UserID . "','" . $LoginDate . "',Now())");
session_destroy();
cRedirect('login.php');
                $db->connect();
                $update1 = $db->query("UPDATE tbltransaction SET isClearPayment = '1', \n\t\t\t\t\tClearPaymentDate='" . $date_now . "', ClearPayment_Description='' \n\t\t\t\t\tWHERE TransactionID = '" . $TransactionID . "'");
            }
            /*if($TransactionID == get($TransactionID))
            		{
            			echo "<script type='text/javascript'>alert('It Work')</script>";	
            		}*/
        }
        cRedirect('frmReport.php?cboTransaction=' . $cboTransaction . '&txtFrom=' . $txtFrom . '&txtTo=' . $txtTo . '&searchBranch=' . $searchBranch . '');
    }
} else {
    if ($getClear == 'All') {
        $select = $db->query("call spReport('" . $cboTransaction . "','" . $searchBranch . "');");
        $rowselect = $db->dbCountRows($select);
        if ($rowselect > 0) {
            //echo 'Clear Payment .....';
            while ($row = $db->fetch($select)) {
                $TransactionID = $row->TransactionID;
                //$getID = get("".$TransactionID."");
                $db->disconnect();
                $db->connect();
                $update1 = $db->query("UPDATE tbltransaction SET isClearPayment = '1', \n\t\t\t\t\tClearPaymentDate='" . $date_now . "', ClearPayment_Description='' \n\t\t\t\t\tWHERE TransactionID = '" . $TransactionID . "'");
                /*if($TransactionID == get($TransactionID))
                		{
                			echo "<script type='text/javascript'>alert('It Work')</script>";	
                		}*/
            }
            cRedirect('frmReport.php?cboTransaction=' . $cboTransaction . '&txtFrom=' . $txtFrom . '&txtTo=' . $txtTo . '&searchBranch=' . $searchBranch . '');
        }
    }
}
$txtBranchName = get('txtBranchName');
$txtDesc = get('txtDesc');
$btnSave = get('btnSave');
if (isset($_POST['btnSave'])) {
    $txtBranchName = $_POST['txtBranchName'];
    $txtDescription = post('txtDescription');
    $insert = $db->query("INSERT INTO tblcurrency (CurrencyNo, `Name`, Description) VALUES ('" . time() . "',N'" . $txtBranchName . "',N'" . $txtDescription . "'); ");
    if ($insert) {
        cRedirect('frmcurrency.php');
    }
    $error = "Error Internet Connection!";
}
if ($btnSave == 'SaveUpdate') {
    $updatebranch = $db->query("UPDATE tblcurrency SET Name=N'" . $txtBranchName . "', Description='" . $txtDesc . "' WHERE CurrencyNo = '" . $txtBranchID . "'; ");
    if ($updatebranch) {
        cRedirect('frmcurrency.php');
    } else {
        echo "<script type='text/javascript'>alert('មានបញ្ហាបន្តិចបន្តួច! សូមបញ្ចូលម្តងទៀត!')</script>";
    }
}
/*if($btnSave == 'Save')
		{
			$InsertServiceType=$db->query("INSERT INTO tblservicetype( ServiceTypeID, ServiceTypeName, Description ) 
		VALUES (".$autoid.",N'".$txtservicename."',N'".$txtDesc."');");
			if($InsertServiceType){
			cRedirect('frmServicesType.php');
		 	}
		}		
		if($getbtnSave == 'SaveUpdate')
		{
			$UpdateServiceType=$db->query("UPDATE tblservicetype SET  ServiceTypeName='".$gettxtservicename."', Description='".$gettxtDesc."' 
    $Password = $row->Password;
}
//==================== Insert New Branch =======================
if (isset($_POST['btnSave'])) {
    $txtUser = post('txtUser');
    $txtold = post('txtold');
    $txtNewPass = post('txtNewPass');
    $encrypt_Newpassword = encrypt_decrypt('encrypt', $txtNewPass);
    if ($txtNewPass == "") {
        echo "<script type='text/javascript'>alert('Please Insert New Password!');</script>";
    } else {
        $update = $db->query("UPDATE tblusers SET\n\t\t\t\t\t\t\t\t\tUserName='******',\n\t\t\t\t\t\t\t\t\tPassword = '******'\n\t\t\t\t\t\t\t\t\tWHERE UserID = '" . $U_id . "'\n\t\t\t\t\t\t\t\t");
        if ($update) {
            //$GLOBALS['msg'] = "Success full";
            echo "<script type='text/javascript'>alert('Success full');</script>";
            cRedirect('logout.php');
        } else {
            $GLOBALS['msg'] = "Error for update";
        }
    }
}
?>

    <body class="skin-blue">
        <!-- header logo: style can be found in header.less -->
         <?php 
include 'nav.php';
?>
        
            <!-- Left side column. contains the logo and sidebar -->
            <?php