153 lines
9.4 KiB
PHP
153 lines
9.4 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers;
|
|
use Illuminate\Http\Request;
|
|
use App\Http\Requests\LambdaRequest;
|
|
use DB;
|
|
|
|
use League\Csv\Reader;
|
|
use Auth;
|
|
|
|
class RcpaformController extends Controller
|
|
{
|
|
public function __construct()
|
|
{
|
|
$this->middleware('auth');
|
|
$this->_service = 'rcpa';
|
|
$this->_module = 'form';
|
|
$this->_viewname = 'rcpaform';
|
|
$this->_title = 'RCPA Form';
|
|
$this->_base_url = '/rcpaform';
|
|
}
|
|
|
|
protected function get_list_fields(){
|
|
return [
|
|
'actions' => ['title' => 'Actions', 'buttons' => [ 'edit', 'delete', 'questions' => ['icon' => 'progress-question', 'querystring' => 'id={ID}'], 'import' => ['icon' => 'cloud-upload', 'querystring' => 'id={ID}'] ] ],
|
|
'title' => ['title' => 'Title', 'type' => 'text'],
|
|
'workflow' => ['title' => 'Workflow', 'type' => 'text'],
|
|
'status' => ['title' => 'Status', 'type' => 'select'],
|
|
|
|
];
|
|
}
|
|
|
|
protected function get_form_fields($type, $values){
|
|
$users = $this->getlambda('get', 'ums', 'users', 'dropdown');
|
|
$users_dd = ['l1manager' => 'L1 Manager', 'l2manager' => 'L2 Manager'];
|
|
foreach($users->data->items as $user){
|
|
$users_dd[$user->id] = $user->firstname . ' ' . $user->lastname . ' (' . $user->employee_code . ')';
|
|
}
|
|
$roles = $this->getlambda('get', 'ums', 'roles', 'dropdown');
|
|
$roles_dd = [];
|
|
foreach($roles->data->items as $role){
|
|
$roles_dd[$role->id] = $role->name;
|
|
}
|
|
|
|
$coattr = $this->getlambda('get', 'contact', 'contactattribute', 'get_all');
|
|
$coattr_dd = [];
|
|
foreach($coattr->data->items as $coatt){
|
|
$coattr_dd[$coatt->code] = $coatt->attribute;
|
|
}
|
|
|
|
return [
|
|
'title' => ['title' => 'Title', 'type' => 'text', 'required' => true],
|
|
'status' => ['title' => 'Status', 'type' => 'select', 'required' => true, 'values' => ['active' => 'Active', 'disabled' => 'Disabled'] ],
|
|
'metric_submission' => ['title' => 'Metric Submission', 'type' => 'yesno', 'required' => true],
|
|
'metric_authkey' => ['title' => 'Auth Key', 'type' => 'text', 'required' => true],
|
|
|
|
'manager_de_roles' => ['title' => 'Manager Data Entry Roles', 'type' => 'multiselect', 'values' => $roles_dd ],
|
|
'contact_attributes' => ['title' => 'Include Doctor Attributes in Export', 'type' => 'multiselect', 'values' => $coattr_dd],
|
|
|
|
'self_notification' => ['title' => 'Self Email Notification', 'type' => 'yesno', 'required' => true, 'fullwidth' => true],
|
|
'manager1_email_notification' => ['title' => '1st Level Manager Email Notification', 'type' => 'yesno', 'required' => true],
|
|
'manager1_push_notification' => ['title' => '1st Level Manager Mobile Notification', 'type' => 'yesno', 'required' => true],
|
|
|
|
'manager2_email_notification' => ['title' => '2nd Level Manager Email Notification', 'type' => 'yesno', 'required' => true],
|
|
'manager2_push_notification' => ['title' => '2nd Level Manager Mobile Notification', 'type' => 'yesno', 'required' => true],
|
|
|
|
'roles_email_notification' => ['title' => 'Email Notification to Roles', 'type' => 'multiselect', 'values' => $roles_dd ],
|
|
'roles_push_notification' => ['title' => 'Push Notification to Roles', 'type' => 'multiselect', 'values' => $roles_dd ],
|
|
'allow_non_hierarchy_submission' => ['title' => 'Allow Non Hierarchy Submission', 'type' => 'yesno', 'required' => true],
|
|
|
|
'workflow' => ['title' => 'Enable Workflow', 'type' => 'yesno', 'required' => true],
|
|
'workflow_type' => ['title' => 'Workflow type', 'type' => 'select', 'required' => true, 'values' => ['single' => 'Single Persoon', 'multiple' => 'Multiple person', 'sequencial' => 'Sequencial'] ],
|
|
'approver_can_edit' => ['title' => 'Approver can edit entry', 'type' => 'yesno', 'required' => true],
|
|
'is_personalized' => ['title' => 'Is Personalization Needed', 'type' => 'yesno', 'required' => true],
|
|
'allow_delete_by_user' => ['title' => 'Allow Submission Delete by User', 'type' => 'yesno', 'required' => true],
|
|
'export_fields' => ['title' => 'Export Fields', 'type' => 'textarea', 'required' => false, 'fullwidth' => true ],
|
|
'workflow_approvers' => ['title' => 'Metric', 'type' => 'mapping', 'required' => true, 'approvers' => $users_dd, 'fullwidth' => true ],
|
|
];
|
|
}
|
|
|
|
protected function _beforeform($type, $values) {
|
|
if($type == 'edit') {
|
|
$values->self_notification = isset($values->self_notification) ? $values->self_notification : 'no';
|
|
$values->manager1_email_notification = isset($values->manager1_email_notification) ? $values->manager1_email_notification : 'no';
|
|
$values->manager1_push_notification = isset($values->manager1_push_notification) ? $values->manager1_push_notification : 'no';
|
|
$values->manager2_email_notification = isset($values->manager2_email_notification) ? $values->manager2_email_notification : 'no';
|
|
$values->manager2_push_notification = isset($values->manager2_push_notification) ? $values->manager2_push_notification : 'no';
|
|
$values->export_fields = isset($values->export_fields) ? $values->export_fields : '';
|
|
}
|
|
//echo '<pre>'; print_r($values); exit;
|
|
return $values;
|
|
}
|
|
|
|
public function questions(Request $request) {
|
|
$entity_id = $request->input('id', 0);
|
|
if($entity_id === 0) {
|
|
return redirect('/formentitys')->withError('Form not found!');
|
|
} else {
|
|
$request->session()->put('entity_id', $entity_id);
|
|
return redirect('/formquestions');
|
|
}
|
|
}
|
|
|
|
public function postimport(Request $request) {
|
|
$entity_id = $request->input('id');
|
|
if( $request->file('importfile') ) {
|
|
$path = $request->file('importfile')->store('form_import');
|
|
$csv = Reader::createFromPath(storage_path('app') .'/' . $path, 'r');
|
|
$csv->setHeaderOffset(0);
|
|
|
|
$header = $csv->getHeader(); //returns the CSV header record
|
|
$records = $csv->getRecords(); //returns all the CSV records as an Iterator object
|
|
|
|
$response = LambdaRequest::signedrequest('get', $this->_service, 'formquestion/get_all', ['entity_id' => $entity_id]);
|
|
$forfields = [];
|
|
foreach ($response->data->items as $q) {
|
|
$forfields[] = $q->code;
|
|
}
|
|
|
|
$count = 0;
|
|
$recs = [];
|
|
// $forfields = ['is-aware-of-the-customer-perspective-potential-prescription-position','has-customer-plan-based-on-customer-perspective','rcpawardicu-quantified-rcpa-comp-taken-pob-dr-perspective-on-molecule-or-price-etc','call-objective-planned-question-opening-statement-materials-and-objection-anticipated','greeted-customer-appropriately','used-planned-opening-statement','gained-attention-of-the-customer','was-ready-with-tab-maintained-eye-contact-with-doctor-had-a-clear-voice','asked-planned-question-as-per-call-planning','asked-question-related-to-customer-behaviourbelief-service','listened-attentively-and-asked-follow-up-question-if-required','generated-desired-response-from-customer','maintained-the-sequence-of-product-as-per-the-speciality-p1p2p3','shared-benefit-of-productdevicesservices-as-per-marketing-strategy','shared-informationused-the-materialstools-as-per-plan-demonstrated-and-discussed-cipla-devices','utilized-the-tab-effectively-smooth-navigation-highlighted-studies-zoomed-graphs-etc','listened-attentively-acknowledged-concern','asked-questions-to-seek-clarity-on-questionobjection','shared-the-relevant-information','confirmed-if-objectionquestion-was-addressed-assured-follow-through-actions-if-required-and-returned-to-call-flow','summarized-the-key-discussion-points','gained-agreement-basis-call-objective-from-the-doctor','quantified-the-demand-with-rx','left-lblreminder-of-focused-product','total_score','area-of-strength','area-of-development','coaching-objective','development-time-frame','next-coaching-visit','development-action-plan'];
|
|
|
|
foreach ($records as $record) {
|
|
$record['record_date'] = '2024-04-02';
|
|
$record['created_date'] = strtotime("now");
|
|
$formdata = [];
|
|
foreach($forfields as $field) {
|
|
if(isset($record[$field])) {
|
|
$formdata[$field] = $record[$field] == 'Yes' ? 1 : ( $record[$field] == 'No' ? 0 : $record[$field] ) ;
|
|
}
|
|
}
|
|
$recs[] = [
|
|
'entity_id' => $entity_id,
|
|
'formdata' => $formdata,
|
|
'employee_code' => $record['employee_code'],
|
|
'partition' => 'rapport-'.Auth::user()->domain,
|
|
'record_date' => strtotime($record['record_date']),
|
|
'createdAt' => strtotime($record['created_date'])
|
|
];
|
|
if(sizeof($recs) >= 25) {
|
|
$response = LambdaRequest::signedrequest('post', $this->_service, $this->_module.'/import', $recs);
|
|
$recs = [];
|
|
}
|
|
}
|
|
$response = LambdaRequest::signedrequest('post', $this->_service, $this->_module.'/import', $recs);
|
|
return redirect($this->_base_url.'s')->withMessage('Successfully Uploaded !!!');
|
|
} else {
|
|
return \Redirect::back()->withMessage('Some Error occured!');
|
|
}
|
|
}
|
|
}
|