function generateIdDoc($type, $company, $order)
{
//[X : typedocument][XX : Year][X : country][XXXX : id commande]
$year = date('y');
$country = 5;
$typedocument = $type;
$country_company = $company->getNationality();
$extraction = new extraction();
$allPartners = $extraction->get('partner');
$id_order = $order->getId();
$id_to_print = "";
$count = strlen((string) $id_order);
for ($i = 0; $i < 4 - $count; $i++) {
$id_to_print .= "0";
}
$id_to_print .= $id_order;
foreach ($allPartners as $partner) {
if ($partner->getCountry() == $country_company) {
$country = $partner->getRef();
break;
}
}
//id commande à replacer par référence commande quand ce sera fait
$id_document = $typedocument . $year . $country . $id_to_print;
return $id_document;
}
public function getFromDatabase()
{
$stmt_get = $this->pdo->PDOInstance->prepare("SELECT * FROM group_product WHERE id = :id");
$stmt_get->bindParam(':id', $this->id);
try {
$stmt_get->execute();
} catch (Exception $e) {
echo "Problem at " . $e->getLine() . " from model group_product :" . $e->getMessage();
}
if ($stmt_get->rowcount() != 0) {
$stmt_get = $stmt_get->fetch(PDO::FETCH_ASSOC);
foreach ($stmt_get as $key => $value) {
$this->{$key} = $value;
}
$extraction = new extraction();
$this->parameters = $extraction->getParametersFromType($this->type);
return true;
} else {
return false;
}
}
<?php
require_once '../model/extraction.php';
require_once '../model/' . $_GET["class"] . '.php';
$extraction = new extraction();
$needle = $_GET["needle"];
$results = $extraction->searchFor($_GET["class"], $needle);
$json = array();
if ($_GET["class"] == "company") {
foreach ($results as $result) {
$item = array("id" => $result->getId(), "text" => $result->printText(), "billing_period_bis" => $result->getNormal_billing_period());
array_push($json, $item);
}
} else {
foreach ($results as $result) {
$item = array("id" => $result->getId(), "text" => $result->printText());
array_push($json, $item);
}
}
$json = json_encode($json);
echo $json;
<?php require_once 'checkSession.php'; require_once '../model/extraction.php'; require_once '../model/customer.php'; $extraction = new extraction(); $customers = $extraction->getCustomers(); include '../view/customers.php';
<?php require "../model/extraction.php"; $extraction = new extraction(0, 0); $clients = $extraction->extractClientMail(); include "../view/realBaseClient.php";
public function printToAdd($next)
{
$extraction = new extraction();
$groups = $extraction->getRight_group();
echo '
<input type="hidden" name="id" value="' . $this->id . '">
<input type="hidden" name="next" value="' . $next . '">
<div class="form-group">
<label for="name">' . $this->tf->getText(25) . '</label>
<input name="name" type="text" class="form-control" value="">
</div>
<div class="form-group">
<label for="surname">' . $this->tf->getText(53) . '</label>
<input name="surname" type="text" class="form-control" value="">
</div>
<div class="form-group">
<label for="mail">' . $this->tf->getText(51) . '</label>
<input name="mail" type="text" class="form-control" value="">
</div>
<div class="form-group">
<label for="short_phone">' . $this->tf->getText(54) . '</label>
<input name="short_phone" type="number" class="form-control" value="">
</div>
<div class="form-group">
<label for="phone_number">' . $this->tf->getText(45) . '</label>
<input name="phone_number" type="text" class="form-control" value="">
</div>
<div class="form-group">
<label for="right_group">' . $this->tf->getText(57) . '</label>
<select name="right_group" class="form-control">
';
$a = 0;
foreach ($groups as $group) {
if ($a == 0) {
echo '<option selected="selected" value="' . $group->getId() . '">' . ucfirst($group->getName()) . '</option>';
$a = 1;
} else {
echo '<option value="' . $group->getId() . '">' . ucfirst($group->getName()) . '</option>';
}
}
echo '
</select>
</div>
<div class="form-group">
<label for="birthdate">' . $this->tf->getText(56) . '</label>
<input name="birthdate" type="date" class="form-control" value="">
</div>
<div class="form-group">
<label for="login">' . $this->tf->getText(3) . '</label>
<input name="login" type="text" class="form-control" value="">
</div>
<div class="form-group">
<label for="password">' . $this->tf->getText(4) . '</label>
<input name="password" type="password" class="form-control" value="">
</div>
';
}
<?php
require_once '../model/extraction.php';
require_once '../model/product.php';
$extraction = new extraction();
$needle = $_GET["needle"];
$results = $extraction->getProductForOrder($needle);
$json = array();
foreach ($results as $result) {
$group = $result->getGroup_product();
if (count($group->getParameters()) != 0) {
$isParameter = true;
$parameters = $group->getJSONParameters();
} else {
$isParameter = false;
$parameters = null;
}
$item = array("id" => $result->getId(), "text" => $result->getName() . ' ' . $result->getDescription(), "price" => $result->getPrice(), "isParameter" => $isParameter, "parameters" => $parameters);
array_push($json, $item);
}
$json = json_encode($json, JSON_FORCE_OBJECT);
echo $json;
<?php
require_once 'checkSession.php';
require_once '../model/parameter.php';
require_once '../model/extraction.php';
$extraction = new extraction();
$parameters = $extraction->get("parameter");
function compare($a, $b)
{
return intval($a->getRef()) - intval($b->getRef());
}
usort($parameters, "compare");
include '../view/parameters.php';
<?php
require_once '../model/extraction.php';
if (isset($_GET["dateDeb"]) && isset($_GET["dateEnd"])) {
$extraction = new extraction($_GET["dateDeb"], $_GET["dateEnd"]);
$deb = $_GET["dateDeb"];
$end = $_GET["dateEnd"];
$startDate = DateTime::createFromFormat('j-m-y', $deb)->getTimestamp();
$endDate = DateTime::createFromFormat('j-m-y', $end)->getTimestamp();
$startMonth = date('m', $startDate);
$startYear = date('y', $startDate);
$nb_month = abs((date('Y', $endDate) - date('Y', $startDate)) * 12 + (date('m', $endDate) - date('m', $startDate))) + 1;
$columns = array("GER" => array(), "ESP" => array());
for ($i = 0; $i < $nb_month; $i++) {
$month = ($startMonth - 1 + $i) % 12 + 1;
if ($month < 10) {
$month = '0' . $month;
}
$year = intval(strval(($startMonth - 1 + $i) / 12)) + $startYear;
$key = $month . '-' . $year;
if ($i == 0) {
$deb_a = $deb;
$end_a = date('t-m-y', $startDate);
} else {
if ($i == $nb_month - 1) {
$deb_a = '01-' . $key;
$end_a = $end;
} else {
$deb_a = '01-' . $key;
$end_a = date('t', strtotime('01-' . $key)) . '-' . $key;
}
<?php
$displayResult = false;
if (isset($_GET["dateBegin"]) && isset($_GET["dateEnd"])) {
$displayResult = true;
require '../model/extraction.php';
$extraction = new extraction($_GET["dateBegin"], $_GET["dateEnd"]);
$clients = $extraction->extractClient('RE');
$debDateYear = intval(substr($_GET["dateBegin"], 0, 4));
$endDateYear = intval(substr($_GET["dateEnd"], 0, 4));
$nbYear = $endDateYear - $debDateYear;
$debDateMounth = intval(substr($_GET["dateBegin"], 5, 2));
$endDateMounth = intval(substr($_GET["dateEnd"], 5, 2));
$nbMounth = $endDateMounth - $debDateMounth;
if ($nbYear == 0) {
$nbColumn = $nbMounth;
$jtab = array(array($debDateMounth, $endDateMounth));
} else {
if ($nbYear == 1 && $endDateMounth < $debDateMounth) {
$nbColumn = 13 - $debDateMounth + $endDateMounth;
$jtab = array(array($debDateMounth, 12), array(1, $endDateMounth));
} else {
$nbColumn = 13 - $debDateMounth + 12 * $nbYear + $endDateMounth;
$jtab = array(array($debDateMounth, 12));
for ($i = 1; $i < $nbYear; $i++) {
array_push($jtab, array(1, 12));
}
array_push($jtab, array(1, $endDateMounth));
}
}
$clientsES1 = $extraction->extractClient('FA');
<?php
require_once 'checkSession.php';
require_once '../model/extraction.php';
require_once '../model/order.php';
$extraction = new extraction();
if (isset($_GET["display"])) {
$display = $_GET["display"];
} else {
$display = "all";
}
$orders = $extraction->getOrders($display);
include_once '../view/orders.php';
<?php require_once 'checkSession.php'; require_once '../model/employee.php'; require_once '../model/extraction.php'; $extraction = new extraction(); $employees = $extraction->getEmployee(); include '../view/employees.php';
<?php require_once 'checkSession.php'; require_once '../model/group_products.php'; require_once '../model/extraction.php'; $extraction = new extraction(); $groups = $extraction->getGroup(); include '../view/groupProducts.php';
public function printToModify($next)
{
$extraction = new extraction();
$groups = $extraction->getGroup();
echo '
<input type="hidden" name="id" value="' . $this->id . '">
<input type="hidden" name="next" value="' . $next . '">
<div class="form-group">
<label for="ref">' . $this->tf->getText(59) . '</label>
<input name="ref" type="text" class="form-control" value="' . $this->ref . '">
</div>
<div class="form-group">
<label for="name">' . $this->tf->getText(25) . '</label>
<input name="name" type="text" class="form-control" value="' . $this->name . '">
</div>
<div class="form-group">
<label for="description">' . $this->tf->getText(42) . '</label>
<input name="description" type="text" class="form-control" value="' . $this->description . '">
</div>
<div class="form-group">
<label for="id_group">' . $this->tf->getText(34) . '</label>
<select name="id_group" class="form-control">
';
foreach ($groups as $group) {
if ($this->id_group == $group->getId()) {
echo '<option selected="selected" value="' . $group->getId() . '">' . $group->getName() . '</option>';
} else {
echo '<option value="' . $group->getId() . '">' . $group->getName() . '</option>';
}
}
echo '
</select>
</div>
<div class="form-group">
<label for="description">' . $this->tf->getText(89) . '</label>
<input name="unit" type="text" class="form-control" value="' . $this->unit . '">
</div>
<div class="form-group">
<label for="description">' . $this->tf->getText(90) . '</label>
<input name="cost" type="text" class="form-control" value="' . $this->cost . '">
</div>
<div class="form-group">
<label for="description">' . $this->tf->getText(75) . '</label>
<input name="price" type="text" class="form-control" value="' . $this->price . '">
</div>
';
}
<?php
require_once 'checkSession.php';
require_once '../model/company.php';
require_once '../model/extraction.php';
if (isset($_GET["id"])) {
$company = new company($_GET["id"]);
$extraction = new extraction();
$orders = $extraction->getOrderFromCompany($_GET["id"]);
} else {
$error;
}
include '../view/company.php';
<?php
require_once '../model/order.php';
require_once '../model/company.php';
require_once '../model/extraction.php';
$order = new order($_GET['id']);
$company = new company($order->getId_company());
$receiving_address = new address($company->getId_receiving_address());
// Génération du n° Document
//[X : typedocument][XX : Year][X : country][XXXX : id commande]
$typedocument = 7;
$year = date('y');
$country = 5;
$country_company = $company->getNationality();
$extraction = new extraction();
$allPartners = $extraction->get('partner');
$id_order = $order->getId();
$id_to_print = "";
$count = strlen((string) $id_order);
for ($i = 0; $i < 4 - $count; $i++) {
$id_to_print .= "0";
}
$id_to_print .= $id_order;
foreach ($allPartners as $partner) {
if ($partner->getCountry() == $country_company) {
$country = $partner->getRef();
break;
}
}
//id commande à replacer par référence commande quand ce sera fait
$id_document = $typedocument . $year . $country . $id_to_print;
<?php
require_once '../model/error.php';
require_once '../model/employee.php';
require_once '../model/extraction.php';
require_once 'checkSession.php';
if (isset($_GET["id"])) {
$employee = new employee($_GET["id"]);
if ($employee == NULL) {
$error;
}
$extraction = new extraction();
$orders = $extraction->getOrderFromEmployee($_GET["id"]);
} else {
$error;
}
include '../view/employee.php';
<?php
require_once 'checkSession.php';
$display = false;
$extraction = new extraction();
$actualYears = date('y');
$actualMonth = date('m');
$debDateYear = '01-01-' . $actualYears;
$endDateYear = '31-12-' . $actualYears;
$debDateMonth = '01-' . $actualMonth . '-' . $actualYears;
$endDateMonth = date('t-m-y', strtotime($actualYears . '-' . $actualMonth . '-' . '31'));
$ordersYear = $extraction->getOrdersWithDate($debDateYear, $endDateYear);
$ordersMonth = $extraction->getOrdersWithDate($debDateMonth, $endDateMonth);
//Calcul of year turnover
$yearTurnover = 0;
foreach ($ordersYear as $order) {
$yearTurnover += $order->getPrice();
}
$yearTurnover = number_format($yearTurnover, 2, ',', ' ');
//Calcul of month turnover
$monthTurnover = 0;
foreach ($ordersMonth as $order) {
$monthTurnover += $order->getPrice();
}
$monthTurnover = number_format($monthTurnover, 2, ',', ' ');
//Calcul of the period if set
if (isset($_GET["dateDeb"]) && $_GET["dateDeb"] != "" && isset($_GET["dateEnd"]) && $_GET["dateEnd"] != "") {
//Check if the period is in the new or the old Biothys
$dateMigration = "15-08-15";
$tsdateMigration = DateTime::createFromFormat('j-m-y', $dateMigration)->getTimestamp();
$display = true;
public function printToAdd($next)
{
$extraction = new extraction();
if ($this->billing_address == NULL) {
$this->getBillingAddress();
}
$groups = $extraction->get("group_company");
echo '
<input type="hidden" name="id" value="' . $this->id . '">
<input type="hidden" name="next" value="' . $next . '">
<input type="hidden" name="class" value="company">
<div class="form-group">
<label for="name">' . $this->tf->getText(25) . '</label>
<input name="name" type="text" class="form-control" value="' . $this->name . '">
</div>
<div class="form-group">
<label for="nationality">' . $this->tf->getText(50) . '</label>
<input name="nationality" type="text" class="form-control" value="' . $this->nationality . '">
</div>
<div class="form-group">
<label for="countryWhoBill">Country who bill</label>
<input name="countryWhoBill" type="text" class="form-control" value="' . $this->countryWhoBill . '">
</div>
<div class="form-group">
<label for="description">' . $this->tf->getText(42) . '</label>
<input name="description" type="text" class="form-control" value="' . $this->description . '">
</div>
<div class="form-group">
<label for="phone_number">' . $this->tf->getText(45) . '</label>
<input name="phone_number" type="text" class="form-control" value="' . $this->phone_number . '">
</div>
<div class="form-group">
<label for="id_contact">' . $this->tf->getText(43) . ' ' . $this->tf->getText(69) . '</label>
<input type="text" id="contact" class="form-control" value="' . $this->contact->getName() . ' | ' . $this->contact->getMail() . ' | ' . $this->contact->getPhone_number() . '">
<input name="id_contact" type="hidden" class="form-control" value="' . $this->id_contact . '">
<button id="getContact" alt="company" rel="' . $this->id . '" class="display btn btn-primary"><span class="glyphicon glyphicon-search" aria-hidden="true"></span></button></a>
<button id="addContact" alt="company" rel="' . $this->id . '" class="display btn btn-primary"><span class="glyphicon glyphicon-plus" aria-hidden="true"></span></button></a>
</div>
<div class="form-group">
<label for="id_billing_address">' . $this->tf->getText(87) . ' ' . $this->tf->getText(69) . '</label>
<input type="text" id="billing_address" class="form-control" value="' . str_replace('<br/>', ' ', $this->billing_address->printAddress()) . '">
<input name="id_billing_address" type="hidden" class="form-control" value="' . $this->id_billing_address . '">
<button id="addAddress" alt="company" step="billing_address" rel="' . $this->id . '" class="display btn btn-primary"><span class="glyphicon glyphicon-plus" aria-hidden="true"></span></button></a>
<button id="setAddress" alt="company" step="billing_address" rel="' . $this->id . '" class="display btn btn-primary"><span class="glyphicon glyphicon-cog" aria-hidden="true"></span></button></a>
<button id="getAddress" alt="company" step="billing_address" rel="' . $this->id . '" class="display btn btn-primary"><span class="glyphicon glyphicon-search" aria-hidden="true"></span></button></a>
</div>
<div class="form-group">
<label for="id_receiving_address">' . $this->tf->getText(88) . ' ' . $this->tf->getText(69) . '</label>
<input type="text" id="receiving_address" class="form-control" value="' . str_replace('<br/>', ' ', $this->receiving_address->printAddress()) . '">
<input name="id_receiving_address" type="hidden" class="form-control" value="' . $this->id_receiving_address . '">
<button id="addAddress" alt="company" step="receiving_address" rel="' . $this->id . '" class="display btn btn-primary"><span class="glyphicon glyphicon-plus" aria-hidden="true"></span></button></a>
<button id="setAddress" alt="company" step="receiving_address" rel="' . $this->id . '" class="display btn btn-primary"><span class="glyphicon glyphicon-cog" aria-hidden="true"></span></button></a>
<button id="getAddress" alt="company" step="receiving_address" rel="' . $this->id . '" class="display btn btn-primary"><span class="glyphicon glyphicon-search" aria-hidden="true"></span></button></a>
</div>
';
echo '
<div class="form-group">
<label for="id_group_company">' . $this->tf->getText(85) . '</label>
<select name="id_group_company" class="form-control">
';
foreach ($groups as $group) {
echo 'hey';
if ($this->id_group_company == $group->getId()) {
echo '<option selected="selected" value="' . $group->getId() . '">' . ucfirst($group->getDesignation()) . '</option>';
} else {
echo '<option value="' . $group->getId() . '">' . ucfirst($group->getDesignation()) . '</option>';
}
}
echo '
</select>
</div>
<div class="form-group">
<label for="ust_id">UST Id</label>
<input name="ust_id" type="text" class="form-control" value="' . $this->ust_id . '">
</div>
<div class="form-group">
<label for="normal_billing_period">' . $this->tf->getText(86) . '</label>
<input name="normal_billing_period" type="text" class="form-control" value="' . $this->normal_billing_period . '">
</div>
';
}
<?php
require_once 'checkSession.php';
require_once '../model/group_company.php';
require_once '../model/extraction.php';
$extraction = new extraction();
$group_companies = $extraction->get("group_company");
include '../view/groupCompanies.php';
<?php
require_once '../model/extraction.php';
require_once '../model/company.php';
$data = $_GET["address"];
$data = json_decode($data, true);
$extraction = new extraction();
$results = $extraction->get('company');
echo '<input id="lookCompany" class="form-control" type="text">';
foreach ($results as $company) {
echo '<div class="ctn-addresses">';
echo '<div class="ctn-address">';
echo '<p>' . $company->printText() . '<p>';
echo '</div>';
echo '<button class=" btn btn-primary sendCompany" rel="' . $data["idFor"] . '" alt="' . $company->getId() . '"class="btn btn-success"><span class="glyphicon glyphicon-ok" aria-hidden="true"></span></button>';
echo '</div>';
}
<?php
require_once '../model/extraction.php';
require_once '../model/customer.php';
$data = $_GET["address"];
$data = json_decode($data, true);
$extraction = new extraction();
$results = $extraction->getCustomersFromCompany($data["idFor"]);
foreach ($results as $customer) {
echo '<div class="ctn-addresses">';
echo '<div class="ctn-address">';
echo '<p>' . $customer->printText() . '<p>';
echo '</div>';
echo '<button class=" btn btn-primary sendContact" rel="' . $data["idFor"] . '" alt="' . $customer->getId() . '"class="btn btn-success"><span class="glyphicon glyphicon-ok" aria-hidden="true"></span></button>';
echo '</div>';
}
<?php
require_once '../model/extraction.php';
require_once '../model/address.php';
$extraction = new extraction();
$data = $_GET["address"];
$data = json_decode($data, true);
if ($data["for"] == "order") {
$results = $extraction->searchForAddress(" ", $data["idFor"]);
} else {
$results = $extraction->searchForAddress(" ");
}
foreach ($results as $address) {
echo '<div class="ctn-addresses">';
echo '<div class="ctn-address">';
echo '<p>' . $address->getLine() . ' ' . $address->getComplement() . '<br/>' . $address->getZip() . ' ' . $address->getCity() . '<br/>' . $address->getState() . ' ' . $address->getCountry();
echo '</div>';
echo '<button class=" btn btn-primary sendAddress" rel="' . $data["idFor"] . '" alt="' . $address->getId() . '"class="btn btn-success"><span class="glyphicon glyphicon-ok" aria-hidden="true"></span></button>';
echo '</div>';
}
<?php require_once 'checkSession.php'; require_once '../model/company.php'; require_once '../model/extraction.php'; $extraction = new extraction(); $companies = $extraction->getCompany(); include '../view/companies.php';
<?php require_once '../model/error.php'; require_once '../model/extraction.php'; require_once 'checkSession.php'; $extraction = new extraction(); $groups = $extraction->getProductByGroup(); include '../view/products.php';
<?php
require_once 'checkSession.php';
require_once '../model/employee.php';
require_once '../model/extraction.php';
if (isset($_GET["dateDeb"]) && $_GET["dateDeb"] != "" && isset($_GET["dateEnd"]) && $_GET["dateEnd"] != "") {
$display = true;
$deb = $_GET["dateDeb"];
$end = $_GET["dateEnd"];
$id_e = $_SESSION["employee"];
$employee = new employee($id_e);
$extraction = new extraction();
$orders = $extraction->getOrdersFromEmployeeWithDate($id_e, $deb, $end);
$ca = 0;
$count = count($orders);
foreach ($orders as $order) {
$ca += $order->getPrice();
}
$ca = number_format($ca, 2, ',', ' ');
//On regroupe les commandes par leur client
$companies = array();
function search($id, $company)
{
$mag = false;
foreach ($company as $i => $item) {
if ($item->getId() == $id) {
$mag = $i;
}
}
return $mag;
}
if (isset($_GET["dateBegin"]) && isset($_GET["dateEnd"])) {
$displayResult = true;
$displayOrderPrice = false;
if (isset($_GET["display-order-price"])) {
$displayOrderPrice = true;
}
$typeOfExtract = $_GET["type-of-extract"];
require "../model/extraction.php";
$dateBegin = $_GET["dateBegin"];
$dateEnd = $_GET["dateEnd"];
if ($typeOfExtract == "ES") {
$extraction = new extraction($dateBegin, $dateEnd, "FA");
$result = $extraction->extract();
$extraction2 = new extraction($dateBegin, $dateEnd, "FA-R");
$result2 = $extraction2->extract();
foreach ($result2 as $order) {
$order->markAsESRectific();
}
$result = array_merge($result, $result2);
function cmp($a, $b)
{
return $a->getDate() < $b->getDate() ? -1 : 1;
}
usort($result, "cmp");
$extraction->addToFinalPrice(-$extraction2->getFinalPrice());
} else {
$extraction = new extraction($dateBegin, $dateEnd, $typeOfExtract);
$result = $extraction->extract();
}
}
include "../view/detailCommande.php";
