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; }