Разработка компонента обработки файла XML - страница 9 - Разработка расширений для Joomla 3.x

  protected function getListQuery()
  {
    $ulogin = JFactory::getUser()->username;
    $loan = JFactory::getApplication()->input->getString('loan', '');
    $dtfrom = JFactory::getApplication()->input->getString('dtfrom');
    $dtto = JFactory::getApplication()->input->getString('dtto');
    $dtmin = substr($dtfrom,6,4).'-'.substr($dtfrom,3,2).'-'.substr($dtfrom,0,2);
    $dtmax = substr($dtto,6,4).'-'.substr($dtto,3,2).'-'.substr($dtto,0,2);
    print_r('1:'.$dtmin.'<br />2:'.$dtmax.'<br />');
    //print_r($_REQUEST); 

    $db = JFactory::getDBO();
    
    if (!$dtmin or !$dtmax) {
      $query = 'select min(odate), max(odate) from #__mfo_docums where (client = '.$db->quote($ulogin).') and (loan = '.$db->quote($loan).')';
      $item = $db->setQuery($query)->loadRow();
      $dtmin = $item[0];
      $dtmax = $item[1];
    }

    $query = $db->getQuery(true);
    $query->select('odate, docname, adebet, acredit, pdebet, pcredit, cdebet, ccredit, sdebet, scredit');
    $query->from('#__mfo_docums');
    $query->where('client = '.$db->quote($ulogin));
    $query->where('loan = '.$db->quote($loan));
    $query->where('odate >= '.$db->quote($dtmin));
    $query->where('odate <= '.$db->quote($dtmax));
    $query->order('odate, id');
    return $query;
  }

<?php
$loan = JFactory::getApplication()->input->getString('loan', '');
$list = JFactory::getApplication()->input->getString('list', '0');

$db =JFactory::getDBO();
$query = 'select min(odate), max(odate) from #__mfo_docums where (client = '.$db->quote($ulogin).') and (loan = '.$db->quote($loan).')';
$item_minmax = $db->setQuery($query)->loadRow();
$dtmin = $item_minmax[0];
$dtmax = $item_minmax[1];
?>

<script type="text/javascript">
  UpdateFilter = function()
  {
    var form = document.getElementById('adminForm');
    form.dtmin.value = form.dtfrom.value;
    form.dtmax.value = form.dtto.value;
    form.submit();
  };
</script>

  <form action="<?php echo JRoute::_('index.php'/*?option=com_mfo&view=documc&loan='.$loan.'&list='.$list*/); ?>" method="get" name="adminForm" id="adminForm" class="form-horizontal">
    <div>
      <input type="hidden" name="option" value="com_mfo" />
      <input type="hidden" name="view" value="documc" />
      <input type="hidden" name="loan" value="<?php echo $loan; ?>" />
      <input type="hidden" name="list" value="<?php echo $list; ?>" />
      <input type="hidden" name="dtmin" value="" />
      <input type="hidden" name="dtmax" value="" />
      <?php echo JHtml::_('form.token'); ?>
    </div>

    <div class="control-group">
      <div class="controls">
        <script>jQuery(function(){
          jQuery("#dtfrom").datepicker({dateFormat:"dd.mm.yy",changeMonth:true,changeYear:true,showButtonPanel:true,minDate:"<?php echo JHtml::_('date', $dtmin, 'd.m.Y'); ?>",maxDate:"<?php echo JHtml::_('date', $dtmax, 'd.m.Y'); ?>"});
          jQuery("#dtfrom").datepicker(jQuery.datepicker.regional["ru"]);
          if (jQuery("#dtmin").value == "") 
            {jQuery("#dtmin").value = "<?php echo JHtml::_('date', $dtmin, 'd.m.Y'); ?>";}
          jQuery("#dtfrom").datepicker("setDate",jQuery("#dtmin").value);
          jQuery("#dtto").datepicker({dateFormat:"dd.mm.yy",changeMonth:true,changeYear:true,showButtonPanel:true,minDate:"<?php echo JHtml::_('date', $dtmin, 'd.m.Y'); ?>",maxDate:"<?php echo JHtml::_('date', $dtmax, 'd.m.Y'); ?>"});
          jQuery("#dtto").datepicker(jQuery.datepicker.regional["ru"]);
          if (jQuery("#dtmax").value == "") 
            {jQuery("#dtmax").value = "<?php echo JHtml::_('date', $dtmax, 'd.m.Y'); ?>";}
          jQuery("#dtto").datepicker("setDate",jQuery("#dtmax").value);
        });</script>
        <div class="dt-filter">
          <span><?php echo JText::_('COM_MFO_FILTER_DT_1'); ?></span><input type="text" class="datepicker" name="dtfrom" id="dtfrom" readonly>
          <span><?php echo JText::_('COM_MFO_FILTER_DT_2'); ?></span><input type="text" class="datepicker" name="dtto" id="dtto" readonly>
          <span> <a href="javascript:UpdateFilter()">Применить фильтр</a></span>
        </div>
      </div>
    </div>
  </form>

