get('roleid');
$viewer = new Vtiger_Viewer();
$viewer->assign('MODULE', 'Home');
$viewer->assign('SELECTED_MENU_CATEGORY', 'MARKETING');
$viewer->assign('COMPANY_LOGO', Vtiger_CompanyDetails_Model::getInstanceById()->getLogo());
$viewer->assign('COMPANY_DETAILS_SETTINGS',new Settings_Vtiger_CompanyDetails_Model());
$viewer->assign('USER_MODEL', $current_user);
$viewer->assign('CURRENT_USER_MODEL', $current_user);
$viewer->assign('PAGETITLE','Modifier Encaissement ');
$viewer->view('CustomDashboard.tpl');
if(isset($_POST['editEncaissement'])) {
$dateTime_modification = date("Y-m-d h:i:s", strtotime('1 hour'));
$commentaire = isset($_POST['commentaire']) ? $_POST['commentaire'] : null ;
if( $_POST['isUpload'] == 1 ){
//uploaded File
if($_FILES['image']['name'] != ""){
$file_name = $_FILES['image']['name'];
$file_tmp =$_FILES['image']['tmp_name'];
$ext = strtolower(pathinfo($file_name, PATHINFO_EXTENSION));
$datetime = date("Ymdhis");
$extensionToMinuscule = strtolower($ext);
$lien="file_upload/".$datetime.".".$extensionToMinuscule;
$valid_ext = array("png","jpeg","jpg" ,"gif");
if(in_array($ext, $valid_ext)){
move_uploaded_file($file_tmp,$lien);
}
}
$sql = 'UPDATE encaissement SET `code_client` = ? , `type_encaissement` = ?, `numero_transaction` = ?, `banque` = ?, `montant` = ?,
`date_reception` = ?,`date_paiement` = ? , `statut` = ?,`date_encaissement` = ?,`image_lien` = ?,
`dateTime_modification`= ? ,`commentaire` = ? where code_encaissement = ? ';
$params = array($_POST['code_client'] ,
$_POST['type_encaissement'] ,
$_POST['numero_transaction'] ,
$_POST['banque'] ,
$_POST['montant'] ,
$_POST['date_reception'] ,
$_POST['date_paiement'] ,
$_POST['statut'] ,
$_POST['date_encaissement'] ,
$lien ,
$dateTime_modification ,
$commentaire ,
$_POST['code_encaissement']
);
$adb->pquery($sql, $params);
}else{
$sql = 'UPDATE encaissement SET `code_client` = ? , `type_encaissement` = ?, `numero_transaction` = ?, `banque` = ?, `montant` = ?,
`date_reception` = ?,`date_paiement` = ? , `statut` = ?,`date_encaissement` = ?,
`dateTime_modification`= ? ,`commentaire` = ? where code_encaissement = ? ';
$params = array($_POST['code_client'] ,
$_POST['type_encaissement'] ,
$_POST['numero_transaction'] ,
$_POST['banque'] ,
$_POST['montant'] ,
$_POST['date_reception'] ,
$_POST['date_paiement'] ,
$_POST['statut'] ,
$_POST['date_encaissement'] ,
$dateTime_modification ,
$commentaire ,
$_POST['code_encaissement']
);
$adb->pquery($sql, $params);
}
$sql2 = 'UPDATE encaissement_facture SET `date_echeance` = ?,`numero_facture` = ? where code_encaissement = ?';
$params2 = array($_POST['date_echeance'] ,$_POST['numero_facture'] ,$_POST['code_encaissement']);
$adb->pquery($sql2, $params2);
header("Location: index.php?module=Encaissement&view=Encaissement");
}
function getAllGrossiste(){
global $adb;
$query5 = "SELECT accountid,accountname FROM `vtiger_account` WHERE `industry`='grossiste' ";
$result5 =$adb->query($query5);
$Grossistes=array();
while ($recordinfo = $adb->fetch_array($result5)) {
$Grossistes[] = $recordinfo;
}
return $Grossistes;
}
function getEncaissementByID(){
global $adb;
$query6 = "SELECT * FROM `encaissement` WHERE `code_encaissement`='".$_GET['code_encaissement']."' ";
$result6 =$adb->query($query6);
$Encaissements=array();
while ($recordinfo = $adb->fetch_array($result6)) {
$Encaissements[] = $recordinfo;
}
return $Encaissements;
}
function getGrossisteByAccountid($accountid){
global $adb;
$query7 = "SELECT accountname FROM `vtiger_account` WHERE `accountid`='".$accountid."' ";
$result7 =$adb->query($query7);
$accountname=array();
while ($recordinfo = $adb->fetch_array($result7)) {
$accountname[] = $recordinfo;
}
return $accountname[0]['accountname'];
}
function getInfomationFacture($code_Encaissemnet){
global $adb;
$query8 = "SELECT * FROM `encaissement_facture` WHERE `code_encaissement`='".$code_Encaissemnet."' ";
$result8 =$adb->query($query8);
$InfomationFacture=array();
while ($recordinfo = $adb->fetch_array($result8)) {
$InfomationFacture[] = $recordinfo;
}
return $InfomationFacture;
}
function getFullname($id){
global $adb;
$query = "SELECT first_name,last_name FROM `vtiger_users` where id ='".$id."' ";
$sql_get_result = $adb->query($query);
$res= array();
while ($recordinfo = $adb->fetch_array($sql_get_result)) {
$res[] = $recordinfo;
}
return $res[0]['first_name']." ".$res[0]['last_name'];
}
$Encaissements=getEncaissementByID();
$InfomationFacture=getInfomationFacture($_GET['code_encaissement']);
$montant=number_format($Encaissements[0]['montant'],2,".","");
$lien = explode("/", $Encaissements[0]['image_lien']);
echo'
';
$viewer->view('CustomDashboardFooter.tpl');
?>