File: /home/mostafedeg/public_html/erp/controllers/transferdatabaseControllerYasmeen.php
<?php
//the global file operation
include("../public/impOpreation.php");
//global varable
global $showoutside;
//to check if the page from .htacess
//$showoutside = $_GET['sn'];
// get the config file
include_once("../public/config.php");
//here the db files that include in the file
// GOES HERE ....................
include("../public/include_dao.php");
//Savedaily
require_once('../models/dao/SavedailyDAO.class.php');
require_once('../models/dto/Savedaily.class.php');
require_once('../models/mysql/SavedailyMySqlDAO.class.php');
require_once('../models/mysql/ext/SavedailyMySqlExtDAO.class.php');
//get the do the action
$do = $_GET['do'];
/* ======================
Controller Name :- transferdatabaseCTRL اضافة قاعدة بيانات ونقل الجداول
OPERTATION in Controller
1-display add form
2- add in Save tbl
3-insert into savedaily tbl
4-display sucess or error
5-display show form
6-edit in Save data
======================== */
//here the global templates
$smarty->display("header.html");
//here goes the instances and general variables
//Savedaily
$mySavedailyRecord = new SavedailyMySqlDAO();
//check and use the condetion that suite this action
if (empty($do)) {
//here the permssion check
include_once("../public/authentication.php");
//here the smarty templates
$smarty->display("transferdatabaseviewYasmeen/add.html");
} elseif ($do == "add") {
//here the permssion check
include_once("../public/authentication.php");
//to use the variable out side the funcion
createDatabase();
//table data count
$smarty->display("transferdatabaseviewYasmeen/showtable.html");
} elseif ($do == "inserttabledata") {
//here the permssion check
include_once("../public/authentication.php");
//to use the variable out side the funcion
inserttabledata();
$smarty->display("transferdatabaseviewYasmeen/exexcute.html");
} elseif ($do == "exexcute") {
//here the permssion check
include_once("../public/authentication.php");
//to use the variable out side the funcion
try {
exexcute();
$smarty->display("transferdatabaseviewYasmeen/done.html");
// $url = "transferdatabaseController.php?do=add";
//
// $smarty->assign('urldirect', $url);
// $note ="تمت العملية بنجاح";
//
// $smarty->assign('msgnote', $note);
// $smarty->display("notes2.html");
} catch (Exception $e) {
$smarty->display("transferdatabaseviewYasmeen/done.html");
// $url = "transferdatabaseController.php?do=add";
//
// $smarty->assign('urldirect', $url);
// $note ="حدث خطأ اثناء اجراء العملية";
//
// $smarty->assign('msgnote', $note);
// $smarty->display("notes2.html");
}
}
$smarty->assign('customValidation', 1);
//here the global templates
$smarty->display("footer.html");
/* ===============================
function in this CONTROLLER
================================ */
function getDatabaseName() {
// Read in entire file
$databsesNames = file_get_contents("../views/default/archiveview/dbNames.txt");
//print($databsesNames);
$databases = array_reverse(explode(",", $databsesNames));
$smarty->assign("databases", $databases);
}
function createDatabase() {
global $smarty;
$newdatabaseName = $_POST['newdatabaseName'];
$newUserName = $_POST['newUserName'];
$newPassword = $_POST['newPassword'];
$olddatabaseName = $_POST['olddatabaseName'];
$oldUserName = $_POST['oldUserName'];
$oldPassword = $_POST['oldPassword'];
//Current Database
$currentDatabaselink = mysql_connect('localhost', 'root', '123456') or die(mysql_error()); // connect to database
$currentDatabaseSql = mysql_query('SHOW TABLES FROM ' . $_SESSION['dbname']) or die(mysql_error());
//new Database
$newDatabaseLink = mysql_connect('localhost', $newUserName, $newPassword) or die(mysql_error()); // connect to database
if (!mysql_select_db($newdatabaseName)) {
$createDatabaseSql = "CREATE DATABASE " . $newdatabaseName . " ";
$result1 = mysql_query($createDatabaseSql) or die(mysql_error());
//create table in newdatabase
while ($row = mysql_fetch_row($currentDatabaseSql)) {
mysql_query('DROP TABLE IF EXISTS ' . $newdatabaseName . '.' . $row[0] . '') or die(mysql_error());
mysql_query('CREATE TABLE ' . $newdatabaseName . '.' . $row[0] . ' LIKE ' . $_SESSION['dbname'] . '.' . $row[0] . '') or die(mysql_error());
}
} else {
mysql_select_db($newdatabaseName, $newDatabaseLink);
}
//old Database
$oldDatabaseLink = mysql_connect('localhost', $oldUserName, $oldPassword) or die(mysql_error()); // connect to database
//
$oldDatabaseSql = mysql_query('SHOW TABLES FROM ' . $olddatabaseName) or die(mysql_error());
$k = 1;
while ($row = mysql_fetch_row($oldDatabaseSql)) {
if ($row[0] == "**agz_tbl") {
$smarty->assign("tableArabicName" . $k, "يومية الخزينة");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".savedaily");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**backups_tbl") {
$smarty->assign("tableArabicName" . $k, "حركة البنوك");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".savedaily");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**backup_info_tbl") {
$smarty->assign("tableArabicName" . $k, "الاصول");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".savedaily");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "back_buy_bill_tbl") {
$smarty->assign("tableArabicName" . $k, "مردودات المشتريات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "back_sell_bill_tbl") {
$smarty->assign("tableArabicName" . $k, "مردودات المبيعات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnsellbill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "bank_account_tbl") {
$smarty->assign("tableArabicName" . $k, "حسابات البنوك");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".bankaccount");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "bank_deposite_tbl") {
$smarty->assign("tableArabicName" . $k, "ايداع الشيكات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".checkdeposit");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**bank_sa7b_tbl") {
$smarty->assign("tableArabicName" . $k, "خصائص الفواتير");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "buy_bill_tbl") {
$smarty->assign("tableArabicName" . $k, "المشتريات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".buybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "cat_tbl") {
$smarty->assign("tableArabicName" . $k, "تصنيفات المنتجات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".productcat");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
}
// elseif($row[0] == "**changinstores_tbl")
// {
// $smarty->assign("tableArabicName".$k, "التحويل بين المخازن");
//
// $result = mysql_query("SELECT * FROM ". $newdatabaseName.".storemovement");
// $datacount= mysql_num_rows($result);
// $smarty->assign("tableDataCount".$k, $datacount);
//
// $smarty->assign("tableName".$k, $row[0]);
//
// $k++;
// }
// elseif($row[0] == "**client1_report_tbl")
// {
// $smarty->assign("tableArabicName".$k, "مديونية الموردين");
//
// $result = mysql_query("SELECT * FROM ". $newdatabaseName.".supplierdebtchange");
// $datacount= mysql_num_rows($result);
// $smarty->assign("tableDataCount".$k, $datacount);
//
// $smarty->assign("tableName".$k, $row[0]);
//
// $k++;
// }
elseif ($row[0] == "clients_tbl") {
$smarty->assign("tableArabicName" . $k, "العملاء");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".client");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
}
// elseif($row[0] == "client_report_tbl")
// {
// $smarty->assign("tableArabicName".$k, "مديونية العملاء");
//
// $result = mysql_query("SELECT * FROM ". $newdatabaseName.".clientdebtchange");
// $datacount= mysql_num_rows($result);
// $smarty->assign("tableDataCount".$k, $datacount);
//
// $smarty->assign("tableName".$k, $row[0]);
//
// $k++;
// }
elseif ($row[0] == "**discount_product_tmp_tbl") {
$smarty->assign("tableArabicName" . $k, "مديونية العملاء");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**expenses_report_tbl") {
$smarty->assign("tableArabicName" . $k, "المصروفات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "expenses_tbl") {
$smarty->assign("tableArabicName" . $k, "المصروفات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".expenses");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "expenses_type") {
$smarty->assign("tableArabicName" . $k, "انواع المصروفات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".expensestype");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "kem_tbl") {
$smarty->assign("tableArabicName" . $k, "الكمبيالات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".kempiala");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "owners") {
$smarty->assign("tableArabicName" . $k, "الشركاء");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".partner");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**producttemp_tbl") {
$smarty->assign("tableArabicName" . $k, "مسحوبات الشركاء");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**product_setting_tbl") {
$smarty->assign("tableArabicName" . $k, "المنتجات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**product_supplier_tbl") {
$smarty->assign("tableArabicName" . $k, "تصنيفات المنتجات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "product_tbl") {
$smarty->assign("tableArabicName" . $k, "المنتجات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".product");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**prog_setting_tbl") {
$smarty->assign("tableArabicName" . $k, "انواع المصروفات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**save") {
$smarty->assign("tableArabicName" . $k, "الخزن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "saves_tbl") {
$smarty->assign("tableArabicName" . $k, "الخزن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".save");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "save_report_tbl") {
$smarty->assign("tableArabicName" . $k, "يومية الخزن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".savedaily");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "sell_bill_tbl") {
$smarty->assign("tableArabicName" . $k, "المبيعات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".sellbill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "store_details") {
$smarty->assign("tableArabicName" . $k, "حركة المخازن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".storereport");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "store_details_tbl") {
$smarty->assign("tableArabicName" . $k, "تفاصيل البضاعة بالمخازن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".storedetail");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "store_tbl") {
$smarty->assign("tableArabicName" . $k, "المخازن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".store");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "store_transfer_tbl") {
$smarty->assign("tableArabicName" . $k, "التحويل بين المخازن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".storemovement");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "**store_transfer_tmp_tbl") {
$smarty->assign("tableArabicName" . $k, "يومية الخزن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "supplier_report_tbl") {
$smarty->assign("tableArabicName" . $k, "مديونية الموردين");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".supplierdebtchange");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "supplier_tbl") {
$smarty->assign("tableArabicName" . $k, "الموردين");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".supplier");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "type_tbl") {
$smarty->assign("tableArabicName" . $k, "وحدات القياس");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".unit");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "users_tbl") {
$smarty->assign("tableArabicName" . $k, "المستخدمين");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".user");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
} elseif ($row[0] == "withdrawals") {
$smarty->assign("tableArabicName" . $k, "مسحوبات الشركاء");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".partnerwithdrawal");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
$k++;
}
}
$smarty->assign("k", $k - 1);
$smarty->assign("newdatabaseName", $newdatabaseName);
$smarty->assign("newUserName", $newUserName);
$smarty->assign("newPassword", $newPassword);
$smarty->assign("olddatabaseName", $olddatabaseName);
$smarty->assign("oldUserName", $oldUserName);
$smarty->assign("oldPassword", $oldPassword);
}
function inserttabledata() {
global $smarty;
$tableName = $_POST['tablename'];
$newdatabaseName = $_POST['newdatabaseName'];
$newUserName = $_POST['newUserName'];
$newPassword = $_POST['newPassword'];
$olddatabaseName = $_POST['olddatabaseName'];
$oldUserName = $_POST['oldUserName'];
$oldPassword = $_POST['oldPassword'];
$smarty->assign("tablename", $tableName);
$smarty->assign("newdatabaseName", $newdatabaseName);
$smarty->assign("newUserName", $newUserName);
$smarty->assign("newPassword", $newPassword);
$smarty->assign("olddatabaseName", $olddatabaseName);
$smarty->assign("oldUserName", $oldUserName);
$smarty->assign("oldPassword", $oldPassword);
}
function exexcute() {
global $smarty;
$newdatabaseName = $_POST['newdatabaseName'];
$newUserName = $_POST['newUserName'];
$newPassword = $_POST['newPassword'];
$olddatabaseName = $_POST['olddatabaseName'];
$oldUserName = $_POST['oldUserName'];
$oldPassword = $_POST['oldPassword'];
try {
//new Database
$newDatabaseLink = mysql_connect('localhost', $newUserName, $newPassword, $newdatabaseName) or die(mysql_error());
} catch (Exception $e) {
return 0;
}
try {
//old Database
$oldDatabaseLink = mysql_connect('localhost', $oldUserName, $oldPassword, $olddatabaseName) or die(mysql_error());
} catch (Exception $e) {
return 0;
}
$tableName = $_POST['tablename'];
if ($tableName == "**agz_tbl") {
}
// elseif($tableName == "**backups_tbl")
// {
// }
// elseif($tableName == "**backup_info_tbl")
// {
// }
elseif ($tableName == "back_buy_bill_tbl") {
returnBuyBill();
} elseif ($tableName == "back_sell_bill_tbl") {
returnSellBill();
} elseif ($tableName == "bank_account_tbl") {
} elseif ($tableName == "bank_deposite_tbl") {
} elseif ($tableName == "bank_sa7b_tbl") {
}
///////
elseif ($tableName == "buy_bill_tbl") {
buyBill($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink);
} elseif ($tableName == "cat_tbl") {
productCategory($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink);
}
// elseif($tableName == "**changinstores_tbl")
// {
//
// }
// elseif($tableName == "**client1_report_tbl")
// {
//
// }
elseif ($tableName == "clients_tbl") {
client($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink);
}
///////////
// elseif($tableName == "client_report_tbl")
// {
// }
elseif ($tableName == "**discount_product_tmp_tbl") {
$smarty->assign("tableArabicName" . $k, "مديونية العملاء");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "**expenses_report_tbl") {
$smarty->assign("tableArabicName" . $k, "المصروفات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "expenses_tbl") {
$smarty->assign("tableArabicName" . $k, "المصروفات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".expenses");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "expenses_type") {
$smarty->assign("tableArabicName" . $k, "انواع المصروفات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".expensestype");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
}
////////
elseif ($tableName == "kem_tbl") {
$smarty->assign("tableArabicName" . $k, "الكمبيالات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".kempiala");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "owners") {
$smarty->assign("tableArabicName" . $k, "الشركاء");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".partner");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "**producttemp_tbl") {
$smarty->assign("tableArabicName" . $k, "مسحوبات الشركاء");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "**product_setting_tbl") {
$smarty->assign("tableArabicName" . $k, "المنتجات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "**product_supplier_tbl") {
$smarty->assign("tableArabicName" . $k, "تصنيفات المنتجات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "product_tbl") {
$smarty->assign("tableArabicName" . $k, "المنتجات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".product");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "**prog_setting_tbl") {
$smarty->assign("tableArabicName" . $k, "انواع المصروفات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "**save") {
$smarty->assign("tableArabicName" . $k, "الخزن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".returnbuybill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "saves_tbl") {
$smarty->assign("tableArabicName" . $k, "الخزن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".save");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "save_report_tbl") {
$smarty->assign("tableArabicName" . $k, "يومية الخزن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".savedaily");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "sell_bill_tbl") {
$smarty->assign("tableArabicName" . $k, "المبيعات");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".sellbill");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "store_details") {
$smarty->assign("tableArabicName" . $k, "حركة المخازن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".storereport");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "store_details_tbl") {
$smarty->assign("tableArabicName" . $k, "تفاصيل البضاعة بالمخازن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".storedetail");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "store_tbl") {
$smarty->assign("tableArabicName" . $k, "المخازن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".store");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
} elseif ($tableName == "store_transfer_tbl") {
$smarty->assign("tableArabicName" . $k, "التحويل بين المخازن");
$result = mysql_query("SELECT * FROM " . $newdatabaseName . ".storemovement");
$datacount = mysql_num_rows($result);
$smarty->assign("tableDataCount" . $k, $datacount);
$smarty->assign("tableName" . $k, $row[0]);
}
// elseif($tableName == "**store_transfer_tmp_tbl")
// {
// }
elseif ($tableName == "supplier_report_tbl") {
} elseif ($tableName == "supplier_tbl") {
supplier($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink);
} elseif ($tableName == "type_tbl") {
productUnit($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink);
} elseif ($tableName == "users_tbl") {
} elseif ($tableName == "withdrawals") {
withdrawals($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink);
}
}
function returnBuyBill() {
$newdatabaseName = $_POST['newdatabaseName'];
$newUserName = $_POST['newUserName'];
$newPassword = $_POST['newPassword'];
$olddatabaseName = $_POST['olddatabaseName'];
$oldUserName = $_POST['oldUserName'];
$oldPassword = $_POST['oldPassword'];
//new Database
$newDatabaseLink = mysql_connect('localhost', $newUserName, $newPassword, $newdatabaseName) or die(mysql_error());
//old Database
$oldDatabaseLink = mysql_connect('localhost', $oldUserName, $oldPassword, $olddatabaseName) or die(mysql_error());
$result = mysql_query("SELECT * FROM " . $olddatabaseName . ".back_buy_bill_tbl", $oldDatabaseLink);
while ($row = mysql_fetch_array($result)) {
$returnbuybilldirectpayment;
if ($row['back_buy_billSupplierId'] == 0) {
$returnbuybilldirectpayment = 0;
} else {
$returnbuybilldirectpayment = 1;
}
mysql_query("INSERT INTO " . $newdatabaseName . ".returnbuybill
(returnbuybillSerial, returnbuybilldate, returnbuybillsupplierid, returnbuybilltotaldeptbefor, returnbuybilltotaldeptafter, returnbuybilldiscount, returnbuybilldiscountrype, returnbuybilltotalbill, returnbuybillaftertotalbill, returnbuybilltotalpayed, returnbuybillfinalbill, returnbuybillstoreid, returnbuybillsysdate, userid, conditions, returnbuybillclientname, returnbuybillsaveid, billnameid, returnbuybilldirectpayment)
VALUES
('" . $row['back_buy_billSerial'] . "', '" . $row['back_buy_billDate'] . "', '" . $row['back_buy_billSupplierId'] . "', '" . $row['back_buy_billTotalDeptBefor'] . "', '" . $row['back_buy_billTotalDeptAfter'] . "', '" . $row['back_buy_billDiscount'] . "', '" . $row['back_buy_billDiscountType'] . "', '" . $row['back_buy_billTotalBill'] . "', '" . $row['back_buy_billAfterTotalBill'] . "', '" . $row['back_buy_billTotalPayed'] . "', '" . $row['back_buy_billFinalBill'] . "', '" . $row['back_buy_billStoreId'] . "', '" . $row['back_buy_billSysDate'] . "', 1, '" . $row['back_buy_billTypeDeleted'] . "', '', '" . $row['back_buy_billSaveId'] . "', 0, " . $returnbuybilldirectpayment . ")"
, $newDatabaseLink) or die(mysql_error());
}
}
function returnSellBill() {
$newdatabaseName = $_POST['newdatabaseName'];
$newUserName = $_POST['newUserName'];
$newPassword = $_POST['newPassword'];
$olddatabaseName = $_POST['olddatabaseName'];
$oldUserName = $_POST['oldUserName'];
$oldPassword = $_POST['oldPassword'];
//new Database
$newDatabaseLink = mysql_connect('localhost', $newUserName, $newPassword, $newdatabaseName) or die(mysql_error());
//old Database
$oldDatabaseLink = mysql_connect('localhost', $oldUserName, $oldPassword, $olddatabaseName) or die(mysql_error());
$result = mysql_query("SELECT * FROM " . $olddatabaseName . ".back_sell_bill_tbl", $oldDatabaseLink);
while ($row = mysql_fetch_array($result)) {
$returnsellbildirectpayment;
if ($row['back_sell_billClientId'] == 0) {
$returnsellbildirectpayment = 0;
} else {
$returnsellbildirectpayment = 1;
}
mysql_query("INSERT INTO " . $newdatabaseName . ".returnsellbill
(returnsellbillserial, returnsellbilldate, returnsellbillclientid, returnsellbilltotaldeptbefor, returnsellbilltotaldeptafter, returnsellbilldiscount, returnsellbilldiscounttype, returnsellbilltotalbill, returnsellbillaftertotalbill, returnsellbilltotalpayed, returnsellbillfinalbill, returnsellbillstoreid, returnsellbillsysdate, userid, conditions, returnsellbillclientname, returnsellbillsaveid, billnameid, returnsellbildirectpayment, sellerid, tempclientName)
VALUES
('" . $row['back_sell_billSerial'] . "', '" . $row['back_sell_billDate'] . "', '" . $row['back_sell_billClientId'] . "', '" . $row['back_sell_billTotalDeptBefor'] . "', '" . $row['back_sell_billTotalDeptAfter'] . "', '" . $row['back_sell_billDiscount'] . "', '" . $row['back_sell_billDiscountType'] . "', '" . $row['back_sell_billTotalBill'] . "', '" . $row['back_sell_billAfterTotalBill'] . "', '" . $row['back_sell_billTotalPayed'] . "', '" . $row['back_sell_billFinalBill'] . "', '" . $row['back_sell_billStoreId'] . "', '" . $row['back_sell_billSysDate'] . "', 1, '" . $row['back_sell_billTypeDeleted'] . "', '', '" . $row['back_sell_billSaveId'] . "', 0, " . $returnsellbildirectpayment . ", " . $row['seller'] . ", '')"
, $newDatabaseLink) or die(mysql_error());
}
}
function bankaccount() {
$newdatabaseName = $_POST['newdatabaseName'];
$newUserName = $_POST['newUserName'];
$newPassword = $_POST['newPassword'];
$olddatabaseName = $_POST['olddatabaseName'];
$oldUserName = $_POST['oldUserName'];
$oldPassword = $_POST['oldPassword'];
//new Database
$newDatabaseLink = mysql_connect('localhost', $newUserName, $newPassword, $newdatabaseName) or die(mysql_error());
//old Database
$oldDatabaseLink = mysql_connect('localhost', $oldUserName, $oldPassword, $olddatabaseName) or die(mysql_error());
$result = mysql_query("SELECT * FROM " . $olddatabaseName . ".bank_account_tbl", $oldDatabaseLink);
while ($row = mysql_fetch_array($result)) {
mysql_query("INSERT INTO " . $newdatabaseName . ".bank
(bankname, bankdetails, userid, conditions, bankdate)
VALUES
('" . $row['bankName'] . "', '" . $row['notes'] . "', 1, '" . $row['type_deleted'] . "', '" . $row['date'] . "')"
, $newDatabaseLink) or die(mysql_error());
mysql_query("INSERT INTO " . $newdatabaseName . ".bankaccount
(accountname, comment, accountnumber, accountbeginingbalance, accountdate, accountcurrencytype, bankid, userid, conditions)
VALUES
('" . $row['accName'] . "', '" . $row['notes'] . "', '" . $row['accNo'] . "', '" . $row['start_val'] . "', '" . $row['date'] . "', '', , 1, '" . $row['type_deleted'] . "')"
, $newDatabaseLink) or die(mysql_error());
}
}
//Yasmeen functions
function buyBill($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink) {
global $smarty;
mysql_query("SET NAMES 'utf8'");
mysql_query('SET CHARACTER SET utf8');
$count = 0;
try {
$result = mysql_query("SELECT * FROM " . $olddatabaseName . ".buy_bill_tbl", $oldDatabaseLink) or die(mysql_error());
} catch (Exception $e) {
return 0;
}
while ($row = mysql_fetch_array($result)) {
$buybilldirectpayment;
$buy_billOptionalSerial;
if ($row['buy_billSupplierId'] == 0) {
$buybilldirectpayment = 0;
} else {
$buybilldirectpayment = 1;
}
if ($row['buy_billOptionalSerial'] != "" || !empty($row['buy_billOptionalSerial'])) {
$serial = $row['buy_billOptionalSerial'];
} else {
$serial = $row['buy_billSerial'];
}
mysql_query("INSERT INTO " . $newdatabaseName . ".`buybill`
(buybillid, `buybillSerial` , `buybilldate` , `buybillsupplierid` , `buybilltotaldeptbefor` , `buybilltotaldeptafter` , `buybilldiscount` , `buybilldiscountrype` , `buybilltotalbill` , `buybillaftertotalbill` , `buybilltotalpayed` , `buybillfinalbill` , `buybillstoreid` , `buybillsysdate` , `userid` , `conditions` , `buybillclientname` , `buybillsaveid` , `buybilldirectpayment` , `billnameid` )
VALUES
('" . $row['ID'] . "', '" . $row['buy_billSerial'] . "', '" . $row['buy_billDate'] . "', '" . $row['buy_billSupplierId'] . "', '" . $row['buy_billTotalDeptBefor'] . "', '" . $row['buy_billTotalDeptAfter'] . "', '" . $row['buy_billDiscount'] . "', '" . $row['buy_billDiscountType'] . "', '" . $row['buy_billTotalBill'] . "', '" . $row['buy_billAfterTotalBill'] . "', '" . $row['buy_billTotalPayed'] . "', '" . $row['buy_billFinalBill'] . "', '" . $row['buy_billStoreId'] . "', '" . $row['buy_billSysDate'] . "', 1, '" . $row['buy_billTypeDeleted'] . "', '', '" . $row['buy_billSaveId'] . "', " . $buybilldirectpayment . ", 1)"
, $newDatabaseLink);
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`buybill`");
die('Error, select query failed with:' . $error);
}
$count++;
}
//////////////////////////////////////////////////////
$result2 = mysql_query("SELECT * FROM " . $olddatabaseName . ".buy_bill_details_tbl", $oldDatabaseLink);
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`buybill`");
die('Error, insert query failed with:' . $error);
}
while ($row = mysql_fetch_array($result2)) {
mysql_query("INSERT INTO " . $newdatabaseName . ".`buybilldetail`
( `Parcode` , `buybilldetailid` , `buybillid` , `buybilldetailcatid` , `buybilldetailproductid` , `buybilldetailquantity` , `buybilldetailprice` , `buybilldetailtotalprice` , `discountvalue` , `note` , `buybilldetaildate` , `productunitid` )
VALUES
(' ', '" . $row['ID'] . "', '" . $row['buy_bill_Id'] . "', '0', '" . $row['buy_billProductId'] . "', '" . $row['buy_billQuantity'] . "', '" . $row['buy_billPrice'] . "', '" . $row['buy_billTotalPrice'] . "', '" . $row['product_discount'] . "', '', '" . $row['buy_billDate'] . "', '0')"
, $newDatabaseLink);
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`buybill`");
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`buybilldetail`");
die('Error, insert query failed with:' . $error);
}
$count++;
}
$smarty->assign("rowCount", $count);
$smarty->assign("tablename", "فاتورة الشراء");
}
function productCategory($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink) {
global $smarty;
mysql_query("SET NAMES 'utf8'");
mysql_query('SET CHARACTER SET utf8');
$count = 0;
try {
$result = mysql_query("SELECT * FROM " . $olddatabaseName . ".cat_tbl", $oldDatabaseLink) or die(mysql_error());
} catch (Exception $e) {
return 0;
}
while ($row = mysql_fetch_array($result)) {
mysql_query("INSERT INTO " . $newdatabaseName . ".`productcat`
(productCatId, `productCatName` , `productCatDate` , `productCatDescription` , `productCatParent` , `userId` , `conditions` , `selldiscount` , `buydiscount` , `discounttype` )
VALUES
('" . $row['ID'] . "', '" . $row['catName'] . "', '" . $row['catDate'] . "', '" . $row['catDesc'] . "', '0', '1', '" . $row['catTypeDeleted'] . "', '" . $row['sell'] . "', '" . $row['buy'] . "', '" . $row['type'] . "')"
, $newDatabaseLink);
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`productcat`");
die('Error, insert query failed with:' . $error);
}
$count++;
}
$smarty->assign("rowCount", $count);
$smarty->assign("tablename", "تصنيفات المنتجات");
}
function client($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink) {
global $smarty;
mysql_query("SET NAMES 'utf8'");
mysql_query('SET CHARACTER SET utf8');
$count = 0;
try {
$result = mysql_query("SELECT * FROM " . $olddatabaseName . ".clients_tbl", $oldDatabaseLink) or die(mysql_error());
} catch (Exception $e) {
return 0;
}
while ($row = mysql_fetch_array($result)) {
mysql_query("INSERT INTO " . $newdatabaseName . ".`client`
( `clientid` , `clientname` , `clientaddress` , `clientphone` , `clientmobile` , `clientdebt` , `clientdetails` , `conditions` , `clientdate` , `userid` )
VALUES
('" . $row['ID'] . "',
'" . $row['clientName'] . "',
'" . $row['clientAddress'] . "',
'" . $row['clientTelephone'] . "',
'' ,
'" . $row['clientTotalDept'] . "',
'" . $row['clientComment'] . "',
'" . $row['clientTypeDeleted'] . "',
'" . $row['clientDate'] . "',
'1')"
, $newDatabaseLink);
if ($error = mysql_error()) {
//print("truncate");
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`client`");
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`clientdebtchange`");
die('Error, insert query failed with:' . $error);
}
$count++;
}
////////////////////////////////
$result2 = mysql_query("SELECT * FROM " . $olddatabaseName . ".client_report_tbl", $oldDatabaseLink);
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`client`");
die('Error, select query failed with:' . $error);
}
while ($row = mysql_fetch_array($result2)) {
$type;
if ($row['prev_dept'] > $row['dept_after']) {
$type = 1;
} else {
$type = 0;
}
mysql_query("INSERT INTO " . $newdatabaseName . ".clientdebtchange
(clientdebtchangeid, clientid, clientdebtchangebefore, clientdebtchangeamount, clientdebtchangetype, processname, clientdebtchangemodelid, clientdebtchangeafter, clientdebtchangedate, userid, tablename, comment)
VALUES
('" . $row['id'] . "', '" . $row['client_id'] . "', '" . $row['prev_dept'] . "', '" . $row['current_dept'] . "', '" . $type . "', '" . $row['describation'] . "', '" . $row['process_no'] . "', '" . $row['dept_after'] . "', '" . $row['dept_date'] . "', '1','0','0')"
, $newDatabaseLink);
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`client`");
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`clientdebtchange`");
die('Error, insert query failed with:' . $error);
}
$count++;
}
$smarty->assign("rowCount", $count);
$smarty->assign("tablename", "العملاء");
}
function supplier($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink) {
global $smarty;
mysql_query("SET NAMES 'utf8'");
mysql_query('SET CHARACTER SET utf8');
$count = 0;
try {
$result = mysql_query("SELECT * FROM " . $olddatabaseName . ".supplier_tbl", $oldDatabaseLink) or die(mysql_error());
} catch (Exception $e) {
return 0;
}
while ($row = mysql_fetch_array($result)) {
mysql_query("INSERT INTO " . $newdatabaseName . ".`supplier`
( `supplierid` , `suppliername` , `supplieraddress` , `supplierphone` , `suppliercurrentDebt` , `supplierdetails` , `conditions` , `userid` , `supplierdate` )
VALUES
('" . $row['ID'] . "',
'" . $row['supplierName'] . "',
'" . $row['supplierAddress'] . "',
'" . $row['supplierTelephone'] . "',
'" . $row['supplierTotalDept'] . "',
'" . $row['supplierComment'] . "',
'" . $row['supplierTypeDeleted'] . "',
'1',
'" . $row['supplierDate'] . "')"
, $newDatabaseLink);
if ($error = mysql_error()) {
//print("truncate");
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`supplier`");
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`supplierdebtchange`");
die('Error, insert query failed with:' . $error);
}
$count++;
}
////////////////////////////////
$result2 = mysql_query("SELECT * FROM " . $olddatabaseName . ".supplier_report_tbl", $oldDatabaseLink);
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`supplier`");
die('Error, select query failed with:' . $error);
}
while ($row = mysql_fetch_array($result2)) {
$type;
if ($row['SR_Dept_Befor'] > $row['SR_Dept_After']) {
$type = 1;
} else {
$type = 0;
}
/////
if ($row['SR_Model'] == "kemnon") {
$row['SR_Model'] = "الغاء كمبيالة";
} elseif ($row['SR_Model'] == "kem") {
$row['SR_Model'] = " كمبيالة";
} elseif ($row['SR_Model'] == "buy") {
$row['SR_Model'] = "فاتورة شراء";
} elseif ($row['SR_Model'] == "buyback") {
$row['SR_Model'] = " فاتورة مردودات مشتريات";
} elseif ($row['SR_Model'] == "paydept") {
$row['SR_Model'] = " سداد دين";
}
/////
mysql_query("INSERT INTO " . $newdatabaseName . ".supplierdebtchange
(supplierdebtchangeid, `supplierid` , `supplierdebtchangebefore` , `supplierdebtchangeamount` , `supplierdebtchangetype` , `processname` , `supplierdebtchangemodelid` , `supplierdebtchangeafter` , `supplierdebtchangedate` , `userid` , `tablename` , `comment` )
VALUES
('" . $row['SR_ID'] . "',
'" . $row['SR_SupplierID'] . "',
'" . $row['SR_Dept_Befor'] . "',
'" . $row['SR_Price_Payed'] . "',
'" . $type . "',
'" . $row['SR_Model'] . "',
'" . $row['SR_Model_ID'] . "',
'" . $row['SR_Dept_After'] . "',
'" . $row['SR_Date'] . "',
'1',
'0',
' ')"
, $newDatabaseLink);
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`supplier`");
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`supplierdebtchange`");
die('Error, insert query failed with:' . $error);
}
$count++;
}
$smarty->assign("rowCount", $count);
$smarty->assign("tablename", "الموردين");
}
function productUnit($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink) {
global $smarty;
mysql_query("SET NAMES 'utf8'");
mysql_query('SET CHARACTER SET utf8');
$count = 0;
try {
$result = mysql_query("SELECT * FROM " . $olddatabaseName . ".type_tbl", $oldDatabaseLink) or die(mysql_error());
} catch (Exception $e) {
return 0;
}
while ($row = mysql_fetch_array($result)) {
mysql_query("INSERT INTO " . $newdatabaseName . ".`unit`
( `unitId` , `unitName` , `unitSymbol` , `unitDescription` , `unitDate` , `conditions` , `userId`)
VALUES
('" . $row['ID'] . "',
'" . $row['typeName'] . "',
'" . $row['typeSymbol'] . "',
'" . $row['typeDesc'] . "',
'" . $row['typeDate'] . "',
'" . $row['typeTypeDeleted'] . "',
'1')", $newDatabaseLink);
if ($error = mysql_error()) {
//print("truncate");
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`unit`");
die('Error, insert query failed with:' . $error);
}
$count++;
}
/////////// check if product table has data ///////////////////
$product_result = mysql_query("SELECT * FROM " . $newdatabaseName . ".product", $newDatabaseLink);
$num_of_products = mysql_num_rows($product_result);
if (!empty($num_of_products) && $num_of_products > 0) {
$old_product_result = mysql_query("SELECT * FROM " . $olddatabaseName . ".product_tbl", $oldDatabaseLink);
while ($row2 = mysql_fetch_array($old_product_result)) {
////////////////////////////////
if (isset($row2['productTypeId']) && !empty($row2['productTypeId']) && $row2['productTypeId'] != NULL) {
mysql_query("INSERT INTO " . $newdatabaseName . ".productunit
(`unitid` , `productid` , `productnumber` , `productunitdate` , `userid` , `conditions`)
VALUES
('" . $row2['productTypeId'] . "',
'" . $row2['ID'] . "',
'1',
'" . $row2['productDate'] . "',
'1',
'0')", $newDatabaseLink);
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`productunit`");
die('Error, insert query failed with:' . $error);
}
$count++;
}
}
}
$smarty->assign("rowCount", $count);
$smarty->assign("tablename", "وحدات القياس");
}
function withdrawals($newdatabaseName, $olddatabaseName, $newDatabaseLink, $oldDatabaseLink) {
global $smarty;
mysql_query("SET NAMES 'utf8'");
mysql_query('SET CHARACTER SET utf8');
$count = 0;
try {
$result = mysql_query("SELECT * FROM " . $olddatabaseName . ".withdrawals", $oldDatabaseLink) or die(mysql_error());
} catch (Exception $e) {
return 0;
}
while ($row = mysql_fetch_array($result)) {
mysql_query("INSERT INTO " . $newdatabaseName . ".`partnerwithdrawal`
( `partnerwithdrawalid` , `partnerid` , `partnerwithdrawalvalue` , `comment` , `partnerwithdrawaldate` , `userid` , `saveid` , `conditions` )
VALUES
('" . $row['id'] . "',
'" . $row['toWhom'] . "',
'" . $row['money'] . "',
'" . $row['comment'] . "',
'" . $row['enter_date'] . "',
'1',
'" . $row['save_id'] . "',
'0')", $newDatabaseLink) or die(mysql_error());
if ($error = mysql_error()) {
mysql_query("TRUNCATE TABLE " . $newdatabaseName . ".`partnerwithdrawal`");
die('Error, insert query failed with:' . $error);
}
$count++;
}
$smarty->assign("rowCount", $count);
$smarty->assign("tablename", "مسحوبات الشركاء");
}
?>