PHP LbEmployeePayment::search Examples

Example #1

File: form_list_payment.php Project: heartshare/linxbooks

        </div>
    </div>

<?php 
$date_now = date('Y-m-d');
$month_default = date('m', strtotime($date_now));
$year_default = date('Y', strtotime($date_now));
echo '<div align="right">   
    <button style="margin-right:580px;" class="ui-button ui-state-default ui-corner-all" target="_blank" onclick="printPDF_payment(); return false;">Print PDF</button>
    <span><b>Paid For Month:</b></span>
    <input type="text" id="paidForDate" class="text" value="' . date('m-Y') . '"/>
    </div>';
$create_by = AccountProfile::model()->getFullName(Yii::app()->user->id);
//echo date('d', strtotime('12-08-3012'));
echo '<div id="show_payment">';
$this->Widget('bootstrap.widgets.TbGridView', array('id' => 'lb_expenses_gridview', 'dataProvider' => $model->search(false, $month_default, $year_default), 'type' => 'striped bordered condensed', 'columns' => array(array('class' => 'bootstrap.widgets.TbButtonColumn', 'template' => '{delete}', 'htmlOptions' => array('width' => '10'), 'deleteButtonUrl' => '"' . LbEmployee::model()->getActionURLNormalized("ajaxDeletePayment") . '" .
                                                "?id={$data->lb_record_primary_key}"', 'afterDelete' => 'function(link,success,data){ ' . 'if(data){ responseJSON = jQuery.parseJSON(data);' . '     alert(responseJSON.error); }' . '}'), array('header' => Yii::t('lang', 'Paid For Month'), 'type' => 'raw', 'value' => '$data->payment_month."/".$data->payment_year', 'htmlOptions' => array('width' => '90')), array('header' => Yii::t('lang', 'Date'), 'type' => 'raw', 'value' => 'date("d-m-Y", strtotime($data->payment_date))', 'htmlOptions' => array('width' => '90')), array('header' => Yii::t('lang', 'Name'), 'type' => 'raw', 'value' => ' LbEmployee::model()->getInfoEmployee($data->employee_id)["employee_name"];', 'htmlOptions' => array('width' => '130')), array('header' => Yii::t('lang', 'Total Salary($)'), 'type' => 'raw', 'value' => 'number_format(LbEmployeeSalary::model()->totalSalaryEmployee($data->employee_id)-LbEmployeeBenefits::model()->caculatorBenefitByEmployee($data->employee_id),2)', 'htmlOptions' => array('width' => '80', 'style' => 'text-align:right;')), array('header' => Yii::t('lang', 'Paid($)'), 'type' => 'raw', 'value' => 'number_format(LbEmployeePayment::model()->totalPaidByDate($data->payment_month,$data->employee_id,$data->payment_year,$data->payment_date),2);', 'htmlOptions' => array('width' => '80', 'style' => 'text-align:right;')), array('header' => Yii::t('lang', 'Balance($)'), 'type' => 'raw', 'value' => 'number_format(LbEmployeeSalary::model()->totalSalaryEmployee($data->employee_id)-LbEmployeeBenefits::model()->caculatorBenefitByEmployee($data->employee_id)-LbEmployeePayment::model()->totalPaidByDate($data->payment_month,$data->employee_id,$data->payment_year,$data->payment_date),2)', 'htmlOptions' => array('width' => '80', 'style' => 'text-align:right;')), array('header' => Yii::t('lang', 'New Payment($)'), 'type' => 'raw', 'value' => 'LbEmployeePayment::model()->getEmployeePayment(false,$data->lb_record_primary_key)["payment_paid"];', 'htmlOptions' => array('width' => '80', 'style' => 'text-align:right;')), array('header' => Yii::t('lang', 'Note'), 'type' => 'raw', 'value' => 'LbEmployeePayment::model()->getEmployeePayment(false,$data->lb_record_primary_key)["payment_note"];', 'htmlOptions' => array('width' => '130')))));
echo '</div><br/>';
?>
    
</div>
<script lang="javascript">
    $(function () {
            $('#paidForDate').datepicker({
               
                format: 'mm-yyyy',
                viewMode:'months',
                minViewMode:'years',
                onClose: function (dateText, inst) {

                    //Get the selected month value

Example #2

File: form_list_payment.php Project: nhuhtlb/linxbooks

        </div>
    </div>

<?php 
$date_now = date('Y-m-d');
$month_default = date('m', strtotime($date_now));
$year_default = date('Y', strtotime($date_now));
echo '<div align="right">   
  
    <span><b>Paid For Month:</b></span>
    <input type="text" id="paidForDate" class="text" value="' . date('m-Y') . '"/>
    </div>';
$create_by = AccountProfile::model()->getFullName(Yii::app()->user->id);
//echo date('d', strtotime('12-08-3012'));
echo '<div id="show_payment">';
$this->Widget('bootstrap.widgets.TbGridView', array('id' => 'lb_expenses_gridview', 'dataProvider' => $model->search(false, $month_default, $year_default), 'template' => "{items}\n{pager}\n{summary}", 'columns' => array(array('class' => 'bootstrap.widgets.TbButtonColumn', 'template' => '{delete}', 'htmlOptions' => array('width' => '10', 'height' => '40px'), 'deleteButtonUrl' => '"' . LbEmployee::model()->getActionURLNormalized("ajaxDeletePayment") . '" .
                                                "?id={$data->lb_record_primary_key}"', 'afterDelete' => 'function(link,success,data){ ' . 'if(data){ responseJSON = jQuery.parseJSON(data);' . '     alert(responseJSON.error); }' . '}'), array('header' => Yii::t('lang', 'Paid For Month'), 'type' => 'raw', 'value' => '$data->payment_month."/".$data->payment_year', 'htmlOptions' => array('width' => '90', 'height' => '40px')), array('header' => Yii::t('lang', 'Date'), 'type' => 'raw', 'value' => 'date("d-m-Y", strtotime($data->payment_date))', 'htmlOptions' => array('width' => '90', 'height' => '40px')), array('header' => Yii::t('lang', 'Name'), 'type' => 'raw', 'value' => ' LbEmployee::model()->getInfoEmployee($data->employee_id)["employee_name"];', 'htmlOptions' => array('width' => '130', 'height' => '40px')), array('header' => Yii::t('lang', 'Total Salary($)'), 'type' => 'raw', 'value' => 'number_format(LbEmployeeSalary::model()->totalSalaryEmployee($data->employee_id)-LbEmployeeBenefits::model()->caculatorBenefitByEmployee($data->employee_id),2)', 'htmlOptions' => array('width' => '80', 'height' => '40px', 'style' => 'text-align:right;')), array('header' => Yii::t('lang', 'Paid($)'), 'type' => 'raw', 'value' => 'number_format(LbEmployeePayment::model()->totalPaidByDate($data->payment_month,$data->employee_id,$data->payment_year,$data->payment_date),2);', 'htmlOptions' => array('width' => '80', 'height' => '40px', 'style' => 'text-align:right;')), array('header' => Yii::t('lang', 'Balance($)'), 'type' => 'raw', 'value' => 'number_format(LbEmployeeSalary::model()->totalSalaryEmployee($data->employee_id)-LbEmployeeBenefits::model()->caculatorBenefitByEmployee($data->employee_id)-LbEmployeePayment::model()->totalPaidByDate($data->payment_month,$data->employee_id,$data->payment_year,$data->payment_date),2)', 'htmlOptions' => array('width' => '80', 'height' => '40px', 'style' => 'text-align:right;')), array('header' => Yii::t('lang', 'New Payment($)'), 'type' => 'raw', 'value' => 'LbEmployeePayment::model()->getEmployeePayment(false,$data->lb_record_primary_key)["payment_paid"];', 'htmlOptions' => array('width' => '80', 'height' => '40px', 'style' => 'text-align:right;')), array('header' => Yii::t('lang', 'Note'), 'type' => 'raw', 'value' => 'LbEmployeePayment::model()->getEmployeePayment(false,$data->lb_record_primary_key)["payment_note"];', 'htmlOptions' => array('width' => '130', 'height' => '40px')))));
echo '</div><br/>';
?>
    
</div>
<script lang="javascript">
    $(function () {
            $('#paidForDate').datepicker({
               
                format: 'mm-yyyy',
                viewMode:'months',
                minViewMode:'years',
                onClose: function (dateText, inst) {

                    //Get the selected month value