/** * Deletes a particular model. * If deletion is successful, the browser will be redirected to the 'admin' page. * @param integer $id the ID of the model to be deleted */ public function actionDelete($id) { if (Yii::app()->request->isPostRequest) { // we only allow deletion via POST request $this->loadModel($id)->delete(); // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser if (!isset($_GET['ajax'])) { $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin')); } } else { if (!Yii::app()->request->isPostRequest) { $emp_tran = EmployeeTransaction::model()->findAll(array('condition' => 'employee_transaction_designation_id=' . $id)); if (!empty($emp_tran)) { throw new CHttpException(400, 'You can not delete this record because it is used in another table.'); } else { $this->loadModel($id)->delete(); $this->redirect(array('admin')); } } else { throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.'); } } }
public function actionEmployeeFinalViewExportToPdf($id) { $employee_transaction = EmployeeTransaction::model()->findAll(' employee_transaction_id=' . $id); $employee_docs = EmployeeDocsTrans::model()->findAll('employee_docs_trans_user_id=' . $id); $employee_qual = EmployeeAcademicRecordTrans::model()->findAll('employee_academic_record_trans_user_id=' . $id); $employee_exp = EmployeeExperienceTrans::model()->findAll('employee_experience_trans_user_id=' . $id); $html = $this->renderPartial('/employeeTransaction/employeeFinalView', array('employee_docs' => $employee_docs, 'employee_qual' => $employee_qual, 'employee_transaction' => $employee_transaction, 'emp_exp' => $employee_exp), true); $this->exporttopdf('Employee Report', 'Employee.pdf', $html); }
/** * This method return employee wise attendence. */ public function emp_search() { // Warning: Please modify the following code to remove attributes that // should not be searched. $tran_id = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id'=>Yii::app()->user->id)); $emp_id = $tran_id['employee_transaction_id']; //Yii::app()->user->setState('emp_id',$id); $criteria=new CDbCriteria; $criteria->condition ="t.employee_id = :emp_id"; $criteria->params = array ( ':emp_id'=>$emp_id, ); $criteria->with = array('Rel_Emp_Info'); $criteria->compare('employee_attendence_id',$this->employee_attendence_id); $criteria->compare('Rel_Emp_Info.employee_first_name',$this->employee_first_name,true); $criteria->compare('Rel_Emp_Info.employee_attendance_card_id',$this->employee_attendance_card_id,true); $criteria->compare('Rel_Emp_Info.employee_no',$this->employee_no,true); $criteria->compare('Rel_Emp_Info.employee_info_transaction_id',$this->employee_info_transaction_id,true); $criteria->compare('date', $this->dbDateSearch($this->date), true); $criteria->compare('employee_id',$this->employee_id); $criteria->compare('time1',$this->time1,true); $criteria->compare('time2',$this->time2,true); $criteria->compare('time3',$this->time3,true); $criteria->compare('time4',$this->time4,true); $criteria->compare('time5',$this->time5,true); $criteria->compare('time6',$this->time6,true); $criteria->compare('time7',$this->time7,true); $criteria->compare('time8',$this->time8,true); $criteria->compare('time9',$this->time9,true); $criteria->compare('time10',$this->time10,true); $criteria->compare('attendence',$this->attendence,true); $criteria->compare('total_hour',$this->total_hour,true); $criteria->compare('overtime_hour',$this->overtime_hour,true); $criteria->compare('csvfile',$this->csvfile); return new CActiveDataProvider($this, array( 'criteria'=>$criteria, 'sort'=>array( 'defaultOrder'=>'employee_attendence_id DESC', ), )); }
<?php $info = EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id'=>Yii::app()->user->getState('emp_id'))); $tranDetails = EmployeeTransaction::model()->findByPk(Yii::app()->user->getState('emp_id')); $picPath = EmployeePhotos::model()->findByPk($tranDetails->employee_transaction_emp_photos_id); ?> <div class="image-tab"> <div class="image-box-user"><img src="<?php echo Yii::app()->baseUrl; ?>/college_data/emp_images/<?php echo $picPath->employee_photos_path; ?>" width="112" height="112"></div> </div> <div class="info-tab"> <div class="myinfo"> <div class="info-title">My Information</div> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td class="info-label">Name - </td> <td class="info-content"><?php echo $info->employee_first_name.' '.$info->employee_last_name; ?></td> <td class="info-label">Birth Date -</td> <td class="info-content"><?php if(!empty($info->employee_dob) && $info->employee_dob!='0000-00-00') { echo $info->employee_dob; }else { echo "Not Set";} ?></td> </tr> <tr> <td class="info-label">Gender - </td> <td class="info-content"><?php echo (!empty($info->employee_gender) ? $info->employee_gender : "Not Set"); ?></td> <td class="info-label">Designation -</td> <td class="info-content"><?php echo (!empty($tranDetails->Rel_Designation->employee_designation_name) ? $tranDetails->Rel_Designation->employee_designation_name : "Not Set"); ?></td> </tr> <tr> <td class="info-label">Department - </td> <td class="info-content"><?php echo (!empty($tranDetails->Rel_Department->department_name) ? $tranDetails->Rel_Department->department_name : "Not Set"); ?></td> <td class="info-label"> </td> <td> </td> </tr> </table>
//$result1 = mysql_query("SELECT * FROM employee_attendence where date = '".$exdate."'"); //$result1 = EmployeeInfo::model()->findByAttributes(array('employee_attendance_card_id'=>$var1)); if(!empty($var1)) { $result1 = Yii::app()->db->createCommand( 'SELECT * FROM employee_info ef INNER JOIN employee_transaction et ON ef.employee_info_transaction_id = et.employee_transaction_id WHERE ef.employee_attendance_card_id ='.$var1.' AND et.employee_transaction_organization_id ='.Yii::app()->user->getState('org_id')) ->queryRow(); //print_r($result1); exit; $empid = $result1['employee_info_transaction_id']; $tr_id = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_id'=>$empid,'employee_transaction_organization_id'=>Yii::app()->user->getState('org_id'))); $eid = $tr_id['employee_transaction_id']; //print_r($leave_date); $result2 = Employee_attendence::model()->findByAttributes(array('employee_id'=>$eid,'date'=>$exdate)); if(empty($result2) && !empty($var1)) { if($var6 == null) $atte = 'A'; else $atte = 'P'; if($eid != 0) { $sql = "INSERT INTO employee_attendence (employee_id,attendence,date,time1,time2,time3,time4,time5,time6,time7, time8, time9,time10,total_hour,overtime_hour,csvfile,employee_attendence_organization_id) VALUES
} ?> <?php if(Yii::app()->user->checkAccess('Exam.BranchSubjectwiseScheduling.Studentexamtimetable') ) { ?> <div id="divlink8" class="info-link"> <?php echo CHtml::link('Exam Timetable',array('/exam/branchSubjectwiseScheduling/studentexamtimetable','id'=>Yii::app()->user->getState('stud_id')),array('target'=>'_blank','style'=>'text-decoration:none;color:white;')); ?> </div> <?php } ?> </div> <?php } //end student if else if(Yii::app()->user->getState('emp_id')) { $employeemodel = EmployeeTransaction::model()->find('employee_transaction_id='.Yii::app()->user->getState('emp_id')); $info = EmployeeInfo::model()->findByPk($employeemodel->employee_transaction_employee_id); $photo = EmployeePhotos::model()->findByPk($employeemodel->employee_transaction_emp_photos_id); ?> <div id="menulink"> <div id="studentlogo"> <?php if($employeemodel->Rel_Photo->employee_photos_path != null) echo CHtml::link(CHtml::image(Yii::app()->baseUrl.'/college_data/emp_images/'.$photo->employee_photos_path,"",array("width"=>"178px","height"=>"176px")),array('/college_data/emp_images/'.$photo->employee_photos_path),array('id'=>'imagelink'))."</br></br>"; /* $config = array( 'scrolling' => 'no', 'autoDimensions' => false,
public function loadAllNotice($list) { $menu = null; foreach($list as $notice) { $menu .= '<div class="notify-data notifiche">'; $menu .='<span class="username">'; $menu .=$notice->student_notification_title; $menu .='</span></br>'; $menu .='<span class="notice-lable"><b>From</b></span><span class="notice-content">'; $menu .=(User::model()->findByPk($notice->student_notification_from)->user_type=='employee')?(EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id'=>(EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id'=>$notice->student_notification_from))->employee_transaction_id)))->employee_first_name):(ucfirst(strtolower(strstr(User::model()->findByPk($notice->student_notification_from)->user_organization_email_id,'@',true)))); $menu .='</span><span class="notice-lable"><b>Content</b></span>'; $menu .='<span class="notice-content">'.$notice->student_notification_content.'</span></div>'; } return $menu; }
?> <tr> <td> <?php echo ++$i; ?> </td> <td> <?php echo EmployeeInfo::model()->findByAttributes(array( 'employee_info_transaction_id' => $v['student_attendence_email_emp_id']))->employee_first_name; ?> </td> <td> <?php echo EmployeeInfo::model()->findByAttributes(array( 'employee_info_transaction_id' => $v['student_attendence_email_emp_id']))->employee_last_name; ?> </td> <td> <?php echo EmployeeDesignation::model()->findByPk(EmployeeTransaction::model()->findByPk($v['student_attendence_email_emp_id'])->employee_transaction_designation_id)->employee_designation_name;?> </td> <td> <?php echo ($v['student_attendence_email_branch_id']==0)?"All Branch":Branch::model()->findByPk($v['student_attendence_email_branch_id'])->branch_name; ?> </td> <td> <?php echo $v['student_attendence_email_minute']; ?> </td> <td> <?php echo $v['student_attendence_email_hour']; ?> </td> <td> <?php echo User::model()->findByPk($v['student_attendence_email_created_by'])->user_organization_email_id; ?> </td> <td>
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model=EmployeeTransaction::model()->findByPk((int)$id); if($model===null) throw new CHttpException(404,'The requested page does not exist.'); return $model; }
public function mysearch() { // Warning: Please modify the following code to remove attributes that // should not be searched. $criteria=new CDbCriteria; $trans = EmployeeTransaction::model()->resetScope()->findByPk($_REQUEST['id']); $users = EmployeeTransaction::model()->resetScope()->findAll('employee_transaction_user_id='.$trans->employee_transaction_user_id); $arr = CHtml::listData($users,'employee_transaction_id','employee_transaction_id'); $criteria->addInCondition('employee_academic_record_trans_user_id',$arr); $criteria->compare('employee_academic_record_trans_id',$this->employee_academic_record_trans_id); $criteria->compare('employee_academic_record_trans_user_id',$this->employee_academic_record_trans_user_id); $criteria->compare('employee_academic_record_trans_qualification_id',$this->employee_academic_record_trans_qualification_id); $criteria->compare('employee_academic_record_trans_eduboard_id',$this->employee_academic_record_trans_eduboard_id); $criteria->compare('employee_academic_record_trans_year_id',$this->employee_academic_record_trans_year_id); $criteria->compare('theory_mark_obtained',$this->theory_mark_obtained); $criteria->compare('theory_mark_max',$this->theory_mark_max); $criteria->compare('theory_percentage',$this->theory_percentage); $criteria->compare('practical_mark_obtained',$this->practical_mark_obtained); $criteria->compare('practical_mark_max',$this->practical_mark_max); $criteria->compare('practical_percentage',$this->practical_percentage); $criteria->compare('employee_academic_record_trans_oraganization_id',$this->employee_academic_record_trans_oraganization_id); $data = new CActiveDataProvider($this, array( 'criteria'=>$criteria, )); $_SESSION['emp_qual']=$data; return $data; }
/** * Retrieves a list of models based on the current search/filter conditions . *retrive list of certificate assign to particular employee * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions . */ public function Employeesearch() { // Warning: Please modify the following code to remove attributes that // should not be searched. $criteria=new CDbCriteria; $trans = EmployeeTransaction::model()->resetScope()->findByPk($_REQUEST['id']); $users = EmployeeTransaction::model()->resetScope()->findAll('employee_transaction_user_id='.$trans->employee_transaction_user_id); $arr = CHtml::listData($users,'employee_transaction_id','employee_transaction_id'); $criteria->addInCondition('employee_certificate_details_table_emp_id',$arr); $criteria->with = array('cer_employee_id'); $criteria->compare('cer_employee_id.employee_first_name',$this->employee_first_name,true); $criteria->compare('employee_certificate_details_table_id',$this->employee_certificate_details_table_id); $criteria->compare('employee_certificate_details_table_emp_id',$this->employee_certificate_details_table_emp_id); $criteria->compare('employee_certificate_type_id',$this->employee_certificate_type_id); $criteria->compare('employee_certificate_created_by',$this->employee_certificate_created_by); $criteria->compare('employee_certificate_creation_date',$this->employee_certificate_creation_date,true); $criteria->compare('employee_certificate_org_id',$this->employee_certificate_org_id); $EmployeeCertificateDetailsTable_records=new CActiveDataProvider($this, array( 'criteria'=>$criteria, )); unset($_SESSION['exportData']); $_SESSION['exportData'] = $EmployeeCertificateDetailsTable_records; return $EmployeeCertificateDetailsTable_records; }
<?php $this->breadcrumbs = array('Employee Infos' => array('index'), $model->employee_id => array('view', 'id' => $model->employee_id), 'Update'); $emp_tran = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_employee_id' => $model->employee_id)); //$branch_id = $emp_tran->employee_transaction_branch_id; $this->menu = array(array('label' => 'List EmployeeInfo', 'url' => array('index')), array('label' => 'Create EmployeeInfo', 'url' => array('create')), array('label' => 'View EmployeeInfo', 'url' => array('view', 'id' => $model->employee_id)), array('label' => 'Manage EmployeeInfo', 'url' => array('admin'))); ?> <h1>Update Employee Details of : <?php echo $model->employee_first_name; ?> </h1> <?php echo $this->renderPartial('_form', array('model' => $model));
/** * Displays the login page */ public function actionLogin() { $this->layout = 'login_layout'; if (Yii::app()->user->isGuest) { $login = new LoginUser(); $model = $this->captchaRequired() ? new LoginForm('captchaRequired') : new LoginForm('login'); if (isset($_POST['ajax']) && $_POST['ajax'] === 'login-form') { echo CActiveForm::validate($model); Yii::app()->end(); } if (isset($_POST['LoginForm'])) { $model->attributes = $_POST['LoginForm']; if ($model->validate() && $model->login()) { $emplogin = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id' => Yii::app()->user->id)); $studlogin = StudentTransaction::model()->findByAttributes(array('student_transaction_user_id' => Yii::app()->user->id)); if ($studlogin) { Yii::app()->user->setState('stud_id', $studlogin->student_transaction_id); } if ($emplogin) { Yii::app()->user->setState('emp_id', $emplogin->employee_transaction_id); } $login->user_id = Yii::app()->user->id; $login->status = 1; $login->log_in_time = new CDbExpression('NOW()'); $login->user_ip_address = $_SERVER['REMOTE_ADDR']; $login->login_organization_id = 1; $login->save(); $this->redirect(array('site/newdashboard')); } else { $this->counter = Yii::app()->session->itemAt('captchaRequired') + 1; Yii::app()->session->add('captchaRequired', $this->counter); } } $this->render('login', array('model' => $model)); } else { $this->redirect(array('site/newdashboard')); } }
public function leftresignsearch() { // Warning: Please modify the following code to remove attributes that // should not be searched. $criteria=new CDbCriteria; $criteria->with = array('Rel_Emp_Info','Rel_user1'); $criteria->compare('Rel_Emp_Info.employee_no',$this->employee_no,true); $criteria->compare('Rel_Emp_Info.employee_unique_id',$this->employee_unique_id,true); $criteria->compare('Rel_Emp_Info.employee_attendance_card_id',$this->employee_attendance_card_id,true); $criteria->compare('Rel_Emp_Info.employee_first_name',$this->employee_first_name,true); $criteria->compare('Rel_Emp_Info.employee_last_name',$this->employee_last_name,true); $criteria->compare('employee_transaction_designation_id',$this->employee_transaction_designation_id); $criteria->compare('employee_transaction_department_id',$this->employee_transaction_department_id); $criteria->addCondition('employee_status=1'); $emp_data = new CActiveDataProvider(EmployeeTransaction::model()->resetScope(), array( 'criteria'=>$criteria, )); $_SESSION['employee_records']=$emp_data; return $emp_data; }
public function actionUpdate_emp_password($id) { $model = $this->loadModel($id); //$emp_email=EmployeeInfo::model()->findByPk($_REQUEST['id'])->employee_private_email; $emp_data = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id' => $_REQUEST['id'])); $emp_info = EmployeeInfo::model()->findByPk($emp_data->employee_transaction_employee_id)->employee_first_name; $model->user_password = MD5($model->user_organization_email_id . $model->user_organization_email_id); $model->save(); Yii::app()->user->setFlash('resetemppassword', $emp_info . ' ' . "Password is Reset"); $this->redirect(array('user/resetemppassword')); }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model=new EmployeeNotification; // comment the following line if AJAX validation is not needed $this->performAjaxValidation($model); if(isset($_POST['EmployeeNotification'])) { if(!empty($_POST['EmployeeNotification']['to'])) { $model->attributes = $_POST['EmployeeNotification']; $to=$model->emp_notice_to; $emp_tran_id=EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id'=>$to))->employee_transaction_id; $model->to=$emp_tran_id; } else { $model->attributes = $_POST['EmployeeNotification']; $model->emp_notice_to=0; } if(!empty($_POST['EmployeeNotification']['notifiyii_department_id'])) { $model->notifiyii_department_id=$_POST['EmployeeNotification']['notifiyii_department_id']; } else { $model->notifiyii_department_id=0; } $startdate = $_POST['EmployeeNotification']['alert_after_date']; $alertstartdate = date("Y-m-d", strtotime($startdate)); $model->alert_after_date = $alertstartdate ; $enddate = $_POST['EmployeeNotification']['alert_before_date']; $alertenddate = date("Y-m-d", strtotime($enddate)); $model->alert_before_date = $alertenddate ; $expire=$_POST['EmployeeNotification']['expire']; $alertexpire = date("Y-m-d", strtotime($expire)); $model->expire = $alertexpire ; $model->from=Yii::app()->user->id; $model->employee_notification_creation_date = new CDbExpression('NOW()'); if($model->save()) $this->redirect(array('view','id'=>$model->id)); } $this->render('create',array( 'model'=>$model, )); }
/** * Displays the login page */ public function actionLogin() { $this->layout = 'loginLayout'; if (Yii::app()->user->isGuest) { $login = new LoginUser(); $model = $this->captchaRequired() ? new LoginForm('captchaRequired') : new LoginForm('login'); // if it is ajax validation request if (isset($_POST['ajax']) && $_POST['ajax'] === 'login-form') { echo CActiveForm::validate($model); Yii::app()->end(); } // collect user input data if (isset($_POST['LoginForm'])) { $model->attributes = $_POST['LoginForm']; // validate user input and redirect to the previous page if valid if ($model->validate() && $model->login()) { $login->user_id = Yii::app()->user->id; $loginuser = $login->user_id; $emplogin = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id' => $loginuser)); $studlogin = StudentTransaction::model()->findByAttributes(array('student_transaction_user_id' => $loginuser)); if ($studlogin) { Yii::app()->user->setState('stud_id', $studlogin->student_transaction_id); } if ($emplogin) { Yii::app()->user->setState('emp_id', $emplogin->employee_transaction_id); } $login->status = 1; $login->log_in_time = new CDbExpression('NOW()'); $login->user_ip_address = $_SERVER['REMOTE_ADDR']; $login->save(); $this->redirect(array('dashboard/dashboard')); } else { $this->counter = Yii::app()->session->itemAt('captchaRequired') + 1; Yii::app()->session->add('captchaRequired', $this->counter); } } $this->render('login', array('model' => $model)); } else { if (Yii::app()->user->getState('org_id') != NULL) { $this->redirect(array('site/dashboard')); } else { Yii::app()->user->logout(); $this->redirect(Yii::app()->homeUrl); } } }
<div class="profile-details"> <div class="profile-pic"> <?php $empId = EmployeeTransaction::model()->findByPk(Yii::app()->user->getState('emp_id')); $pic = EmployeePhotos::model()->findByPk($empId->employee_transaction_emp_photos_id)->employee_photos_path; echo CHtml::image(Yii::app()->baseUrl.'/college_data/emp_images/'.$pic); ?> </div> <div class="profile-link"> <ul class="links"> <li><?php echo CHtml::link('Holidays', array('/report/myholidays','id'=>$empId->employee_transaction_id)); ?></li> </ul> </div> </div>
<div class="operation"> <?php echo CHtml::link('Back', array('admin'), array('class'=>'btnback'));?> </div> </div> <?php $this->widget('zii.widgets.CDetailView', array( 'data'=>$model, 'attributes'=>array( array( 'name'=>'student_notification_content', 'type'=>'raw', ), array( 'name'=>'student_notification_alert_after_date', 'value'=>date_format(date_create($model->student_notification_alert_after_date), "d-m-Y") ), array( 'name'=>'student_notification_alert_before_date', 'value'=>date_format(date_create($model->student_notification_alert_before_date), "d-m-Y") ), array( 'name'=>'student_notification_from', 'value'=>(User::model()->findByPk($model->student_notification_from)->user_type=='employee')?(EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id'=>(EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id'=>$model->student_notification_from))->employee_transaction_id)))->employee_first_name):(ucfirst(strtolower(strstr(User::model()->findByPk($model->student_notification_from)->user_organization_email_id,'@',true)))), ), ), 'htmlOptions'=> array('class'=>'custom-view'), )); ?></div>
public function actionEmployeeFinalViewExportToPdf($id) { $employee_transaction = EmployeeTransaction::model()->findAll('employee_transaction_id='.$id); $employee_docs = EmployeeDocsTrans::model()->findAll('employee_docs_trans_user_id='.$id); $employee_qual = EmployeeAcademicRecordTrans::model()->findAll('employee_academic_record_trans_user_id='.$id); $employee_exp = EmployeeExperienceTrans::model()->findAll('employee_experience_trans_user_id='.$id); $html = $this->renderPartial('/employeeTransaction/employeeFinalView', array( 'employee_docs'=>$employee_docs, 'employee_qual'=>$employee_qual, 'employee_transaction'=>$employee_transaction, 'emp_exp'=>$employee_exp, ), true); ob_clean(); //$pdf = new TCPDF(); //$pdf->SetCreator(PDF_CREATOR); //$pdf->SetAuthor(Yii::app()->name); //$pdf->SetTitle($title); //$pdf->SetSubject($title); //$pdf->SetKeywords('example, text, report'); //$pdf->SetHeaderData('', 0, $title, ''); //$pdf->setHeaderFont(Array('helvetica', '', 8)); //$pdf->setFooterFont(Array('helvetica', '', 6)); //$pdf->SetMargins(15, 18, 15); //$pdf->SetHeaderMargin(5); //$pdf->SetFooterMargin(10); //$pdf->SetAutoPageBreak(TRUE, 15); //$pdf->SetFont('dejavusans', '', 7); //$resolution= array(150, 150); //$pdf->AddPage('P', $resolution); $html = '<style> table, th, td { border : 1px solid #000;} th {text-align: center;}</style>'.$html; //$pdf->writeHTML($html, true, false, true, false, ''); //$pdf->LastPage(); //$pdf->Output($filename, "I"); $this->exporttopdf('Employee Report','Employee.pdf',$html); }
public function actionDoChacked(){ $model=new EmployeeSmsEmailDetails; $model->scenario='selectedsms'; Yii::app()->clientScript->registerScript("message-script", " $(document).ready(function() { $('input.radio').bind('change', function (){ if($(this).val()=='1') $('#EmployeeSmsEmailDetails_message_email_text').attr('maxlength','160'); else $('#EmployeeSmsEmailDetails_message_email_text').attr('maxlength',''); }); }); ", CClientScript::POS_END); $this->performAjaxValidation($model); if(isset($_POST['EmployeeSmsEmailDetails'])) { $model->attributes=$_POST['EmployeeSmsEmailDetails']; $emp_ids = $_POST['result']; foreach ($emp_ids as $item) { $num_list[]=EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id'=>$item))->employee_private_mobile; $email_list[]=EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id'=>$item))->employee_private_email; } $message=$model->message_email_text; $sms_email_status=$model->email_sms_status; if($sms_email_status==1) { $output = implode(",",$num_list); $smsobj=new SmsApi; $r=$smsobj->sendsms($output,$message); if(preg_match('/SMS/',$r)) { echo 'Message sucessfully sent'; $i=0; foreach($emp_ids as $item) { $model->employee_sms_email_id=null; $model->employee_id = $item; $model->created_by = Yii::app()->user->id; $model->creation_date = new CDbExpression('NOW()'); $tran=EmployeeTransaction::model()->findByPk($item); $department=$tran->employee_transaction_department_id; $model->department_id=$department; $model->employee_sms_email_details_ack_id="sent"; $model->setIsNewRecord(true); $model->save(false); $i++; } $this->redirect(array('admin')); } else { $this->render('error_form'); } } if($sms_email_status==2) { $mailobj=new MailApi; $to = implode(",",$email_list); $mailobj->sendmail($to,$message); foreach($emp_ids as $item) { $model->employee_sms_email_id=null; $model->employee_id = $item; $model->created_by = Yii::app()->user->id; $model->creation_date = new CDbExpression('NOW()'); $tran=EmployeeTransaction::model()->findByPk($item); $department=$tran->employee_transaction_department_id; $model->department_id=$department; $model->setIsNewRecord(true); $model->save(false); } $this->redirect(array('admin')); } } else { if(!empty($_POST['selectedempid'])) { $emp_data =explode(',', $_POST['selectedempid']); $this->render('message_form',array('list'=>$emp_data,'model'=>$model)); } else { $this->redirect(array('employeebulksmsemail')); } } }
public function mysearch() { // Warning: Please modify the following code to remove attributes that // should not be searched. $criteria=new CDbCriteria; $trans = EmployeeTransaction::model()->resetScope()->findByPk($_REQUEST['id']); $users = EmployeeTransaction::model()->resetScope()->findAll('employee_transaction_user_id='.$trans->employee_transaction_user_id); $arr = CHtml::listData($users,'employee_transaction_id','employee_transaction_id'); $criteria->addInCondition('employee_experience_trans_user_id',$arr); $criteria->compare('employee_experience_trans_id',$this->employee_experience_trans_id); $criteria->compare('employee_experience_trans_user_id',$this->employee_experience_trans_user_id); $criteria->compare('employee_experience_trans_emp_experience_id',$this->employee_experience_trans_emp_experience_id); $data = new CActiveDataProvider($this, array( 'criteria'=>$criteria, )); $_SESSION['emp_exp']=$data; return $data; }
$("#add-tab").click(function(event) { $('#updateData').attr('href', editLinkPath + '/employee/employeeTransaction/updateprofiletab4?id=' + '<?php echo $_REQUEST["id"]; ?>'); }); $("#personal-tab").click(function(event) { $('#updateData').attr('href', editLinkPath + '/employee/employeeTransaction/updateprofiletab1?id=' + '<?php echo $_REQUEST["id"]; ?>'); }); }); </script> <div class="clear-div"></div> <div class="profile-page-box"> <!--===============================Page header start============================--> <div class="page-title-header"><i class="fa fa-plus"></i> View Employee Profile</div> <!--===============================Page header end============================--> <?php $empInfo = EmployeeTransaction::model()->findByPk($_REQUEST['id']); $emppicPath = EmployeePhotos::model()->findByPk($empInfo->employee_transaction_emp_photos_id); $emp_photo=Yii::app()->baseUrl."/college_data/emp_images/".$emppicPath->employee_photos_path; ?> <!--Profile Tab Start--> <div class="profile-box-bg"> <div class="profilebox-left"> <div class="profile-image-tab"> <?php if(Yii::app()->user->checkAccess('EmployeeTransaction.UpdateEmployeeData') && (Yii::app()->user->getState('emp_id') == $_REQUEST['id']) || Yii::app()->user->checkAccess('EmployeeTransaction.UpdateAllEmployeeData') && $model->employee_status==0) { ?> <a title="Change Picture" href ="<?php echo Yii::app()->baseUrl.'/employee/employeeTransaction/updateprofilephoto?id='.$_REQUEST['id']; ?>"> <?php }?> <div class="profile-box-user"><img src="<?php echo $emp_photo;?>" width="200" height="200"></div></a> </div> </div> <div class="profilebox-middle" style="font-family : sans-serif; "> <div class="profile-username"><?php echo $empInfo->Rel_Emp_Info->employee_first_name.' '.$empInfo->Rel_Emp_Info->employee_last_name ;?> </div>
<?php $resign_emp_data = EmployeeTransaction::model()->resetScope()->findAll(array('condition'=>'employee_status= 2 and employee_transaction_organization_id = '.Yii::app()->user->getState('org_id'))); ?> <table> <tr> <td>First Name</td> <td>Last Name</td> <td>Attendence Card</td> <td>Designation</td> <td>Department</td> <td>Shift</td> <td>Resign Application Date</td> <td>Resign Approve Date</td> <td></td> </tr> <?php foreach($resign_emp_data as $list) { $emp_info = EmployeeInfo::model()->resetScope()->findByAttributes(array('employee_info_transaction_id'=>$list['employee_transaction_id'])); $emp_level_max = Yii::app()->db->createCommand() ->select('MAX(reporting_priority),employee_exit_reporting_employee_id') ->from('employee_exit_reporting') ->group('employee_exit_employee_id') ->where('employee_exit_employee_id ='.$list['employee_transaction_id']) ->queryRow(); $max_priority = $emp_level_max['MAX(reporting_priority)']; $reporting_emp_id = EmployeeExitReporting::model()->findByAttributes(array('employee_exit_employee_id'=>$list['employee_transaction_id'],'reporting_priority'=>$max_priority)); $report_emp = $reporting_emp_id['employee_exit_reporting_employee_id']; $exit_details = EmployeeExitDetails::model()->findByAttributes(array('employee_exit_details_employee_id'=>$list['employee_transaction_id'],'reporting_employee_id'=>$report_emp,'reporting_employee_review_status'=>2)); $app_date = $exit_details['employee_resign_application_date'];
if(!empty($_REQUEST['empid'])) { echo CHtml::link('GO BACK', array('/employee/employeeTransaction/employeeCertificates','id'=>$_REQUEST['empid']),array('id'=>'printid1')); } else { echo CHtml::link('GO BACK',array('certificate/EmployeeCertificategeneration'),array('id'=>'printid1')); echo CHtml::button('Save',array('id'=>'printid1','class'=>'submit','submit' => array('certificate/SaveEmployeeCertificatedata','emp_id'=>$emp_info->employee_info_transaction_id,'ctype'=>$certificate_type))); } ?> <button style='margin-left:50px;' class='submit' onclick="javascript:window.print()" id="printid1" class="submit">Print</button> <?php if($emp_info) { $trans = EmployeeTransaction::model()->findByPk($emp_info->employee_info_transaction_id); $titl = "<b>".$emp_info->title."</b>"; $name = "<b>".$emp_info->employee_first_name." ".$emp_info->employee_middle_name." ".$emp_info->employee_last_name."</b>"; $attendence_no = "<b>".$attendence_no."</b>"; $gender = "<b>".$emp_info->employee_gender."</b>"; $emobile = "<b>".$emp_info->employee_private_mobile."</b>"; if($trans->employee_transaction_department_id !=0) $department = "<b>".Department::model()->findByPk($trans->employee_transaction_department_id)->department_name."</b>"; else $department = "<b>not set</b>"; if($trans->employee_transaction_designation_id !=0) $designation = "<b>".EmployeeDesignation::model()->findByPk($trans->employee_transaction_designation_id)->employee_designation_name."</b>"; else
echo $form->error($model, 'batch_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'employee_id'); ?> <?php //$faculty = array(); $facultytablelist = EmployeeTransaction::model()->findAll('employee_transaction_organization_id=' . Yii::app()->user->getState('org_id')); //$i=0; $facname = array(); foreach ($facultytablelist as $f) { //echo $f['employee_transaction_employee_id']; $res1 = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_employee_id' => $f['employee_transaction_employee_id'])); // echo $res1['']; $temp1 = EmployeeInfo::model()->findByAttributes(array('employee_type' => 1, 'employee_id' => $f['employee_transaction_employee_id'])); if ($temp1) { $temp = $res1['employee_transaction_id']; $facname[$temp] = $temp1['employee_first_name']; } } echo $form->dropDownList($model, 'employee_id', $facname, array('empty' => 'Select Faculty')); ?> <?php echo $form->error($model, 'employee_id'); ?> </div>
} else { if ($user == 'student') { $username = StudentInfo::model()->findByPk(StudentTransaction::model()->findByAttributes(array('student_transaction_user_id' => Yii::app()->user->id))->student_transaction_student_id)->student_first_name; } else { $username = EmployeeInfo::model()->findByPk(EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id' => Yii::app()->user->id))->employee_transaction_employee_id)->employee_first_name; } } ?> <a data-close-others="true" data-hover="dropdown" data-toggle="dropdown" class="dropdown-toggle" href="#"> <?php $checkUser = StudentTransaction::model()->findByAttributes(array('student_transaction_user_id' => Yii::app()->user->id)); if ($checkUser) { $avtar = StudentPhotos::model()->findByPk($checkUser->student_transaction_student_photos_id)->student_photos_path; echo CHtml::image(Yii::app()->baseUrl . '/college_data/stud_images/' . $avtar, 'Student', array('height' => 29, 'width' => '29')); } else { $checkUser = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_user_id' => Yii::app()->user->id)); if ($checkUser) { $avtar = EmployeePhotos::model()->findByPk($checkUser->employee_transaction_emp_photos_id)->employee_photos_path; echo CHtml::image(Yii::app()->baseUrl . '/college_data/emp_images/' . $avtar, 'Student', array('height' => 29, 'width' => '29')); } else { echo '<img src="' . Yii::app()->baseUrl . '/images/no_image_icon.jpg" alt="" height=29 width=29>'; } } ?> <span class="username"><?php echo $username; ?> </span> <i class="icon-angle-down"></i> </a>
public function actionEmployeeCertificategeneration() { $model = new Certificate(); $model->scenario = 'employeeCertificategeneration'; $this->performAjaxValidation($model); $attendence_no = null; $certificate_type = null; if (!empty($_POST['Certificate']['attendenceno']) && !empty($_POST['Certificate']['certificatetype']) || !empty($_REQUEST['id']) && !empty($_REQUEST['eno'])) { if (!empty($_POST['Certificate']['attendenceno'])) { $attendence_no = $_POST['Certificate']['attendenceno']; } if (!empty($_REQUEST['eno'])) { $attendence_no = $_REQUEST['eno']; } if (!empty($_POST['Certificate']['certificatetype'])) { $certificate_type = $_POST['Certificate']['certificatetype']; } if (!empty($_REQUEST['id'])) { $certificate_type = $_REQUEST['id']; } $info_model = EmployeeInfo::model()->findByAttributes(array('employee_attendance_card_id' => $attendence_no)); if (empty($info_model)) { Yii::app()->user->setFlash('No-Employee-Found', "No Employee found with this Attendance Card No."); $this->redirect(array('EmployeeCertificategeneration')); } if (!empty($info_model)) { $emp_trans_model = EmployeeTransaction::model()->findByAttributes(array('employee_transaction_employee_id' => $info_model->employee_id)); if (empty($emp_trans_model)) { Yii::app()->user->setFlash('No-Employee-Found', "No Employee found with this No."); $this->redirect(array('EmployeeCertificategeneration')); } } $baseUrl = Yii::app()->baseUrl; $cs = Yii::app()->getClientScript(); $cs->registerCssFile($baseUrl . '/css/certificate.css'); $this->layout = "reciept_layout"; $this->render('emp_certificate_layout_final', array('attendence_no' => $attendence_no, 'certificate_type' => $certificate_type)); } else { if (!empty($_REQUEST['sctid'])) { $empcertificate = EmployeeCertificateDetailsTable::model()->findByPk($_REQUEST['sctid']); $certificate_type = $empcertificate->employee_certificate_type_id; $emp = $empcertificate->employee_certificate_details_table_emp_id; $attendance_no = EmployeeInfo::model()->findByAttributes(array('employee_info_transaction_id' => $emp))->employee_attendance_card_id; $baseUrl = Yii::app()->baseUrl; $cs = Yii::app()->getClientScript(); $cs->registerCssFile($baseUrl . '/css/certificate.css'); $this->layout = "reciept_layout"; $this->render('emp_certificate_layout_final', array('attendence_no' => $attendance_no, 'certificate_type' => $certificate_type)); } else { $this->render('employee_certificate_generate', array('attendence_no' => $attendence_no, 'model' => $model, 'certificate_type' => $certificate_type)); } } }