"",
'thead_open' => '',
'thead_close' => '',
'heading_row_start' => '',
'heading_row_end' => '
',
'heading_cell_start' => '',
'heading_cell_end' => ' | ',
'tbody_open' => '',
'tbody_close' => '',
'row_start' => '',
'row_end' => '
',
'cell_start' => '',
'cell_end' => ' | ',
'row_alt_start' => '',
'row_alt_end' => '
',
'cell_alt_start' => '',
'cell_alt_end' => ' | ',
'table_close' => '
'
);
public function index() {
$this->load->helper('url');
$data = array();
$this->renderUploadPage('view_dash', $data);
// echo 'Ameye Olu';
}
protected function renderAdminPage($page_name, $data) {
$this->load->view('admin/view_admin_header', $data);
$this->load->view('admin/' . $page_name, $data);
$this->load->view('admin/view_admin_footer', $data);
}
public function getValueOfCardImages() {
return [
'category_id' => trim($this->input->get('card_category')),
'unique_id' => trim($this->input->get('unique_id')),
'from_date' => trim($this->input->get('from_date')),
'to_date' => trim($this->input->get('to_date')),
'catid' => trim($this->input->get('catid'))
];
}
public function setComboForCardImages($params) {
$this->load->model('combo_model');
$combo['card_category'] = $this->combo_model->getCardImageCategoryCombo(
'card_category',
$params['category_id']
);
$combo['catid'] = $this->combo_model->getCardImageCategoryCombo(
'catid',
$params['catid']
);
return $combo;
}
public function validateValueForCardImages($params) {
$this->load->library('form_validation');
$this->form_validation->set_data($params);
$this->setFormRuleForCardImages();
$errors = [];
if ($this->form_validation->run() === FALSE) {
$errors = $this->form_validation->error_array();
}
return $errors;
}
public function setFormRuleForCardImages() {
$date_pattern = 'regex_match[/\d{4}-\d{2}-\d{2}/]';
$this->form_validation->set_rules(
'card_category',
'Category Card',
'numberic'
);
$this->form_validation->set_rules(
'from_added',
'From Added',
$date_pattern
);
$this->form_validation->set_rules(
'to_added',
'To Added',
$date_pattern
);
}
public function load_pagination($all_record, $params, $action) {
$action_hidden = $this->input->get('action_hidden');
if ( isset( $params['category_id'] ) ) {
$category = $params['category_id'];
unset( $params['category_id'] );
$params['card_category'] = $category;
}
// pagination
$this->load->library('pagination');
$config["total_rows"] = count($all_record);
$config["base_url"] = base_url() . "/" . get_class($this) . "/" . $action;
$config["per_page"] = 10;
$config["uri_segment"] = 3;
$config["num_links"] = 5;
$config["suffix"] =
"?action_hidden=${action_hidden}&"
. http_build_query($params);
$config["first_url"] =
"/uploads/{$action}/0?action_hidden=${action_hidden}&"
. http_build_query($params);
$config['full_tag_open'] = "";
$config['num_tag_open'] = '';
$config['num_tag_close'] = '';
$config['cur_tag_open'] = "";
$config['cur_tag_close'] = "";
$config['next_tag_open'] = "";
$config['next_tagl_close'] = "";
$config['prev_tag_open'] = "";
$config['prev_tagl_close'] = "";
$config['first_tag_open'] = "";
$config['first_tagl_close'] = "";
$config['last_tag_open'] = "";
$config['last_tagl_close'] = "";
$this->pagination->initialize($config);
$page = ( $this->uri->segment(3) ) ? $this->uri->segment(3) : 0;
$offset = is_numeric($page) ? $page : 0;
return [
'link' => $this->pagination->create_links(),
'offset' => $offset,
'limit' => $config["per_page"]
];
}
public function cardimages() {
global $savvyext;
$this->load->model('card_image_model');
$data['storage'] = $savvyext->cfgReadChar('system.storage_url');
$data['message'] = "";
if ($this->input->post()) {
$data = $this->cardimagesPost($data);
}
$params = $this->getValueOfCardImages();
$data = array_merge($data, $this->setComboForCardImages($params));
$errors = $this->validateValueForCardImages($params);
$params = array_filter($params, function($ele) {
return $ele !== "";
});
$params = array_diff_key($params, $errors);
$data = array_merge(
$data,
$params,
$this->load_pagination(
$this->card_image_model->get_card_image_records($params),
$params,
'cardimages'
)
);
$data['images'] =
array_map(
function($ele) {
$ele['file_size'] = $this->human_filesize($ele['file_size']);
return $ele;
},
$this->card_image_model->get_card_image_records(
$params,
$data['limit'],
$data['offset']
)
);
// add filter after update card images
$filter = $this->add_filter_after_submit();
if ( ($_SERVER['REQUEST_METHOD'] === 'POST') ) {
redirect( sprintf( '/uploads/cardimages?%s', $filter ) );
}
$this->renderUploadPage( 'cardimages', $data);
}
private function add_filter_after_submit( $http_query = '' ) {
$history = filter_var( $_SERVER['HTTP_REFERER'], FILTER_SANITIZE_URL );
$history = parse_url( $history );
if ( isset( $history['query'] ) ) {
parse_str( $history['query'], $query );
$http_query = http_build_query( $query );
}
return $http_query;
}
private function human_filesize($bytes, $decimals = 2) {
$sz = 'BKMGTP';
$factor = floor((strlen($bytes) - 1) / 3);
return sprintf("%.{$decimals}f", $bytes / pow(1024, $factor)) . @$sz[$factor];
}
public function uploadInterface($data) {
return $this->cardimagesPost($data);
}
private function cardimagesPost($data) {
global $savvyext;
$bucket_name = '';
$catid = (int)$this->input->post('catid');
if ($catid<1) { $data['message'] = 'Please select category'; return $data; }
$q = "SELECT name FROM card_image_category WHERE id='${catid}'";
$r = $this->read_replica->query($q);
foreach ($r->result() as $row) {
$bucket_name = $row->name;
break;
}
if ($bucket_name=='') {
$data['message'] = 'Invalid category';
return $data;
}
// Process file
$imgData = $this->processFile('cardimg', array('jpg'=>1,'jpeg'=>1,'png'=>1,'gif'=>1));
if ($imgData==NULL || !is_array($imgData)) {
$data['message'] = 'Failed to process uploaded image! ('.$imgData.')';
return $data;
}
$this->load->library('googlestorage');
$this->googlestorage->Init(
$savvyext->cfgReadChar('google.storage_project_id'),
$savvyext->cfgReadChar('google.storage_auth_file')
);
$storage = $this->googlestorage;
// Get bucket
$buckets = $storage->ListBuckets();
if (array_key_exists($bucket_name, $buckets)) {
$bucket = $buckets[$bucket_name];
} else {
// Create bucket
$bucket = $storage->CreateBucket($bucket_name);
}
if ($bucket==NULL || !is_object($bucket)) {
$data['message'] = 'Cannot get or create bucket!';
return $data;
}
$total = count($imgData['name']);
// Loop through each file
for ($i = 0 ; $i < $total; $i++) {
$uniqueId = $storage->UniqueId();
$objectName = $uniqueId.".".$imgData['format'][$i];
$source = $imgData['tmp_name'][$i];
$object = $storage->UploadObject($bucket_name, $objectName, $source);
if ($object==NULL || !is_object($object)) {
$data['message'] = 'Failed to upload image!' . $imgData['name'][$i];
break;
} else {
$data['message'] = 'Image uploaded!';
// Save image data
$q = "INSERT INTO card_images (catid, uniqueid, name, file_size, format, dimensions) VALUES(";
$q.= "'${catid}','${uniqueId}','".$imgData['name'][$i]."','".$imgData['file_size'][$i]."','".$imgData['format'][$i]."','".$imgData['dimensions'][$i]."') RETURNING id";
//error_log($q);
$r = $this->db->query($q);
$f = $r->row_array();
$data["card_image_id"][$i] = $f["id"];
}
}
return $data;
}
private function processFile($var, $formats) {
if (!isset($_FILES[$var])) return 'The file was not uploaded!';
if (is_array($_FILES[$var]['error'])) {
foreach ($_FILES[$var]['error'] as $key => $error) {
if ($error != UPLOAD_ERR_OK) {
return $error;
}
}
} else if (isset($_FILES[$var]['error']) && $_FILES[$var]['error'] != UPLOAD_ERR_OK) {
return $_FILES[$var]['error'];
}
$error = $_FILES[$var]['error'];
$name = $_FILES[$var]['name'];
$file_size = $_FILES[$var]['size'];
$tmp_name = $_FILES[$var]['tmp_name'];
// Count # of uploaded files in array
$total = count($_FILES[$var]['name']);
$result_formats = [];
$result_dimensions = [];
// Loop through each file
for ( $i=0 ; $i < $total ; $i++ ) {
$format = strtolower(pathinfo($_FILES[$var]['name'][$i], PATHINFO_EXTENSION));
if (!isset($formats[$format]) || $formats[$format]!=1) {
return 'Invalid file format: '.$format;
}
list($width, $height, $type, $attr) = getimagesize($tmp_name[$i]);
$dimensions = $width . 'x' . $height;
array_push($result_formats, $format);
array_push($result_dimensions, $dimensions);
}
$result = array(
'tmp_name' => $tmp_name,
'name' => $name,
'file_size' => $file_size,
'format' => $result_formats,
'dimensions' => $result_dimensions
);
return $result;
}
}