Example #1
0
 function __construct($_idClient, $firm)
 {
     $this->idClient = null;
     if (is_numeric($_idClient)) {
         $this->idClient = $_idClient;
     }
     if (!is_null($this->idClient)) {
         $this->pdo = Database::connect($firm);
         $sqlC = $this->pdo->prepare('SELECT * FROM ������� WHERE ����������= :idK');
         $sqlC->bindParam(':idK', $this->idClient, PDO::PARAM_INT);
         $sqlC->execute();
         if ($sqlC->rowCount()) {
             $rowC = $sqlC->fetch();
             if (!is_null($rowC)) {
                 $this->companyName = $rowC['����������������'];
                 $this->nameClient = $rowC['�����������'];
                 $this->famClient = $rowC['���������������'];
                 $this->address = $rowC['���������������������'];
                 $this->city = $rowC['�����'];
                 $this->postIndex = $rowC['��������������'];
                 $this->land = $rowC['������'];
                 $this->position = $rowC['�������������������'];
                 $this->tel = $rowC['�������������'];
                 $this->fax = $rowC['����'];
                 $this->unn = $rowC['UNN'];
                 $this->lProblem = $rowC['LProblem'];
                 $this->sex = $rowC['Sex'];
                 $this->bankRekv = $rowC['BankRekv'];
                 $this->lSel = $rowC['LSel'];
                 $this->email = $rowC['Email'];
             }
         }
     }
 }
Example #2
0
 function __construct($_idOrder, $firm)
 {
     $this->idOrder = $_idOrder;
     $this->pdo = Database::connect($firm);
     $sql = $this->pdo->prepare(iconv("UTF-8", "WINDOWS-1251", 'SELECT * FROM "Заказы на ремонт" WHERE КодЗаказа = :id'));
     $sql->bindParam(':id', $this->idOrder, PDO::PARAM_INT);
     $sql->execute();
     if ($sql->rowCount()) {
         $rowO = $sql->fetch();
         $this->client = new Clients($rowO[iconv("UTF-8", "WINDOWS-1251", 'КодКлиента')], $firm);
     }
 }
Example #3
0
$pdo = null;
if (isset($_POST['date'])) {
    $curDate_array = getdate(strtotime($_POST['date']));
    $curDateBegin = '#' . $curDate_array['year'] . '/' . $curDate_array['mday'] . '/' . $curDate_array['mon'] . ' 0:0:0' . '#';
    $curDateEnd = '#' . $curDate_array['year'] . '/' . $curDate_array['mday'] . '/' . $curDate_array['mon'] . ' 23:59:59' . '#';
}
if (isset($_POST['firm'])) {
    $curFirm = $_POST['firm'];
}
switch ($curFirm) {
    case '10':
        $pdo = Database::connect('BTS');
        $curFirmStr = 'BTS';
        break;
    case '11':
        $pdo = Database::connect('LETTA');
        $curFirmStr = 'LETTA';
        break;
}
if (isset($_POST['action'])) {
    switch ($_POST['action']) {
        case 'refreshP':
            $sql = iconv("UTF-8", "WINDOWS-1251", 'SELECT TOP 10 * FROM "Заказы на ремонт" WHERE ([ДатаП]>=' . $curDateBegin . ' AND [ДатаП]<=' . $curDateEnd . ') ORDER BY НомерЗаказа DESC');
            $tableBody = '';
            foreach ($pdo->query($sql) as $row) {
                $order = new Orders($row[iconv("UTF-8", "WINDOWS-1251", 'КодЗаказа')], $curFirmStr);
                $tableBody .= '<tr>';
                $tableBody .= '<td>' . $order->getTypeOrder() . '</td>';
                $tableBody .= '<td>' . $order->getLeaveOrder() . '</td>';
                $tableBody .= '<td>' . $row[iconv("UTF-8", "WINDOWS-1251", 'НомерЗаказа')] . '</td>';
                $tableBody .= '<td>' . $order->getStatusOrder() . '</td>';