Menus

Monday, 11 December 2017

Yii2 CheckBox


Yii2 - Display checkbox for boolean database field on active form


<?= $form->field($model, 'mon')->checkBox(['selected' => $model->mon])?>

Change Label


<?= $form->field($model, 'mon')->checkBox(['label'=> 'Monday',  'selected' => $model->mon])?>

Sunday, 10 December 2017

MySql Boolean Data type field create


MySql BOOLEAN or TINYINT


MySQL provides BOOLEAN or BOOL as the synonym of TINYINT(1).

Example 1
Create job table  with boolean data type.


After save job table structure.


Example 2

CREATE TABLE tasks (
    id INT PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(255) NOT NULL,
    completed BOOLEAN
)


Thursday, 7 December 2017

Javascript Tutorials


Convert DD-MM-YYYY to YYYY-MM-DD format using Javascript



var date = "03-11-2014"; 
var newdate = date.split("-").reverse().join("-");



Javascript add number of days to today's date?



   var dd = 07-12-2017
   var x = 30; //days for add 

   var newdate = dd.split("-").reverse().join("-");   //date convert yyyy-mm-dd
   var someDate = new Date(newdate);
   someDate.setDate(someDate.getDate() + x); //number  of days to add, e.x. x days
   var dateFormated = someDate.toISOString().substr(0,10);     
          
   var vdate = dateFormated.split("-").reverse().join("-");   //date convert to dd-mm-yyyy  
 
 




Sunday, 26 November 2017

VB.NET DataGridView Tutorials





Adding checkbox column to DataGridView


  Dim AddColumn As New DataGridViewCheckBoxColumn

  With AddColumn
    .HeaderText = "ColumnName"
    .Name = "Column Name that will be displayed"
    .Width = 80
  End With

  dgAdmin.Columns.Insert(1, AddColumn)


datagridview column header checkbox


Public Class search


Private col As DataGridViewCheckBoxColumn

Private chkBox As CheckBox


Private Sub search_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load



col = New DataGridViewCheckBoxColumn()
col.Name = "select"
col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter
dgcourse.Columns.Insert(0, col)

chkBox = New CheckBox()
Dim rect As Rectangle = dgcourse.GetCellDisplayRectangle(0, -1, True)
chkBox.Size = New Size(18, 18)
chkBox.Location = rect.Location
AddHandler chkBox.CheckedChanged, AddressOf chkBox_CheckedChanged

dgcourse.Controls.Add(chkBox)



End Sub


Private Sub chkBox_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)
'checkbox value change 
For i As Integer = 0 To dgcourse.Rows.Count - 1
dgcourse(0, i).Value = chkBox.Checked
Next


End Sub



End Class



DataGridView - how to hide the “new” row?



Click on datagridview and change properties AllowUserToAddRows set as false.


Programmatically,
myGrid.AllowUserToAddRows = False


Read the checked rows in a datagridview


For i = 0 To dgcourse.Rows.Count - 1

   If dgcourse.Rows(i).Cells("select").Value Then
      'dgcourse.Item(1, i).Value 
    End If


Next i


Delete row in datagridview

DataGridView1.Rows.Remove(DataGridView1.Rows(x))

Make one column set as editable

Datagridview Readonly Property set as True - all columns are not editable.


dataGridView1.Columns("ColumnName").ReadOnly = false;



Wednesday, 22 November 2017

How to send SMS from vb .net application?


Vb.net code for send sms.


Try


Imports System.Net


Public Class Form1




    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

        Dim mobile As String = "Sender Mobile number here.."

        Try

            Dim url As String
  
            'paste your sms api code to url
               
            'url = "http://xxxxxxxxxx.com/SMS_API/sendsms.php?username=XXXX&password=XXXXX&mobile=" + mobile + "&sendername=XXXX&message=XXXXX&routetype=1"


            url="Paste your api code"
            

            
            Dim myReq As HttpWebRequest = DirectCast(WebRequest.Create(url), HttpWebRequest)
            Dim myResp As HttpWebResponse = DirectCast(myReq.GetResponse(), HttpWebResponse)
            Dim respStreamReader As New System.IO.StreamReader(myResp.GetResponseStream())
            Dim responseString As String = respStreamReader.ReadToEnd()
            respStreamReader.Close()
            myResp.Close()
            MsgBox("ok")

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

    End Sub

