<h2>File Contents: /home/planet5/public_html/4xpips.net/secure/application/cc/controllers/AdminRebillsController.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/public_html/4xpips.net/secure/application/cc/controllers/AdminRebillsController.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php

class Cc_AdminRebillsController extends Am_Controller_Grid
{
    public function checkAdminPermissions(Admin $admin)
    {
        return $admin-&gt;hasPermission(&#039;cc&#039;);
    }
    public function emptyZero($v)
    {
        return $v ? $v : &#039;&#039;;
    }
    protected function createAdapter()
    {
        $q = new Am_Query(new CcRebillTable);
        $q-&gt;clearFields();
        $q-&gt;groupBy(&#039;rebill_date&#039;);
        $q-&gt;addField(&#039;rebill_date&#039;);
        $q-&gt;addField(&#039;COUNT(t.rebill_date)&#039;, &#039;total&#039;);
        $q-&gt;addField(&#039;SUM(IF(t.status=0, 1, 0))&#039;, &#039;status_0&#039;);
        $q-&gt;addField(&#039;SUM(IF(t.status=1, 1, 0))&#039;, &#039;status_1&#039;);
        $q-&gt;addField(&#039;SUM(IF(t.status=2, 1, 0))&#039;, &#039;status_2&#039;);
        $q-&gt;addField(&#039;SUM(IF(t.status=3, 1, 0))&#039;, &#039;status_3&#039;);
        $q-&gt;addField(&#039;SUM(IF(t.status=4, 1, 0))&#039;, &#039;status_4&#039;);
        $u = new Am_Query(new InvoiceTable, &#039;i&#039;);
        $u-&gt;groupBy(&#039;rebill_date&#039;);
        $u-&gt;clearFields()-&gt;addField(&#039;i.rebill_date&#039;);
        for ($i=0;$i&lt;6;$i++)
            $u-&gt;addField(&#039;(NULL)&#039;);
        $u-&gt;leftJoin(&#039;?_cc_rebill&#039;, &#039;t&#039;, &#039;t.rebill_date=i.rebill_date&#039;);
        $u-&gt;addWhere(&#039;i.rebill_date IS NOT NULL&#039;);
        $u-&gt;addWhere(&#039;t.rebill_date IS NULL&#039;);
        $q-&gt;addUnion($u);
        $q-&gt;addOrder(&#039;rebill_date&#039;,true);
        return $q;
    }
    public function createGrid()
    {
        $grid = new Am_Grid_ReadOnly(&#039;_r&#039;, &#039;Rebills by Date&#039;, $this-&gt;createAdapter(), $this-&gt;_request, $this-&gt;view);
        $grid-&gt;setPermissionId(&#039;cc&#039;);
        $grid-&gt;addField(&#039;rebill_date&#039;, &#039;Date&#039;, true)-&gt;setRenderFunction(array($this, &#039;renderDate&#039;));
        $grid-&gt;addField(&#039;status_0&#039;, &#039;Processing Not Finished&#039;, true)-&gt;setFormatFunction(array($this, &#039;emptyZero&#039;));
        $grid-&gt;addField(&#039;status_1&#039;, &#039;No CC Saved&#039;, true)-&gt;setFormatFunction(array($this, &#039;emptyZero&#039;));
        $grid-&gt;addField(&#039;status_2&#039;, &#039;Error&#039;, true)-&gt;setFormatFunction(array($this, &#039;emptyZero&#039;));
        $grid-&gt;addField(&#039;status_3&#039;, &#039;Success&#039;, true)-&gt;setFormatFunction(array($this, &#039;emptyZero&#039;));
        $grid-&gt;addField(&#039;status_4&#039;, &#039;Exception!&#039;, true)-&gt;setFormatFunction(array($this, &#039;emptyZero&#039;));
        $grid-&gt;addField(&#039;total&#039;, &#039;Total Records&#039;, true)-&gt;setFormatFunction(array($this, &#039;emptyZero&#039;));
        $grid-&gt;addField(&#039;_action&#039;, &#039;&#039;, true)-&gt;setRenderFunction(array($this, &#039;renderLink&#039;));
        return $grid;
    }
    public function renderDate(CcRebill $obj)
    {
        $raw = $obj-&gt;rebill_date;
        $d = amDate($raw);
        return $this-&gt;renderTd(&quot;$d&lt;input type=&#039;hidden&#039; name=&#039;raw-date&#039; value=&#039;$raw&#039; /&gt;&quot;, false);
    }
    public function renderLink(CcRebill $obj)
    {
        return $this-&gt;renderTd(&quot;&lt;a href=&#039;javascript:&#039; class=&#039;run&#039; id=&#039;run-{$obj-&gt;rebill_date}&#039;&gt;run&lt;/a&gt;&quot;, false);
    }
    public function getInvoiceLink(CcRebill $record)
    {
        return $this-&gt;renderTd($record-&gt;invoice_id, false);
    }
    public function init()
    {
        parent::init();
        
        $this-&gt;view-&gt;headScript()-&gt;appendScript($this-&gt;getJs());
        $this-&gt;view-&gt;placeholder(&#039;after-content&#039;)-&gt;append(
            &quot;&lt;br /&gt;&lt;br /&gt;&quot; .
            &quot;&lt;div id=&#039;detail&#039;&gt;&lt;/div&gt;&quot; .
            &quot;&lt;div id=&#039;run-form&#039; style=&#039;display:none&#039;&gt;&quot; . (string)$this-&gt;createRunForm() . &quot;&lt;/div&gt;&quot;);
    }
    
    public function getJs()
    {
        return &lt;&lt;&lt;CUT
    function bindClicks(){
        $(&quot;#grid-r a.run&quot;).bind(&#039;click&#039;, function(event){
            event.stopPropagation();
            var date = $(this).attr(&quot;id&quot;).replace(/^run-/, &#039;&#039;);
            $(&quot;#detail&quot;).load(window.rootUrl + &quot;/cc/admin-rebills/run&quot;, { date : date});
        });
        $(&quot;#grid-r tr&quot;).bind(&#039;click&#039;, function(event){
            var date = $(&quot;input[name=&#039;raw-date&#039;]&quot;, this).val();
            if (!date) return; // header ?
            $(&quot;tr.selected&quot;).removeClass(&quot;selected&quot;);
            $(this).addClass(&quot;selected&quot;);
            $(&quot;#detail&quot;).load(window.rootUrl + &quot;/cc/admin-rebills/detail&quot;, { date : date}, function(){
                $(&quot;.grid-wrap&quot;).ngrid();
            });
        });
    };
    $(document).ready(function(){bindClicks();});
    $(document).ajaxStop(function(){bindClicks();});
$(function(){
    $(&quot;#detail form&quot;).live(&#039;submit&#039;, function(){
        $(this).ajaxSubmit({target: &#039;#detail&#039;});
        return false;
    });
});
CUT;
    }
    public function renderRun()
    {
        return (string)$form;
    }
    public function createRunForm()
    {
        $form = new Am_Form;
        $form-&gt;setAction($this-&gt;getUrl(null, &#039;run&#039;));
        
        $s = $form-&gt;addSelect(&#039;paysys_id&#039;)-&gt;setLabel(&#039;Choose a plugin&#039;);
        $s-&gt;addRule(&#039;required&#039;, &#039;This field is required&#039;);
        foreach ($this-&gt;getModule()-&gt;getPlugins() as $p)
            $s-&gt;addOption($p-&gt;getTitle(), $p-&gt;getId());
        $form-&gt;addDate(&#039;date&#039;)-&gt;setLabel(&#039;Run Rebill Manually&#039;)-&gt;addRule(&#039;required&#039;, &#039;This field is required&#039;);
        $form-&gt;addSubmit(&#039;run&#039;, array(&#039;value&#039;=&gt;&#039;Run&#039;));
        $form-&gt;setWidth(&#039;450px&#039;);
        return $form;
    }
    public function detailAction()
    {
        $date = $this-&gt;getFiltered(&#039;date&#039;);
        if (!$date) throw new Am_Exception_InputError(&quot;Wrong date&quot;);
        $grid = $this-&gt;createDetailGrid($date);
        $grid-&gt;isAjax(false);
        $grid-&gt;runWithLayout(&#039;admin/layout.phtml&#039;);
    }
    protected function createDetailGrid($date)
    {
    //    public $textNoRecordsFound = &quot;No rebills today - most possible cron job was not running.&quot;;
        $q = new Am_Query($this-&gt;getDi()-&gt;ccRebillTable);
        $q-&gt;addWhere(&#039;rebill_date=?&#039;, $date);
        
        $grid = new Am_Grid_ReadOnly(&#039;_dd&#039;, &quot;Detailed Rebill Report For [$date]&quot;, $q, $this-&gt;_request, $this-&gt;view);
        $grid-&gt;setPermissionId(&#039;cc&#039;);
        $grid-&gt;addField(new Am_Grid_Field_Date(&#039;tm_added&#039;, &#039;Started&#039;, true));
        $grid-&gt;addField(&#039;invoice_id&#039;, &#039;Invoice#&#039;, true);
        $grid-&gt;addField(new Am_Grid_Field_Date(&#039;rebill_date&#039;, &#039;Date&#039;, true))-&gt;setFormatDate();
        $grid-&gt;addField(&#039;status&#039;, &#039;Status&#039;, true)-&gt;setFormatFunction(array(&#039;CcRebill&#039;, &#039;getStatusText&#039;));
        $grid-&gt;addField(&#039;status_msg&#039;, &#039;Message&#039;);
        return $grid;
    }
    public function runAction()
    {
        $date = $this-&gt;getFiltered(&#039;date&#039;);
        if (!$date) throw new Am_Exception_InputError(&quot;Wrong date&quot;);
        
        $form = $this-&gt;createRunForm();
        if ($form-&gt;isSubmitted() &amp;&amp; $form-&gt;validate())
        {
            $value = $form-&gt;getValue();
            return $this-&gt;doRun($value[&#039;paysys_id&#039;], $value[&#039;date&#039;]);
        } else {
            echo $form;
        }
    }
    public function doRun($paysys_id, $date)
    {
        $this-&gt;getDi()-&gt;plugins_payment-&gt;load($paysys_id);
        $p = $this-&gt;getDi()-&gt;plugins_payment-&gt;get($paysys_id);
        $p-&gt;ccRebill($date);
        echo &quot;Done for $date&quot;;
    }
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fpublic_html%2F4xpips.net%2Fsecure%2Fapplication%2Fcc%2Fcontrollers'>⬅ Back to Directory</a>