function formatPhoneNumber($str = "")
{
if ($str != "") {
$str = cleanStr($str);
$area_code = "(" . substr($str, 0, 3) . ") ";
$number1 = substr($str, 3, 3) . "-";
$number2 = substr($str, 6);
}
return $area_code . $number1 . $number2;
}
function getPartidasFaltantes($bufferarray, $partidasR)
{
$totalRows_ifpartidas = count($bufferarray);
if ($totalRows_ifpartidas < 1) {
echo "****ESTA FACTURA NO TIENE PARTIDAS****";
return null;
}
$part = new Partida();
$pedp = new Impuesto();
$numeroP = 0;
foreach ($bufferarray as $pair) {
//nueva partida.
$numeroP++;
$part = new Partida();
$part->numero = $numeroP;
$part->cantidad = doubleval(number_format($pair[3], 2, ".", ""));
if (empty($pair[4])) {
$part->unidad = "pza";
} else {
$part->unidad = $pair[2];
}
$part->concepto = cleanStr($pair[2]);
$part->ean = limpiaespacios($pair[1]);
$part->ean = str_replace('¬', '', $part->ean);
array_push($partidasR, $part);
}
//end foreach.
return $partidasR;
}
/**
* @author JASR
* Valida las propiedades de las partidas
* @param $propiedad nombre de la propiedad a validar, es la "pocicion" en el arreglo asociativo
* @param $valor valor a validar
* @since Version Face 5.5 (19 Junio 2013)
*/
function validarPropiedadPartida($propiedad, $valor)
{
switch ($propiedad) {
case 'numero':
return intval($valor);
case 'unidad':
return $valor;
case 'concepto':
return cleanStr($valor);
default:
return doubleval(number_format(doubleval($valor), 2, ".", ""));
}
}
function removeCommas($number)
{
return cleanStr(str_replace(",", "", $number));
}
}
$items = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
//sleep(2);
return $items;
}
/**
* @param $maxi
* @return array|bool|null
*/
function getControlUnit($maxi)
{
global $link;
$sql = "SELECT n.article, n.name, p.code AS code, p.value, p1.code AS code1, p1.value AS value1\n FROM nomenklatura AS n\n INNER JOIN properties AS p ON n.article = p.article\n INNER JOIN properties AS p1 ON n.article = p1.article\n WHERE p.code = '000000074'\n AND p1.code = '000000073'\n AND ( {$maxi}\n BETWEEN p.value\n AND p1.value )";
if (!($result = mysqli_query($link, $sql))) {
return false;
}
$items = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
return $items;
}
if (isset($_POST['TypePump'])) {
$tp = cleanStr($_POST['TypePump']);
$res = getPumps($tp);
echo json_encode($res);
}
if (isset($_POST['maxi'])) {
$maxi = cleanStr($_POST['maxi']);
$unit = getControlUnit($maxi);
echo json_encode($unit);
}
$users[$temp[0]] = $temp[1];
}
} else {
echo "::" . $value . ":: NOT VALID";
}
}
function cleanStr($string)
{
$string = str_replace(' ', '-', $string);
// Replaces all spaces with hyphens.
$string = preg_replace('/[^A-Za-z0-9\\-]/', '', $string);
// Removes special chars.
return preg_replace('/-+/', '-', $string);
// Replaces multiple hyphens with single one.
}
$users = cleanStr($users);
$i = 0;
foreach ($users as $key => $value) {
$priva = $privo = $privm = $privs = "";
switch ($value) {
case 'a':
//echo "admin";
$priva = "selected";
break;
case 'o':
//echo "op";
$privo = "selected";
break;
case 'm':
//echo "mod";
$privm = "selected";
} else {
$sum_inter++;
}
}
/* Build PDF */
$pdf = new BordereauPDF();
$pdf->SetFont('Arial', 'B', 10);
$pdf->AddPage();
$pdf->Cell(150, 10, 'BORDEREAU RECAPITULATIF');
$pdf->SetFont('Arial', '', 10);
$pdf->Cell(100, 10, 'date : ' . date('d/m/Y'));
$pdf->Ln();
$pdf->Ln();
$pdf->SetFont('Arial', 'B', 10);
$pdf->OxiCell('EMETTEUR', 0, 10);
$pdf->HeadTable(array(array('NUMERO DE COMPTE', Configuration::get('CHRONOPOST_GENERAL_ACCOUNT')), array('NOM', cleanStr(Configuration::get('CHRONOPOST_CUSTOMER_NAME'))), array('ADRESSE', cleanStr(Configuration::get('CHRONOPOST_CUSTOMER_ADDRESS'))), array('ADRESSE (SUITE)', cleanStr(Configuration::get('CHRONOPOST_CUSTOMER_ADDRESS2'))), array('VILLE', cleanStr(Configuration::get('CHRONOPOST_CUSTOMER_CITY'))), array('CODE POSTAL', Configuration::get('CHRONOPOST_CUSTOMER_ZIPCODE')), array('PAYS', 'FRANCE'), array('TELEPHONE', Configuration::get('CHRONOPOST_CUSTOMER_PHONE')), array('POSTE COMPTABLE', (int) (Configuration::get('CHRONOPOST_CUSTOMER_ZIPCODE') / 1000) * 1000 + 999)));
$pdf->SetFont('Arial', 'B', 10);
$pdf->Ln();
$pdf->Ln();
$pdf->OxiCell('DETAIL DES ENVOIS', 0, 10);
$pdf->InnerTable(array('NUM DE LT', 'CODE PRODUIT', 'CODE POSTAL', 'PAYS', 'ASSURANCE', 'VILLE'), $recapLT);
$pdf->SetFont('Arial', 'B', 10);
$pdf->Ln();
$pdf->Ln();
$pdf->OxiCell('RESUME', 0, 10);
$pdf->InnerTable(array('DESTINATION', 'UNITE'), array(array('NATIONAL', $sum_nat), array('INTERNATIONAL', $sum_inter), array('TOTAL', $sum_inter + $sum_nat)), array(40, 20));
$pdf->Ln(15);
$pdf->SetFont('Arial', 'B', 10);
$pdf->OxiCell('Bien pris en charge ' . ($sum_inter + $sum_nat) . ' colis.', 0, 10);
$pdf->Ln(25);
$pdf->HeadTable(array(array('Signature du Client', 'Signature du Messager Chronopost')), array(95, 95), false);
public function shortUpdateItem()
{
$id = $_POST['item_id'];
if (is_numeric($id)) {
$table = 'rm_items';
$sql = "UPDATE ?n SET ?u WHERE ?u";
$data2 = array(
'id' => $id,
);
$data1 = array();
if ($_POST['item_action']) {
$data1 += array('item_action' => cleanStr($_POST['item_action']));
};
if ($_POST['item_result']) {
$data1 += array('item_result' => cleanStr($_POST['item_result']));
};
if (is_numeric($_POST['item_elapsed'])) {
$data1 += array('item_elapsed' => cleanStr($_POST['item_elapsed']));
};
if ($_POST['alt_task_name']) {
$table = 'rm_alt_task_name';
$data1 = array(
'alt_task_name' => cleanStr($_POST['alt_task_name'], 'delNL'),
'task_id' => $id,
);
$data2 = array(
'alt_task_name' => cleanStr($_POST['alt_task_name'], 'delNL'),
);
$sql = "INSERT ?n SET ?u ON DUPLICATE KEY UPDATE ?u";
};
if (empty($data1)){
$ajax_answer = array(
'status' => 'error',
'result' => '',
'msg' => 'Обновление записи не удалось!<br>Нет такой записи в БД<br>ShortUpdate',
'reload_html' => ''
);
return $ajax_answer;
}
try {
$this->obDb->query($sql, $table, $data1, $data2);
$ajax_answer = array(
'status' => 'success',
'result' => $id,
'msg' => '',
'reload_html' => $this->reloadRecentItems('html'),
);
} catch (Exception $e) {
$ajax_answer = array(
'status' => 'error',
'result' => '',
'msg' => 'Обновление записи не удалось!<br>Выброшено исключение:<br>' . $e->getMessage() . "<br>",
'reload_html' => ''
);
}
} else {
$ajax_answer = array(
'status' => 'error',
'result' => '',
'msg' => 'Ошибка! <br>Обновление записи не удалось!<br>Нет такой записи',
'reload_html' => ''
);
}
return $ajax_answer;
}