End Class






Related links

How to send free SMS from vb .net application?





Sunday, 29 October 2017

Jquery Tutorials


Jquery Checkbox check all


Html Code

<input type='checkbox' class='checkall' id='check_all_id'>

Jquery

To use .prop() to set the checked property

$('#check_all_id').on('click', function(e) {        
        $('input:checkbox').not(this).prop('checked', this.checked);
    });




Thursday, 26 October 2017

Yii2 Gridview with popup

Modal pop up in grid view in yii2

I am going to show you how to  implement Gridview with popup.

Insert this code your header section.

use yii\helpers\Url;  
use yii\bootstrap\Modal;

Define modal and Register this JS into you'r index file

Add Modal code above GridView code.

<?php
Modal::begin([
    'id' => 'myModal',
    'header' => '<h4 class="modal-title">...</h4>',
]);
 
echo '...';
 
Modal::end();
?>


And than register JavaScript at top or bottom of view page.

$this->registerJs("
    $('#myModal').on('show.bs.modal', function (event) {
        var button = $(event.relatedTarget)
        var modal = $(this)
        var title = button.data('title')
        var href = button.attr('href')
        modal.find('.modal-title').html(title)
        modal.find('.modal-body').html('<i class=\"fa fa-spinner fa-spin\"></i>')
        $.post(href)
            .done(function( data ) {
                modal.find('.modal-body').html(data)
            });
        })
");


Insert code into gridview column section

return  Html::a($count,['detail','group_id'=>$data->id],[
          'data-toggle'=>"modal",
          'data-target'=>"#myModal",
          'data-title'=>"Detail Data",
        ]);

Inset code into your controller

return $this->renderAjax('detail', [
    'searchModel' => $searchModel,
    'dataProvider' => $dataProvider,
]);


Yii2 grid with Editable column



Example




Index file

<?php

use yii\helpers\Html;
use yii\grid\GridView;
use backend\modules\tools\models\Groupitems;
use yii\helpers\ArrayHelper;
use backend\modules\tools\models\Center;
use dosamigos\datepicker\DatePicker;

use dosamigos\datepicker\DateRangePicker;
use backend\modules\tools\models\Batch;

use yii\helpers\Url;  
use yii\bootstrap\Modal; 

$this->title = 'Search Students';
$this->params['breadcrumbs'][] = $this->title;

?>

<?php 

Modal::begin([
    'id' => 'myModal',
    'header' => '<h4 class="modal-title">...</h4>',
]);

echo '...';

Modal::end();

$this->registerJs("
    $('#myModal').on('show.bs.modal', function (event) {
        var button = $(event.relatedTarget)
        var modal = $(this)
        var title = button.data('title') 
        var href = button.attr('href') 
        modal.find('.modal-title').html(title)
        modal.find('.modal-body').html('<i class=\"fa fa-spinner fa-spin\"></i>')
        $.post(href)
            .done(function( data ) {
                modal.find('.modal-body').html(data)
            });
        })
");

?>



<?php
     function getCenter(){
                 
                $ccid = Yii::$app->user->identity->ccid;
                if(yii::$app->user->can('z-access-all-centers-report'))  
                    {
                    $x=center::find()->where(['status'=>1])->select(['ccid','subcenter'])->all();                  
                    $y=ArrayHelper::map($x,'ccid','subcenter');
                    //$y[null]='Select All';                                  
                    return $y;
                }
                else {                  
                    return ArrayHelper::map(center::find()->where(['status'=>1,'ccid'=>$ccid])->all(),'ccid','subcenter');
                }
     }
    ?>

<div class="col-xs-12">
  <div class="col-lg-8 col-sm-8 col-xs-12 no-padding edusecArLangCss"><h3 class="box-title"><i class="fa fa-th-list"></i> Manage Students</h3></div>
  <div class="col-lg-4 col-sm-4 col-xs-12 no-padding" style="padding-top: 20px !important;">
<div class="col-xs-4 left-padding">

</div>
<div class="col-xs-4 left-padding">

</div>
<div class="col-xs-4 left-padding">
            <?= Html::a('<i class="fa fa-user"></i> Add Students', ['create'], ['class' => 'btn-sm btn btn-success']) ?>
</div>
  </div>
</div>

<div class="students-index  box box-body table-responsive">

        <!--outside searchabl-->
       <?php echo  $this->render('_searchstudentsearch', ['model' => $searchModel]); ?>
   

       
    <?= GridView::widget([
        'dataProvider' => $dataProvider,
        //'filterModel' => $searchModel,
        'columns' => [
            [
                'header' =>'Sl.No',
                'class' => 'yii\grid\SerialColumn',            
                'options' => ['width' => '50']
            ],
            [                                
                'attribute'=>'ccid',                                                      
                'content' => function($data){
                            return Center::getCenter($data->ccid);
                            },  
                'options' => ['width' => '120'],
                'label'=>'Center',
            ],
            [
                'attribute' => 'admission_number',
                'label' => 'Add No',
                'options' => ['width' => '80']
            ],
            [
                'attribute' => 'application_reference_no',
                'label' => 'Ref No',
                'options' => ['width' => '80']
            ],
            'student_name',
            'mobile',
            [                                
                'attribute'=>'course_applied',                                                      
                'content' => function($data){
                            return Groupitems::getGroupitems($data->course_applied);
                            },                              
            ],
            [
                'attribute' => 'batch',
                'label' => 'Batch',
                'options' => ['width' => '80'],    
            ],                      
            [                                
                'attribute'=>'category',                                                      
                'content' => function($data){
                            return Groupitems::getGroupitems($data->category);
                            },                              
            ],                                                
           [
                'format'=>'raw',                                                      
                'attribute' => 'date_of_join',          
       'format' =>  ['date', 'php:d-m-Y'],
       'options' => ['width' => '1000'],              
   ],                  
            [
                 'label'=>'Rem/TotFee',
                'value'=> function($data)
                  {  
                      return  Html::a($data->remitted_fee.'/'.$data->total_fee,['students/feedisplay','ccid'=>$data->ccid, 'admission_number' => $data->admission_number],
                                                    [
                                                    'data-toggle'=>"modal",
                                                    'data-target'=>"#myModal",
                                                    'data-title'=>"Fee Remitted Details",
                                                    ]); // ubah ini
                  },
                        'format' => 'raw'              
            ],                       
            [
                    'header'=>'Fee',
                    'value'=> function($data)
                              {
                       return  Html::a('<span class="fa fa-inr"></span>', ['receipt/create','addno'=>$data->admission_number]);    
                              },
                     'format' => 'raw'
            ],                                                    
            [
                    'header'=>'Sales',
                    'value'=> function($data)
                              {
                                  $url = Yii::$app->getUrlManager()->createUrl(['stock/stocksales/create','addno'=>$data->admission_number]);
                       return  Html::a('<span class="fa fa-shopping-cart"></span>', $url);    
                              },
                     'format' => 'raw'
              ],                                                          
              [
          'class' => 'yii\grid\ActionColumn',
          'header' => 'Actions',
          'headerOptions' => ['style' => 'color:#337ab7'],
          'template' => '{view}{update}', //yii::$app->user->can('update-students') ? '{view}{update}':'{view}',
          'contentOptions' => ['style' => 'width:70px;'],      
          ],                              
           
        ],
    ]); ?>
         
       
</div>


Controller file

public function actionFeedisplay($ccid,$admission_number){
       
       // Code here...
           
        return $this->renderAjax('studentsearch_fee.php',['dataFee'=>$dataFee]);
       
    }



Related Links

DropDownList

Yii2 Dependent Drop Down Lists

CheckboxList Advanced Operations

Yii2 ListBox Field