<?php

function store_book_data($data){

    $data_to_store=array(
        'book_inst_id'=>$data['inst_id'],
        'book_inst_type'=>$data['inst_type'],
        'book_category_id'=>char_separated($data['book_category']),
        'book_author_id'=>$data['book_author'],
        'book_rack_id'=>$data['book_rack'],
        'book_language_id'=>$data['book_language'],
        'book_publisher_id'=>$data['book_publisher'],
        'book_code'=>$data['book_code'],
        'book_isbn'=>$data['book_isbn'],
        'book_name'=>$data['book_name'],
        'book_acce_no'=>$data['book_acce_no'],
        'book_price'=>$data['book_price'],
        'book_copy'=>$data['book_copy'],
        'book_available_copy'=>$data['book_copy'],
        'book_description'=>$data['book_description'],
        'book_edition_no'=>$data['book_edition_no'],
        'book_edition_date'=>$data['book_edition_date'],
        'book_created_by'=>$data['user_id'],
        'book_created_at'=>date('Y-m-d')
    );

    $book_id=CI()->lmsbm->store_book_data($data_to_store);

    return $book_id;
}


function update_book_data($data){
    if($data['prev_book_available_copy']){
        $book_available_copy=$data['book_copy']-$data['prev_book_available_copy'];
    }
    $data_to_store=array(
        'book_inst_id'=>$data['inst_id'],
        'book_inst_type'=>$data['inst_type'],
        'book_category_id'=>char_separated($data['book_category']),
        'book_author_id'=>$data['book_author'],
        'book_rack_id'=>$data['book_rack'],
        'book_language_id'=>$data['book_language'],
        'book_publisher_id'=>$data['book_publisher'],
        'book_code'=>$data['book_code'],
        'book_isbn'=>$data['book_isbn'],
        'book_name'=>$data['book_name'],
        'book_acce_no'=>$data['book_acce_no'],
        'book_description'=>$data['book_description'],
        'book_edition_no'=>$data['book_edition_no'],
        'book_edition_date'=>$data['book_edition_date'],
        'book_price'=>$data['book_price'],
        'book_copy'=>$data['book_copy'],
        'book_available_copy'=>$book_available_copy,
        'book_updated_by'=>$data['user_id'],
        'book_updated_at'=>date('Y-m-d'),
    );

    $updated=CI()->lmsbm->update_book_data($data_to_store,array('book_id'=>$data['book_id']));

    return $updated;
}


function _gen_rand_book_code($db_group =null){
	$code_generated = false;
    $unique_code = '';
	$date=date('Ymd');

	$total_books=CI()->lmsbm->get_total_books(null,null,null,$db_group);
		// Generate the unique code
	$unique_code = sprintf("BK%s%07d", $date, $total_books + 1);

	return $unique_code;
}


function gen_rand_book_code() {
    $code_generated = false;
    $unique_code = '';
    $date = date('Ymd');
    
    // Fetch the last book code from the database
    $last_book = CI()->lmsbm->get_last_book(null,null,'book_id'); // Assumes a function that fetches the last book code

    if(!empty($last_book)){
        $last_book_code=$last_book->book_code;
    }else{
        $last_book2 = CI()->lmsbm->get_last_book(array('book_code!='=>''),null,'book_id');
        if(!empty($last_book2)){
            $last_book_code=$last_book2->book_code;
        }else{
            $last_book_code='';
        }
    }
    
    if (!empty($last_book_code)) {
        // Extract the numerical part from the last book code
        preg_match('/BK\d+(\d{7})/', $last_book_code, $matches);
        if (isset($matches[1])) {
            $last_number = intval($matches[1]);
        } else {
            $last_number = 0; // Fallback if regex fails
        }
    } else {
        // If no book code exists, start with 0
        $last_number = 0;
    }

    // Increment the last number by 1
    $new_number = $last_number + 1;

    // Generate the unique code
    $unique_code = sprintf("BK%s%07d", $date, $new_number);

    return $unique_code;
}