melaniecarr23

var nodemailer = require('nodemailer');
// setup transporter to email from localhost noreply address
var transporter     = nodemailer.createTransport({
	host: 'localhost',
	port: 25,
	tls:{
        rejectUnauthorized: false
    }
});
var path = require('path');

melaniecarr23

 // patient dropdown editable column
   [
	    'class' => 'kartik\grid\EditableColumn',
	    'attribute' => 'patientID',
	    'pageSummary' => true,
	    'width' => '100px',
	    // filtering grid
	    'filterType'=>GridView::FILTER_SELECT2,
	    'filter'=>ArrayHelper::map(Patient::find()->where(['active_patient'=>1])->orderBy('Nickname')->asArray()->all(), 'ID', 'Nickname'), 
	    'filterWidgetOptions'=>[

melaniecarr23

<?= DynaGrid::widget([
    'columns' => $columns,
    'theme'=>'panel-info',
    'showPersonalize'=>true,
    'storage'=>'cookie',
    'gridOptions'=>[
        'pjax' => true,
        'dataProvider'=>$dataProvider,
        'filterModel'=>$searchModel,
        'floatHeader'=>true,

melaniecarr23

 // status dropdown editable column
   [
        'class' => 'kartik\grid\EditableColumn',
        'attribute' => 'appt_statusID',
        'refreshGrid' => true,
        'pageSummary' => true,
        'width' => '100px',
        // filtering grid
        'filterType'=>GridView::FILTER_SELECT2,
        'filter'=>ArrayHelper::map(ApptStatus::find()->orderBy('ID')->asArray()->all(), 'ID', 'appointment_status'), 

melaniecarr23

 // appt type dropdown editable column
    [
            'class' => 'kartik\grid\EditableColumn',
            'attribute' => 'appt_typeID',
            'pageSummary' => true,
            'width' => '100px',
            // filtering grid
            'filterType'=>GridView::FILTER_SELECT2,
            'filter'=>ArrayHelper::map(ApptType::find()->orderBy('ID')->asArray()->all(),'ID', 'appt_abbr'), 
            'filterWidgetOptions'=>[

melaniecarr23

 public function actions() {
        // tutorial for EditableColumnAction to work found at
        // http://webtips.krajee.com/rapidly-setup-gridview-editable-cells-with-editable-column-action/
        return ArrayHelper::merge(parent::actions(), [
            'editappt' =>[
            //identifier for your editable action
            'class' => EditableColumnAction::className(),
            // action class name
            'modelClass' => Appt::className(),
            /* the update model class