public static function exportCsv($data)
{
$type = '';
if (isset($data['csv'])) {
$type = 'csv';
} elseif (isset($data['xls'])) {
$type = 'xls';
} else {
$type = 'xlsx';
}
$csvdata = unserialize(Utilities::simpleDecode($data[$type]));
if ($data['source'] == 'search') {
$csv_array = static::searchCsvData($csvdata);
} elseif ($data['source'] == 'department') {
$csv_array = static::departmentCsvData($csvdata);
} elseif ($data['source'] == 'gender') {
$csv_array = static::genderCsvData($csvdata);
} elseif ($data['source'] == 'states') {
$csv_array = static::statesCsvData($csvdata);
} else {
$csv_array = [];
}
// var_dump($csv_array);
Excel::create('Bingham_ICT_Exported', function ($excel) use($csv_array) {
$excel->sheet('BinghamICT', function ($sheet) use($csv_array) {
$sheet->fromArray($csv_array);
});
})->export($type);
}
public static function sendSMSFromSearch($input)
{
$gsm = '';
if (isset($input['sms_all'])) {
$gsm = $input['sms_all'];
} elseif (isset($input['single'])) {
$gsm = $input['sms_single'];
} elseif (isset($input['parents'])) {
$gsm = $input['sms_parents'];
}
$data = unserialize(Utilities::simpleDecode($gsm));
$data = isset($data['data']) ? $data['data'] : $data;
$idTypes = is_array($data) ? 1 : 2;
$gsm_numbers = '';
if ($idTypes == 1) {
$gsm_numbers = implode(', ', Utilities::prepareGsmArray($data));
} elseif ($idTypes == 2) {
$gsm_numbers = $data;
}
return $gsm_numbers;
}
