';
}else{
echo '';
}
?>
|
Contributor's name ".$creator_name." | ";
}else{?>
Statement Date: |
|
| Statement Date: |
|
| Statement Date Range: |
|
| Statement Quarter: |
|
| PRINT PRICE : |
$print_price ;?> |
| ISBN PHYSICAL 13 |
isbn_code ?> |
$details){
echo '
| PRINT PRICE : |
$'.$details['print_price'].' |
| ISBN PHYSICAL 13 |
'.$details['isbn_code'].' |
';
if(isset($details['print_date'])){
echo '| OUT OF PRINT |
'.$details['print_date'].' |
';
}
echo '
| SALES OUTLET |
NET QTY SOLD |
REVENUE |
';
#DIRECT
$net_direct_qty_main = $final_book['main_items'][$book_id]['sales']['calculas']['DIRECT_MARKET_STORES']['qty_sold']+$final_book['main_items'][$book_id]['sales']['calculas']['DIRECT_SHORTAGE_/_DAMAGE']['qty_sold']+$final_book['main_items'][$book_id]['sales']['calculas']['DIRECT_RETURNS']['qty_sold'];
$net_direct_revenue_main = ($final_book['main_items'][$book_id]['sales']['calculas']['DIRECT_MARKET_STORES']['total_cost'])+( $final_book['main_items'][$book_id]['sales']['calculas']['DIRECT_SHORTAGE_/_DAMAGE']['total_cost'])+( $final_book['main_items'][$book_id]['sales']['calculas']['DIRECT_RETURNS']['total_cost']);
if(is_float($net_direct_revenue_main) == false){
$net_direct_qty1_main= floatval($net_direct_revenue_main);
}else{
$net_direct_qty1_main = $net_direct_revenue_main;
}
$net_direct_qty1_main = money_format('%+n', $net_direct_qty1_main);
echo '
| Direct Market Sales |
'.$net_direct_qty_main.' |
'.$net_direct_qty1_main.' |
';
#NON DIRECT
$net_non_dir_qty_main = $final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_MARKET_STORES']['qty_sold']+$final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_SHORTAGE']['qty_sold'];
$net_non_dir_revenue_main = ($final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_MARKET_STORES']['total_cost'])+( $final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_SHORTAGE']['total_cost']);
if(is_float($net_non_dir_revenue_main) == false){
$net_non_dir_revenue1_main= floatval($net_non_dir_revenue_main);
}else{
$net_non_dir_revenue1_main = $net_non_dir_revenue_main;
}
$net_non_dir_revenue1_main = money_format('%+n', $net_non_dir_revenue1_main);
echo '
| Non-Direct Market Sales |
'.$net_non_dir_qty_main.' |
'.$net_non_dir_revenue1_main.' |
';
#RETURNS
$return_qty_main = $final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['qty_sold'];
$return_revenue_main = $final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['unit_retails'] * $final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['qty_sold'] * 3/100 ;
$net_return_main = $final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['unit_retails']*(1-($final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['discount']/100)) * $final_book['main_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['qty_sold'] + $return_revenue_main;
if(is_float($net_return_main) == false){
$return_revenue1_main= floatval($net_return_main);
}else{
$return_revenue1_main = $net_return_main;
}
$return_revenue1_main = money_format('%+n', $return_revenue1_main);
echo '
| Non-Direct Market Returns |
'.$return_qty_main.' |
'.$return_revenue1_main.' |
';
#INTERNATIONAL
$net_internatioal_revenue_main = $final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['unit_retails']*$final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['qty_sold']*(1-($final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['discount']/100))- ($final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['unit_retails']*$final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['qty_sold']*(2.5/100))+($final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['unit_retails']*(1-($final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['discount']/100))*$final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['qty_sold']);
$net_internatioal_qty_main = $final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['qty_sold']+$final_book['main_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['qty_sold'];
if(is_float($net_internatioal_revenue_main) == false){
$net_internatioal_revenue1_main= floatval($net_internatioal_revenue_main);
}else{
$net_internatioal_revenue1_main = $net_internatioal_revenue_main;
}
$net_internatioal_revenue1_main = money_format('%+n', $net_internatioal_revenue1_main);
echo '
| International Sales |
'.$net_internatioal_qty_main.' |
'.$net_internatioal_revenue1_main.' |
';
##DIGITAL
if($final_book['main_items'][$book_id]['sales']['calculas']['digital_sales']!="" && $final_book['main_items'][$book_id]['sales']['calculas']['digital_sales']!=0){
if(is_float($final_book['main_items'][$book_id]['sales']['calculas']['digital_sales']) == false){
$digi_sales_main= floatval($final_book['main_items'][$book_id]['sales']['calculas']['digital_sales']);
}else{
$digi_sales_main = $final_book['main_items'][$book_id]['sales']['calculas']['digital_sales'];
}
echo '
| Digital Sales |
'.$final_book['main_items'][$book_id]['sales']['calculas']['digital_qty'].' |
'.money_format('%+n', $digi_sales_main).' |
';
}
##RETAILS : ONI PRESS
if(is_float($final_book['main_items'][$book_id]['sales']['calculas']['oni_sales']) == false){
$oni__sales_main= floatval($final_book['main_items'][$book_id]['sales']['calculas']['oni_sales']);
}else{
$oni__sales_main = $final_book['main_items'][$book_id]['sales']['calculas']['oni_sales'];
}
echo '
| Retail (Oni Press) |
'.$final_book['main_items'][$book_id]['sales']['calculas']['oni_qty'].' |
'.money_format('%+n', $oni__sales_main).' |
';
##ss Sales
if(is_float($final_book['main_items'][$book_id]['sales']['calculas']['ss_sales']) == false){
$ss__sales_main= floatval($final_book['main_items'][$book_id]['sales']['calculas']['ss_sales']);
}else{
$ss__sales_main = $final_book['main_items'][$book_id]['sales']['calculas']['ss_sales'];
}
echo '
| Simon & Schuster Sales |
'.$final_book['main_items'][$book_id]['sales']['calculas']['ss_qty'].' |
'.money_format('%+n', $ss__sales_main).' |
';
##TOTAL
$gross_sales_main = $net_return_main+$net_non_dir_revenue_main+$net_direct_revenue_main+$net_internatioal_revenue_main+$final_book['main_items'][$book_id]['sales']['calculas']['digital_sales']+$final_book['main_items'][$book_id]['sales']['calculas']['oni_sales']+$final_book['main_items'][$book_id]['sales']['calculas']['ss_sales'];
$total_qty_main = $net_direct_qty_main+$net_non_dir_qty_main+$return_qty_main+$net_internatioal_qty_main+$final_book['main_items'][$book_id]['sales']['calculas']['digital_qty']+$final_book['main_items'][$book_id]['sales']['calculas']['oni_qty']+$final_book['main_items'][$book_id]['sales']['calculas']['ss_qty'];
if(is_float($gross_sales_main) == false){
$gross_sales_val_main= floatval($gross_sales_main);
}else{
$gross_sales_val_main = $gross_sales_main;
}
$gross_sales_value_main = money_format('%+n', $gross_sales_val_main);
echo '
| Total |
'.$total_qty_main.' |
'.$gross_sales_value_main.' |
';
########CONTAINED ITEMS ONLY LIST AND TOTAL REVENUW#######
$contained_gross_sales = array();#contains the gross sale of the contained items
if(isset($details['sub_title'])){
echo '
';
echo '
| BOOK TITLE |
NET QTY SOLD |
REVENUE |
';
foreach($details['sub_title'] as $sub){
if(!isset($sub['container_sales'])){continue;}
#quantity
$net_direct_qty_contnd = $sub['container_sales']['calculas']['DIRECT_MARKET_STORES']['qty_sold']+$sub['container_sales']['calculas']['DIRECT_SHORTAGE_/_DAMAGE']['qty_sold']+$sub['container_sales']['calculas']['DIRECT_RETURNS']['qty_sold'];
$net_non_dir_qty_contnd = $sub['container_sales']['calculas']['NON-DIRECT_MARKET_STORES']['qty_sold']+$sub['container_sales']['calculas']['NON-DIRECT_SHORTAGE']['qty_sold'];
$return_qty_contnd = $sub['container_sales']['calculas']['NON-DIRECT_RETURNS']['qty_sold'];
$net_internatioal_qty_contnd = $sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['qty_sold']+$sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['qty_sold'];
$total_qty_contnd = $net_direct_qty_contnd+$net_non_dir_qty_contnd+$return_qty_contnd+$net_internatioal_qty_contnd+$sub['container_sales']['calculas']['digital_qty']+$sub['container_sales']['calculas']['oni_qty']+$sub['container_sales']['calculas']['ss_qty'];
#total revenue
$net_direct_revenue_contnd = ($sub['container_sales']['calculas']['DIRECT_MARKET_STORES']['total_cost'])+( $sub['container_sales']['calculas']['DIRECT_SHORTAGE_/_DAMAGE']['total_cost'])+( $sub['container_sales']['calculas']['DIRECT_RETURNS']['total_cost']);
$net_non_dir_revenue_contnd = ($sub['container_sales']['calculas']['NON-DIRECT_MARKET_STORES']['total_cost'])+( $sub['container_sales']['calculas']['NON-DIRECT_SHORTAGE']['total_cost']);
$return_revenue_contnd = $sub['container_sales']['calculas']['NON-DIRECT_RETURNS']['unit_retails'] * $sub['container_sales']['calculas']['NON-DIRECT_RETURNS']['qty_sold'] * 3/100 ;
$net_return_contnd = $sub['container_sales']['calculas']['NON-DIRECT_RETURNS']['unit_retails']*(1-($sub['container_sales']['calculas']['NON-DIRECT_RETURNS']['discount']/100)) * $sub['container_sales']['calculas']['NON-DIRECT_RETURNS']['qty_sold'] + $return_revenue_contnd;
$net_internatioal_revenue_contnd = $sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['unit_retails']*$sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['qty_sold']*(1-($sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['discount']/100))- ($sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['unit_retails']*$sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['qty_sold']*(2.5/100))+($sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['unit_retails']*(1-($sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['discount']/100))*$sub['container_sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['qty_sold']);
$gross_sales_contnd = $net_return_contnd+$net_non_dir_revenue_contnd+$net_direct_revenue_contnd+$net_internatioal_revenue_contnd+$sub['container_sales']['calculas']['digital_sales']+$sub['container_sales']['calculas']['oni_sales']+$sub['container_sales']['calculas']['ss_sales'];
if(is_float($gross_sales_contnd) == false){
$gross_sales_contnd_1= floatval($gross_sales_contnd);
}else{
$gross_sales_contnd_1 = $gross_sales_contnd;
}
$gross_sales_contnd_FIN = money_format('%+n', $gross_sales_contnd_1);
echo
'
| '.$sub['container_name'].' |
'.$total_qty_contnd.' |
'.$gross_sales_contnd_FIN.' |
';
$contained_gross_sales[] = $gross_sales_contnd;
}
#total of the contained items
if(is_float(array_sum($contained_gross_sales)) == false){
$contained_gross_sales_1= floatval(array_sum($contained_gross_sales));
}else{
$contained_gross_sales_1 = array_sum($contained_gross_sales);
}
$contained_gross_sales_FIN = money_format('%+n', $contained_gross_sales_1);
echo
'
| Contained Items Total
|
'.$contained_gross_sales_FIN.'
|
';
echo '
';
}
#collecting name and quarter expense in main_quarter array
if($selected_quarter == 1){
$main_quarter[$book_id][]= array(
$final_book['main_items'][$book_id]['title'],
$final_book['main_items'][$book_id]['sales']['book_details']['expense']['first_quarter']
);
$this_quarter = '1st Quarter (Jan-March)';
}
if($selected_quarter == 2){
$main_quarter[$book_id][]= array(
$final_book['main_items'][$book_id]['title'],
$final_book['main_items'][$book_id]['sales']['book_details']['expense']['second_quarter']
);
$this_quarter = '2nd Quarter (Apr-June)';
}
if($selected_quarter == 3){
$main_quarter[$book_id][]= array(
$final_book['main_items'][$book_id]['title'],
$final_book['main_items'][$book_id]['sales']['book_details']['expense']['third_quarter']
);
$this_quarter = '3rd Quarter (July-Sept)';
}
if($selected_quarter == 4){
$main_quarter[$book_id][]= array(
$final_book['main_items'][$book_id]['title'],
$final_book['main_items'][$book_id]['sales']['book_details']['expense']['fourth_quarter']
);
$this_quarter = '4th Quarter (Oct-Dec)';
}
if($selected_quarter == 5) {
$all_qtr_val = array(); //not used
$all_qtr_sum =0;
foreach($qtrs_val as $qtr){
if($qtr == 1){
//$all_qtr_val[]= +$more_singledet['first_quarter'];
$all_qtr_sum +=$final_book['main_items'][$book_id]['sales']['book_details']['expense']['first_quarter'];
}
if($qtr == 2){
//$all_qtr_val[]= +$more_singledet['second_quarter'];
$all_qtr_sum +=$final_book['main_items'][$book_id]['sales']['book_details']['expense']['second_quarter'];
}
if($qtr == 3){
//$all_qtr_val[]= +$more_singledet['third_quarter'];
$all_qtr_sum +=$final_book['main_items'][$book_id]['sales']['book_details']['expense']['third_quarter'];
}
if($qtr == 4){
//$all_qtr_val[]= +$more_singledet['fourth_quarter'];
$all_qtr_sum +=$final_book['main_items'][$book_id]['sales']['book_details']['expense']['fourth_quarter'];
}
}
$main_quarter[$book_id][]= array(
$final_book['main_items'][$book_id]['title'],
$all_qtr_sum
);
$this_quarter = 'CUSTOM QUARTER ('.$month_name1.'-'.$month_name2.')';
}
echo '
| QUALIFIED EXPENSES, '.$this_quarter.' |
| BOOK TITLE |
AMOUNT |
';
foreach($main_quarter[$book_id] as $t_q){
echo"";
foreach($t_q as $t){
//if no quarter value
if($t==""){
$sum = $t;
echo'| $0 | ';
}else{
if(is_numeric($t)){
if(is_float($t) == false){
$t_val= floatval($t);
}else{
$t_val = $t;
}
$t_val_value = money_format('%+n', $t_val);
echo'' .$t_val_value.' | ';
$sum = $t;
}else{
echo'' .$t.' | ';
}
}
}
echo "
";
}
echo '
';
#total expense
if(is_float($sum) == false){
$sum_float= floatval($sum);
}else{
$sum_float = $sum;
}
$sumvalue = money_format('%+n', $sum_float);
#GROSS SALES
#being used in calculations
$gross_sales_main_net = $gross_sales_main+array_sum($contained_gross_sales);
#visible on report
$gross_sales_main=$gross_sales_main;
if(is_float($gross_sales_main) == false){
$gross_sales_val_main= floatval($gross_sales_main);
}else{
$gross_sales_val_main = $gross_sales_main;
}
$gross_sales_value_main = money_format('%+n', $gross_sales_val_main);
##TOTAL PROFIT
if($royalty_choice[$book_id] == 1 || $royalty_choice[$book_id] == NULL){
$total_profit_main = $gross_sales_main_net-$sum;
}
if($royalty_choice[$book_id] == 2){
$total_profit_main = $gross_sales_main_net;
}
if($royalty_choice[$book_id] == 3){
$total_profit_main = $gross_sales_main_net-$sum;
}
if(is_float($total_profit_main) == false){
$total_profit_val_main= floatval($total_profit_main);
}else{
$total_profit_val_main = $total_profit_main;
}
$total_profit_value_main = money_format('%+n', $total_profit_val_main);
##ADVANCE
$advances_main = abs(array_sum($amount_current_quarter[$book_id]));
if(is_float($advances_main) == false){
$advances_val_main= floatval($advances_main);
}else{
$advances_val_main = $advances_main;
}
$advances_value_main = money_format('%+n', $advances_val_main);
#CONTRIBUTORS VALUE
#contributor's portion of profit value
$divide_by_val_main = array_sum($percentage_Array[$book_id]);
#royalty choice checks : if choice is net/cover price
if($royalty_choice[$book_id] == 1 || $royalty_choice[$book_id] == NULL){
$contri_share_main = $total_profit_main*$divide_by_val_main/100;
}
#royalty choice checks : if choice is gross
if($royalty_choice[$book_id] == 2){
$contri_share_main = $total_profit_main;
}
#royalty choice checks : if choice is cover price
if($royalty_choice[$book_id] == 3){
$contri_share_main = $print_price[$book_id]*$total_qty_main*$divide_by_val_main/100;
}
if(is_float($contri_share_main) == false){
$contri_share_val_main= floatval($contri_share_main);
}else{
$contri_share_val_main = $contri_share_main;
}
$contri_share_value_main = money_format('%+n', $contri_share_val_main);
##PROFIT DUE : contributor's share (total profit's 50%) - total advance given to the book
#royalty choice checks : if choice is net/cover price
if($royalty_choice[$book_id] == 1 || $royalty_choice[$book_id] == NULL ||$royalty_choice[$book_id] == 3){
$profit_due_main = $contri_share_main - $advances_main;
}
#royalty choice checks : if choice is gross
if($royalty_choice[$book_id] == 2){
$profit_due_main = ($contri_share_main * ($divide_by_val_main /100))-$advances_main;
}
if(is_float($profit_due_main) == false){
$profit_due_val_main= floatval($profit_due_main);
}else{
$profit_due_val_main = $profit_due_main;
}
$profit_due_value_main = money_format('%+n', $profit_due_val_main);
echo '
| TOTAL QTY MAIN: |
'.$total_qty_main.' |
| GROSS SALES: |
'.$gross_sales_value_main.' |
';
if(isset($contained_gross_sales_FIN)){
echo '
| CONTAINED ITEMS TOTAL: |
'.$contained_gross_sales_FIN.' |
';
}
echo '
| EXPENSES TOTAL: |
'.$sumvalue.' |
';
echo'
| NET INCOME THIS QTR: |
'.$total_profit_value_main.' |
| TOTAL ADVANCE/BALANCE PREVIOUS QTR: |
'.$advances_value_main.' |
| CONTRIBUTORS PORTION (50%): |
'.$contri_share_value_main.' |
';
#layout for only contributor's report
if(\Session::get('login_type') == 2){
if(isset($contri_info[$book_id])){
foreach($contri_info[$book_id] as $contri_id => $values){
$manage_pay_main = array_sum($values['percentage']);
//total
if($divide_by_val_main == 0){
$contri_amount_main = $profit_due_val_main * 0;
}else{
$contri_amount_main = $profit_due_val_main * ($manage_pay_main/$divide_by_val_main);
}
if(is_float($contri_amount_main) == false){
$contri_amount_val_main= floatval($contri_amount_main);
}else{
$contri_amount_val_main = $contri_amount_main;
}
$contri_amount_value_main = money_format('%+n', $contri_amount_val_main);
}
}
echo '
| CONTRIBUTOR EARNINGS THIS QUARTER ('.$manage_pay_main.'%): |
'.$contri_amount_value_main.' |
';
}else{
echo '
| CONTRIBUTOR EARNINGS THIS QUARTER: |
'.$profit_due_value_main.' |
';
}
echo '
';
##CONTRIBUTOR'S DUE
if($div_books == $books_count && $div_books!=0){
$class_given = "no_break_summary";
}elseif($div_books != $books_count && $div_books==0){
$class_given = "sale_summary";
}elseif($div_books == $books_count && $div_books==0){
$class_given = "no_break_summary";
}
if(isset($contri_info[$book_id])){
echo
'
';
echo
'
| NAME |
PERCENTAGE |
ROYALTY DUE |
PREVIOUS QUARTER ADVANCE BALANCE |
CURRENT QUARTER ADVANCE BALANCE/ROYALTY DUE |
';
foreach($contri_info[$book_id] as $contri_id => $values){
echo "";
#royalty choice checks : if choice is net/cover price
$manage_pay_main = array_sum($values['percentage']);
if($divide_by_val_main == 0){
$contri_amount_main = $profit_due_val_main * 0;
}else{
$contri_amount_main = $profit_due_val_main * ($manage_pay_main/$divide_by_val_main);
}
if(is_float($contri_amount_main) == false){
$contri_amount_val_main= floatval($contri_amount_main);
}else{
$contri_amount_val_main = $contri_amount_main;
}
$contri_amount_value_main = money_format('%+n', $contri_amount_val_main);
#previous qtr
if(isset($previous_quarter[$contri_id][$book_id])){
$prev_value_main = $previous_quarter[$contri_id][$book_id] ;
if($prev_value_main < 0){
$prev_value_main = $prev_value_main;
}else{
$prev_value_main = 0;
}
}else{
$prev_value_main = 0;
}
##previous quarter share
if(is_float($prev_value_main) == false){
$prev_amount_val_main= floatval($prev_value_main);
}else{
$prev_amount_val_main = $prev_value_main;
}
$previous_amount_value_main = money_format('%+n', $prev_amount_val_main);
##final value i.e. : current share + previous share
$final_share_main = $contri_amount_main+$prev_value_main;
if(is_float($final_share_main) == false){
$final_share_val_main= floatval($final_share_main);
}else{
$final_share_val_main = $final_share_main;
}
$final_share_value_main = money_format('%+n', $final_share_val_main);
##html
echo '| '.$values['name'].' | '.array_sum($values['percentage']).'% | '.$contri_amount_value_main.' | '.$previous_amount_value_main.' | '.$final_share_value_main.' | ';
echo '
';
}
echo'
';
}#check for contributors consistence
$div_books++;
}#main foreach ends here
} #main isset
?>
$details){
echo'
';
echo '
| Book Title |
'.$details['title'].' |
';
if(is_float($details['print_price']) == false){
$c_print_pr= floatval($details['print_price']);
}else{
$c_print_pr = $details['print_price'];
}
$c_print_pr_fin = money_format('%+n', $c_print_pr);
if(is_float($details['digital_price']) == false){
$c_digi_pr= floatval($details['digital_price']);
}else{
$c_digi_pr = $details['digital_price'];
}
$c_digi_pr_fin = money_format('%+n', $c_digi_pr);
echo '
| Print Price |
'.$c_print_pr_fin.' |
| Digital Price |
'.$c_digi_pr_fin.' |
';
if(!empty($details['isbn_code'])){
echo '
| ISBN Physical 13 |
'.$details['isbn_code'].' |
';
}
echo '
';
echo '
| SALES OUTLET |
NET QTY SOLD |
REVENUE |
';
##direct
$net_direct_qty = $final_book['contained_items'][$book_id]['sales']['calculas']['DIRECT_MARKET_STORES']['qty_sold']+$final_book['contained_items'][$book_id]['sales']['calculas']['DIRECT_SHORTAGE_/_DAMAGE']['qty_sold']+$final_book['contained_items'][$book_id]['sales']['calculas']['DIRECT_RETURNS']['qty_sold'];
$net_direct_revenue = ($final_book['contained_items'][$book_id]['sales']['calculas']['DIRECT_MARKET_STORES']['total_cost'])+( $final_book['contained_items'][$book_id]['sales']['calculas']['DIRECT_SHORTAGE_/_DAMAGE']['total_cost'])+( $final_book['contained_items'][$book_id]['sales']['calculas']['DIRECT_RETURNS']['total_cost']);
if(is_float($net_direct_revenue) == false){
$net_direct_qty1= floatval($net_direct_revenue);
}else{
$net_direct_qty1 = $net_direct_revenue;
}
$net_direct_qty1 = money_format('%+n', $net_direct_qty1);
echo '
| Direct Market Sales |
'.$net_direct_qty.' |
'.$net_direct_qty1.' |
';
##NON DIRECT
$net_non_dir_qty = $final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_MARKET_STORES']['qty_sold']+$final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_SHORTAGE']['qty_sold'];
$net_non_dir_revenue = ($final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_MARKET_STORES']['total_cost'])+( $final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_SHORTAGE']['total_cost']);
if(is_float($net_non_dir_revenue) == false){
$net_non_dir_revenue1= floatval($net_non_dir_revenue);
}else{
$net_non_dir_revenue1 = $net_non_dir_revenue;
}
$net_non_dir_revenue1 = money_format('%+n', $net_non_dir_revenue1);
echo '
| Non-Direct Market Sales |
'.$net_non_dir_qty.' |
'.$net_non_dir_revenue1.' |
';
##returns
$return_qty = $final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['qty_sold'];
$return_revenue = $final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['unit_retails'] * $final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['qty_sold'] * 3/100 ;
$net_return = $final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['unit_retails']*(1-($final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['discount']/100)) * $final_book['contained_items'][$book_id]['sales']['calculas']['NON-DIRECT_RETURNS']['qty_sold'] + $return_revenue;
if(is_float($net_return) == false){
$return_revenue1= floatval($net_return);
}else{
$return_revenue1 = $net_return;
}
$return_revenue1 = money_format('%+n', $return_revenue1);
echo '
| Non-Direct Market Returns |
'.$return_qty.' |
'.$return_revenue1.' |
';
##international
$net_internatioal_revenue = $final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['unit_retails']*$final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['qty_sold']*(1-($final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['discount']/100))- ($final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['unit_retails']*$final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['qty_sold']*(2.5/100))+($final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['unit_retails']*(1-($final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['discount']/100))*$final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['qty_sold']);
$net_internatioal_qty = $final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_STORES']['qty_sold']+$final_book['contained_items'][$book_id]['sales']['calculas']['INTERNATIONAL_NON-DIRECT_MARKET_SHORTAGES']['qty_sold'];
if(is_float($net_internatioal_revenue) == false){
$net_internatioal_revenue1= floatval($net_internatioal_revenue);
}else{
$net_internatioal_revenue1 = $net_internatioal_revenue;
}
$net_internatioal_revenue1 = money_format('%+n', $net_internatioal_revenue1);
echo '
| International Sales |
'.$net_internatioal_qty.' |
'.$net_internatioal_revenue1.' |
';
##digital
if($final_book['contained_items'][$book_id]['sales']['calculas']['digital_qty'] != "" && $final_book['contained_items'][$book_id]['sales']['calculas']['digital_qty']!=0){
if(is_float($final_book['contained_items'][$book_id]['sales']['calculas']['digital_sales']) == false){
$digi_sales= floatval($final_book['contained_items'][$book_id]['sales']['calculas']['digital_sales']);
}else{
$digi_sales = $final_book['contained_items'][$book_id]['sales']['calculas']['digital_sales'];
}
echo '
| Digital Sales |
'.$final_book['contained_items'][$book_id]['sales']['calculas']['digital_qty'].' |
'.money_format('%+n', $digi_sales).' |
';
}
##Oni sales
if(is_float($final_book['contained_items'][$book_id]['sales']['calculas']['oni_sales']) == false){
$oni__sales= floatval($final_book['contained_items'][$book_id]['sales']['calculas']['oni_sales']);
}else{
$oni__sales = $final_book['contained_items'][$book_id]['sales']['calculas']['oni_sales'];
}
echo '
| Oni Sales |
'.$final_book['contained_items'][$book_id]['sales']['calculas']['oni_qty'].' |
'.money_format('%+n', $oni__sales).' |
';
## s & s sales
if(is_float($final_book['contained_items'][$book_id]['sales']['calculas']['ss_sales']) == false){
$ss__sales= floatval($final_book['contained_items'][$book_id]['sales']['calculas']['ss_sales']);
}else{
$ss__sales = $final_book['contained_items'][$book_id]['sales']['calculas']['ss_sales'];
}
echo '
| Simon & Schuster Sales |
'.$final_book['contained_items'][$book_id]['sales']['calculas']['ss_qty'].' |
'.money_format('%+n', $ss__sales).' |
';
##TOTALS
$gross_sales = $net_return+$net_non_dir_revenue+$net_direct_revenue+$net_internatioal_revenue+$final_book['contained_items'][$book_id]['sales']['calculas']['digital_sales']+$final_book['contained_items'][$book_id]['sales']['calculas']['oni_sales']+$final_book['contained_items'][$book_id]['sales']['calculas']['ss_sales'];
if(is_float($gross_sales) == false){
$gross_sales_val= floatval($gross_sales);
}else{
$gross_sales_val = $gross_sales;
}
$gross_sales_value = money_format('%+n', $gross_sales_val);
$total_qty = $net_direct_qty+$net_non_dir_qty+$return_qty+$net_internatioal_qty+$final_book['contained_items'][$book_id]['sales']['calculas']['digital_qty']+$final_book['contained_items'][$book_id]['sales']['calculas']['oni_qty']+$final_book['contained_items'][$book_id]['sales']['calculas']['ss_qty'];
echo '
| Total |
'.$total_qty.' |
'.money_format('%+n', $gross_sales).' |
';
echo'
';
##EXPENSES
if($selected_quarter == 1){
$main_quarter[$book_id][]= array(
$final_book['contained_items'][$book_id]['title'],
$final_book['contained_items'][$book_id]['sales']['book_details']['expense']['first_quarter']
);
$this_quarter = '1st Quarter (Jan-March)';
}
if($selected_quarter == 2){
$main_quarter[$book_id][]= array(
$final_book['contained_items'][$book_id]['title'],
$final_book['contained_items'][$book_id]['sales']['book_details']['expense']['second_quarter']
);
$this_quarter = '2nd Quarter (Apr-June)';
}
if($selected_quarter == 3){
$main_quarter[$book_id][]= array(
$final_book['contained_items'][$book_id]['title'],
$final_book['contained_items'][$book_id]['sales']['book_details']['expense']['third_quarter']
);
$this_quarter = '3rd Quarter (July-Sept)';
}
if($selected_quarter == 4){
$main_quarter[$book_id][]= array(
$final_book['contained_items'][$book_id]['title'],
$final_book['contained_items'][$book_id]['sales']['book_details']['expense']['fourth_quarter']
);
$this_quarter = '4th Quarter (Oct-Dec)';
}
if($selected_quarter == 5) {
$all_qtr_val = array(); //not used
$all_qtr_sum =0;
foreach($qtrs_val as $qtr){
if($qtr == 1){
//$all_qtr_val[]= +$more_singledet['first_quarter'];
$all_qtr_sum +=$final_book['contained_items'][$book_id]['sales']['book_details']['expense']['first_quarter'];
}
if($qtr == 2){
//$all_qtr_val[]= +$more_singledet['second_quarter'];
$all_qtr_sum +=$final_book['contained_items'][$book_id]['sales']['book_details']['expense']['second_quarter'];
}
if($qtr == 3){
//$all_qtr_val[]= +$more_singledet['third_quarter'];
$all_qtr_sum +=$final_book['contained_items'][$book_id]['sales']['book_details']['expense']['third_quarter'];
}
if($qtr == 4){
//$all_qtr_val[]= +$more_singledet['fourth_quarter'];
$all_qtr_sum +=$final_book['contained_items'][$book_id]['sales']['book_details']['expense']['fourth_quarter'];
}
}
$main_quarter[$book_id][]= array(
$final_book['contained_items'][$book_id]['title'],
$all_qtr_sum
);
$this_quarter = 'CUSTOM QUARTER ('.$month_name1.'-'.$month_name2.')';
}
echo '
| QUALIFIED EXPENSES, '.$this_quarter.' |
| BOOK TITLE |
AMOUNT |
';
foreach($main_quarter[$book_id] as $t_q){
echo"";
foreach($t_q as $t){
//if no quarter value
if($t==""){
$sum = $t;
echo'| $0 | ';
}else{
if(is_numeric($t)){
if(is_float($t) == false){
$t_val= floatval($t);
}else{
$t_val = $t;
}
$t_val_value = money_format('%+n', $t_val);
echo'' .$t_val_value.' | ';
$sum = $t;
}else{
echo'' .$t.' | ';
}
}
}
echo "
";
}
echo '
';
#total expense
if(is_float($sum) == false){
$sum_float= floatval($sum);
}else{
$sum_float = $sum;
}
$sumvalue = money_format('%+n', $sum_float);
#GROSS SALE
if(is_float($gross_sales) == false){
$gross_sales_val= floatval($gross_sales);
}else{
$gross_sales_val = $gross_sales;
}
$gross_sales_value = money_format('%+n', $gross_sales_val);
##TOTAL PROFIT
if($royalty_choice[$book_id] == 1 || $royalty_choice[$book_id] == NULL){
$total_profit = $gross_sales_val-$sum;
}
if($royalty_choice[$book_id] == 2){
$total_profit = $gross_sales_val;
}
if($royalty_choice[$book_id] == 3){
$total_profit = $gross_sales_val-$sum;
}
if(is_float($total_profit) == false){
$total_profit_val= floatval($total_profit);
}else{
$total_profit_val = $total_profit;
}
$total_profit_value = money_format('%+n', $total_profit_val);
##TOTAL ADVANCE
$advances = abs(array_sum($amount_current_quarter[$book_id]));
if(is_float($advances) == false){
$advances_val= floatval($advances);
}else{
$advances_val = $advances;
}
$advances_value = money_format('%+n', $advances_val);
#contributor's portion of profit value
$divide_by_val = array_sum($percentage_Array[$book_id]);
#royalty choice checks : if choice is net/cover price
if($royalty_choice[$book_id] == 1 || $royalty_choice[$book_id] == NULL){
$contri_share = $total_profit*$divide_by_val/100;
}
#royalty choice checks : if choice is gross
if($royalty_choice[$book_id] == 2){
$contri_share = $total_profit;
}
#royalty choice checks : if choice is cover price
if($royalty_choice[$book_id] == 3){
$contri_share = $print_price[$book_id]*$total_qty*$divide_by_val/100;
}
if(is_float($contri_share) == false){
$contri_share_val= floatval($contri_share);
}else{
$contri_share_val = $contri_share;
}
$contri_share_value = money_format('%+n', $contri_share_val);
#royalty choice checks : if choice is net/cover price
if($royalty_choice[$book_id] == 1 || $royalty_choice[$book_id] == NULL ||$royalty_choice[$book_id] == 3){
$profit_due = $contri_share - $advances;
}
#royalty choice checks : if choice is gross
if($royalty_choice[$book_id] == 2){
$profit_due = ($contri_share * ($divide_by_val /100))-$advances;
}
if(is_float($profit_due) == false){
$profit_due_val= floatval($profit_due);
}else{
$profit_due_val = $profit_due;
}
$profit_due_value = money_format('%+n', $profit_due_val);
echo '
| TOTAL QTY: |
'.$total_qty.' |
| GROSS SALES: |
'.$gross_sales_value.' |
| EXPENSES TOTAL: |
'.$sumvalue.' |
| NET INCOME THIS QTR: |
'.$total_profit_value.' |
| TOTAL ADVANCE/BALANCE PREVIOUS QTR: |
'.$advances_value.' |
| CONTRIBUTORS PORTION (50%): |
'.$contri_share_value.' |
';
if(\Session::get('login_type') == 2){
foreach($contri_info[$book_id] as $contri_id => $values){
#royalty choice checks : if choice is net/cover price
$manage_pay = array_sum($values['percentage']);
if($divide_by_val == 0){
$contri_amount = $profit_due_val * 0;
}else{
$contri_amount = $profit_due_val * ($manage_pay/$divide_by_val);
}
if(is_float($contri_amount) == false){
$contri_amount_val= floatval($contri_amount);
}else{
$contri_amount_val = $contri_amount;
}
$contri_amount_value = money_format('%+n', $contri_amount_val);
}
echo '
| CONTRIBUTOR EARNINGS THIS QUARTER ('.$manage_pay.'%): |
'.$contri_amount_value.' |
';
}else{
echo'
| CONTRIBUTOR EARNINGS THIS QUARTER: |
'.$profit_due_value.' |
';
}
echo '
';
##CONTRI DUE
if($div_books == $books_count && $div_books!=0){
$class_given = "no_break_summary";
}elseif($div_books != $books_count && $div_books==0){
$class_given = "sale_summary";
}elseif($div_books == $books_count && $div_books==0){
$class_given = "no_break_summary";
}
echo '
';
echo
'
| NAME |
PERCENTAGE |
ROYALTY DUE |
CURRENT QUARTER ADVANCE
BALANCE/ROYALTY DUE |
';
foreach($contri_info[$book_id] as $contri_id => $values){
echo "";
#royalty choice checks : if choice is net/cover price
$manage_pay = array_sum($values['percentage']);
if($divide_by_val == 0){
$contri_amount = $profit_due_val * 0;
}else{
$contri_amount = $profit_due_val * ($manage_pay/$divide_by_val);
}
if(is_float($contri_amount) == false){
$contri_amount_val= floatval($contri_amount);
}else{
$contri_amount_val = $contri_amount;
}
$contri_amount_value = money_format('%+n', $contri_amount_val);
##final value i.e. : current share + previous share
$final_share = $contri_amount;
if(is_float($final_share) == false){
$final_share_val= floatval($final_share);
}else{
$final_share_val = $final_share;
}
$final_share_value = money_format('%+n', $final_share_val);
##html
echo '| '.$values['name'].' | '.array_sum($values['percentage']).'% | '.$contri_amount_value.' | '.$final_share_value.' | ';
echo "
";
}#advance foreach
echo '
';
$div_books++;
}#contained items foreach
}#checking if container exists ends here
?>