public function deleteAction()
 {
     $id = $this->getEvent()->getRouteMatch()->getParam('id');
     if ($this->getRequest()->isXmlHttpRequest()) {
         $aRow = $this->getCreateUpdateTable()->getRow($id);
         if ($aRow) {
             $this->getCreateUpdateTable()->deleteRow($id);
         }
         $xml = Info::setXMLInfo(array('status' => 1, 'error' => 'ok'));
         $this->getResponse()->getHeaders()->addHeaders(array('Content-type' => 'text/xml'));
         return $this->getResponse()->setContent($xml);
     }
 }
Esempio n. 2
0
 public function deleteAction()
 {
     if ($this->getRequest()->isXmlHttpRequest()) {
         $id_slownika = $this->getEvent()->getRouteMatch()->getParam('id_slownika');
         $id = $this->getEvent()->getRouteMatch()->getParam('id');
         $aSlownik = \My\Tools\Lista::ListaWhere('import_slo', 'id', $id_slownika);
         if ($aSlownik) {
             $aWartosci = \My\Tools\Lista::ListaWhere($aSlownik['nazwa'], 'id', $id);
             if ($aWartosci) {
                 $bUpdate = \My\Tools\Lista::Update($aSlownik['nazwa'], array('deleted' => 1), $id);
                 if ($bUpdate) {
                     $danexml = \My\Dhtmlx\Info::setXMLInfo(array('status' => 1, 'error' => ''));
                 } else {
                     $danexml = \My\Dhtmlx\Info::setXMLInfo(array('status' => 0, 'error' => 'Błąd podczas dodania danych do słownika.'));
                 }
             }
         }
         $this->getResponse()->getHeaders()->addHeaders(array('Content-type' => 'text/xml'));
         return $this->getResponse()->setContent($danexml);
     }
 }
    public function addAction()
    {
        if ($this->getRequest()->isXmlHttpRequest()) {
            $sm = $this->getServiceLocator();
            $oFormModel = $sm->get('FormsElementTable');
            $oForm = new \My\Dhtmlx\Form();
            $request = $this->getRequest();
            $id_slownika = $this->getEvent()->getRouteMatch()->getParam('id_slownika');
            $aSlownik = \My\Tools\Lista::ListaWhere('import_slo', 'id', $id_slownika);
            if ($request->isPost()) {
                $oPost = $request->getPost();
                try {
                    $bInsert = \My\Tools\Lista::Insert($aSlownik['nazwa'], $oPost->toArray());
                    if ($bInsert) {
                        $danexml = \My\Dhtmlx\Info::setXMLInfo(array('status' => 1, 'error' => ''));
                    } else {
                        $danexml = \My\Dhtmlx\Info::setXMLInfo(array('status' => 0, 'error' => 'Błąd podczas dodania danych do słownika.'));
                    }
                } catch (Exception $e) {
                    $danexml = \My\Dhtmlx\Info::setXMLInfo(array('status' => 0, 'error' => 'Błąd danych. Błąd ' . $e->getMessage()));
                }
            } else {
                $danexml = '<?xml version="1.0"?><items>';
                $label = "Add";
                $danexml .= '<item type="fieldset"  name="krok1" className="formstyle"  label="' . $label . '" width="500">
					<item type="settings" position="label-left"  labelAlign="right"/>';
                $aKolumny = \My\Tools\Lista::Kolumny($aSlownik['nazwa']);
                $aSlownikListAvailable = explode(',', $aSlownik['column_list']);
                $width_pola = 250;
                $width_label = 150;
                $styl = $oForm->getStyle();
                $aColumnNameSlo = explode(',', $aSlownik['column_mapping_list']);
                $i = 0;
                foreach ($aKolumny as $sKey => $column) {
                    $sKolumna = $sKey;
                    if ($sKolumna != 'id' && in_array($column->getName(), $aSlownikListAvailable)) {
                        $danexml .= '<item type="input" required="1" name="' . $column->getName() . '" value="" label="' . $aColumnNameSlo[$i] . ':" inputWidth="' . $width_pola . '" labelWidth="' . $width_label . '" tolltip="tre" style="' . $styl . '">';
                        $danexml .= '<note>' . $column->getDataType() . ' ' . $column->getCharacterMaximumLength() . '</note>';
                        $danexml .= '</item>';
                        $i++;
                    }
                }
                $danexml .= '</item>';
                $danexml .= '<item type="button"  name="save" offsetLeft="350" width="150" value="Save"/>';
                $danexml .= '</items>';
            }
            $this->getResponse()->getHeaders()->addHeaders(array('Content-type' => 'text/xml'));
            return $this->getResponse()->setContent($danexml);
        }
    }
 public function calculeslabAction()
 {
     $fOneMeterToInch = 39.37;
     $fMeterToInch = 10.76;
     if ($this->getRequest()->isXmlHttpRequest()) {
         $lenghtInch = $this->getEvent()->getRouteMatch()->getParam('lenght');
         $widthInch = $this->getEvent()->getRouteMatch()->getParam('width');
         $fSqftPrice = $this->getEvent()->getRouteMatch()->getParam('sqft_price');
         //post przelicza metry z forma calcule
         $lenghtMeter = number_format($lenghtInch / $fOneMeterToInch, 2);
         $widthMeter = number_format($widthInch / $fOneMeterToInch, 2);
         $fSlabPrice = round($fSqftPrice * $fMeterToInch * ($lenghtMeter * $widthMeter), 2);
         $xml = Info::setXMLInfo(array('status' => 1, 'length' => $lenghtInch, 'width' => $widthInch, 'sqft_price' => $fSqftPrice, 'slab_price' => $fSlabPrice));
         $this->getResponse()->getHeaders()->addHeaders(array('Content-type' => 'text/xml'));
         return $this->getResponse()->setContent($xml);
     }
 }