<input type="hidden" name="dtmin" value="" />
     <input type="hidden" name="dtmax" value="" />

      <input type="hidden" name="dtmin" id="dtmin" value="" />
      <input type="hidden" name="dtmax" id="dtmax" value="" />

  UpdateFilter = function()
  {
    var form = document.getElementById('adminForm');
    jQuery('#loading').css('display', 'block');
    form.dtmin.value = form.dtfrom.value;
    form.dtmax.value = form.dtto.value;
    form.submit();
  };

    <div class="control-group">
      <div class="controls">
        <script>jQuery(function(){
          var form = document.getElementById('adminForm');
          jQuery("#dtfrom").datepicker({dateFormat:"dd.mm.yy",changeMonth:true,changeYear:true,showButtonPanel:true,minDate:"<?php echo JHtml::_('date', $dtmin, 'd.m.Y'); ?>",maxDate:"<?php echo JHtml::_('date', $dtmax, 'd.m.Y'); ?>"});
          jQuery("#dtfrom").datepicker(jQuery.datepicker.regional["ru"]);
          if (form.dtmin.value == "") 
            {form.dtmin.value = "<?php echo JHtml::_('date', $dtmin, 'd.m.Y'); ?>";}     // здесь 28.03.2013, записывается при первоначальном открытии вьюхи
          jQuery("#dtfrom").datepicker("setDate",form.dtmin.value);                          // при сабмите должно записаться 01.06.2013, но остается 28.03.2013
          jQuery("#dtto").datepicker({dateFormat:"dd.mm.yy",changeMonth:true,changeYear:true,showButtonPanel:true,minDate:"<?php echo JHtml::_('date', $dtmin, 'd.m.Y'); ?>",maxDate:"<?php echo JHtml::_('date', $dtmax, 'd.m.Y'); ?>"});
          jQuery("#dtto").datepicker(jQuery.datepicker.regional["ru"]);
          if (form.dtmax.value == "") 
            {form.dtmax.value = "<?php echo JHtml::_('date', $dtmax, 'd.m.Y'); ?>";} // здесь 31.10.2013, записывается при первоначальном открытии вьюхи
          jQuery("#dtto").datepicker("setDate",form.dtmax.value);                          // при сабмите должно записаться 01.10.2013, но остается 31.10.2013
        });</script>
        <div class="dt-filter">
          <span><?php echo JText::_('COM_MFO_FILTER_DT_1'); ?></span><input type="text" class="datepicker" name="dtfrom" id="dtfrom" readonly>
          <span><?php echo JText::_('COM_MFO_FILTER_DT_2'); ?></span><input type="text" class="datepicker" name="dtto" id="dtto" readonly>
          <span><a href="javascript:UpdateFilter()"> Применить фильтр </a></span>
        </div>
      </div>
    </div>

  UpdateFilter = function()
  {
    jQuery('#loading').css('display', 'block');
    var form = document.getElementById('adminForm');
    form.submit();
  };

  ClearFilter = function()
  {
    jQuery('#loading').css('display', 'block');
    var form = document.getElementById('adminForm');
    form.dtfrom.value = "<?php echo $dtmin; ?>";
    form.dtto.value = "<?php echo $dtmax; ?>";
    form.submit();
  };

      <input type="hidden" name="dtmin" id="dtmin" value="<?php echo $dtfrom; ?>" />
      <input type="hidden" name="dtmax" id="dtmax" value="<?php echo $dtto; ?>" />

      <input type="hidden" name="dtmin" id="dtmin" value="<?php echo $dtfrom; ?>" />
      <input type="hidden" name="dtmax" id="dtmax" value="<?php echo $dtto; ?>" />

        <script>jQuery(function(){
          var form = document.getElementById('adminForm');
          jQuery("#dtfrom").datepicker({dateFormat:"dd.mm.yy",changeMonth:true,changeYear:true,showButtonPanel:true,minDate:"<?php echo JHtml::_('date', $dtmin, 'd.m.Y'); ?>",maxDate:"<?php echo JHtml::_('date', $dtmax, 'd.m.Y'); ?>"});
          jQuery("#dtfrom").datepicker(jQuery.datepicker.regional["ru"]);
          jQuery("#dtto").datepicker({dateFormat:"dd.mm.yy",changeMonth:true,changeYear:true,showButtonPanel:true,minDate:"<?php echo JHtml::_('date', $dtmin, 'd.m.Y'); ?>",maxDate:"<?php echo JHtml::_('date', $dtmax, 'd.m.Y'); ?>"});
          jQuery("#dtto").datepicker(jQuery.datepicker.regional["ru"]);
          <?php
            if ($dtfrom == '')
              {echo 'jQuery("#dtfrom").datepicker("setDate","'.$dtmin.'");';} else
              {echo 'jQuery("#dtfrom").datepicker("setDate","'.$dtfrom.'");';}
            if ($dtto == '')
              {echo 'jQuery("#dtto").datepicker("setDate","'.$dtmax.'");';} else
              {echo 'jQuery("#dtto").datepicker("setDate","'.$dtto.'");';}
          ?>
        });</script>

    $query->where('(client = '.$db->quote($ulogin).')');
    $query->where('(loan = '.$db->quote($loan).')');
    $query->where('(odate between '.$db->quote($dtmin).' and '.$db->quote($dtmax).')');

$doc = JFactory::getDocument();
$jsByAlekVolsk = '
  jQuery(function($) {
    UpdateFilter = function() {
      $("#loading").css("display", "block");
      $("#adminForm").submit();
    };
    ClearFilter = function() {
      $("#loading").css("display", "block");
      $("#dtfrom").val( " '. $dtmin .' " );
      $("#dtto").val( " '. $dtmax .' " );
      $("#adminForm").submit();
    };
  });
';
$doc->addScriptDeclaration ($jsByAlekVolsk);