esmeromichael

gross_proft:


select sd_headers.dr_type as type, items.description as item_desc, item_categories.name as item_cat, item_subcategories.name as item_sub_cat,
sd_details.qty, case 
	when sd_details.type = 'base' then (SELECT bulk_units.name from bulk_units where bulk_units.id = sd_details.uom)
	ELSE
		(select short from uoms where uoms.id = sd_details.uom)
end as uom, sd_details.price as net_price, sd_details.qty * sd_details.price as sales_price, sd_details.price as cost, 
(sd_details.qty * sd_details.price) - sd_details.price as margin

esmeromichael

select sd_headers.dr_date as date, sd_headers.id as dr_id, partners.name as partner_name, item_categories.name as item_cat, item_subcategories.name as item_sub_cat,
sd_details.price as amount, 
(
	select sum(bill_sub_details.amount) from bill_sub_details
INNER JOIN bill_headers on bill_sub_details.bill_id = bill_headers.id
where bill_headers.status in ('Approved','Printed')
and bill_sub_details.dr_id = sd_details.dr_id
) as bill
 from sd_details

esmeromichael

Teacher: Class if basura ko asa man ko ninyo ilabay, nabubulok o di nabubulok?
Dingdong: ai sa di nabubulok ma’am.
Teacher: ngano man?
Dingdong: ai, alang kay plastic man ka ma’am.

**********   *

Sa Math Class..
Teacher: kung naa koy 1 ka piraso nga karne ug tungaon nako, pila na ka piraso?
Juan: 2 mam!

esmeromichael

$('.add').on('click',function(){
    
    var main_std = $('.std').val();
    var main_min = $('.min').val();
    var main_max = $('.max').val();
    
    <input type="hidden" class="selling_std" name="selling_std[]" value="'+main_std+'"> \
    <input type="hidden" class="selling_min" name="selling_min[]" value="'+main_min+'"> \
    <input type="hidden" class="selling_max" name="selling_max[]" value="'+main_max+'"> \
    

esmeromichael

@extends('layouts.accounting.header')
@section('content')
<style type="text/css">
.select2-container--default .select2-selection--single{
    background-color: #faf2cc;
}
</style>
<section class="container main_section">
<br><br><br><br><br><br><br>
    <div class="flash-message top-message">

esmeromichael

<div class="col-sm-4" style="width: 38.5%;margin-top:-20px;margin-bottom:10px;">
          <div class="btn-group" style="float:right;">
              <label id="text" style="">{{$glpost->attachment_no}}</label>
              <button type="button" id="prev" class="prev btn btn-default" style = "width: 50px;height:25px;margin-right:1px;text-align: center;" onclick="getNext">PREV</button>
              <button type="button" id="next" class="next btn btn-default" style = "width: 50px;height:25px;margin-left:1px;text-align: center;" onclick="getNext">NEXT</button>
          </div>
        </div>

esmeromichael

(1) Toronto Raptors vs. (8) Washington Wizards
GAME	DATE	MATCHUP (TIMES ET)
Game 1	Sat. April 14	Wizards at Raptors, 5:30 (ESPN)
Game 2	Tue. April 17	Wizards at Raptors, 7 (NBA TV)
Game 3	Fri. April 20	Raptors at Wizards, 8 (ESPN2)
Game 4	Sun. April 22	Raptors at Wizards, 6 (TNT)
Game 5*	Wed. April 25	Wizards at Raptors, TBD
Game 6*	Fri. April 27	Raptors at Wizards, TBD
Game 7*	Sun. April 29	Wizards at Raptors, TBD
* if necessary

esmeromichael

SELECT x.order_name1,x.order_name2,x.tin1 as tin1,x.tin2 as tin2,x.tin3 as tin3,x.partner_name,x.last_name,x.first_name,x.middle_name,x.last_name2,x.first_name2,x.middle_name2,x.business_entity,x.partner_id, CONCAT(x.home,' ',x.street,' ',x.brgy) as address1, CONCAT(' ',x.province) as address2,x.postdate, 
				sum(x.nv) as nv,
							sum(x.zr) as zr,
							sum(x.srv) as srv,
							sum(x.cg) as cg,
							sum(x.ocg) as ocg,
							sum(x.vat) as vat, x.partner_id,
							x.branch_id,

esmeromichael

SELECT x.order_name1,x.order_name2,x.tin1 as tin1,x.tin2 as tin2,x.tin3 as tin3,x.partner_name,x.last_name,x.first_name,x.middle_name,x.last_name2,x.first_name2,x.middle_name2,x.business_entity,x.partner_id, CONCAT(x.home,' ',x.street,' ',x.brgy) as address1, CONCAT(' ',x.province) as address2,x.postdate, 
				sum(x.nv) as nv, sum(x.zr) as zr, sum(x.srv) as srv, sum(x.cg) as cg, sum(x.ocg) as ocg, sum(x.vat) as vat, x.partner_id, x.branch_id,
				CONCAT(partner_branches.home,partner_branches.street,barangays.provDesc) as partner_branch_address1,
				CONCAT(cities.provDesc,provinces.provDesc) as partner_branch_address2
		from (
					SELECT p.partner_branch_id as branch_id, part.id as partner_id, part.business_entity as business_entity, part.tin as tin1,
							   part.tin2 as tin2, part.tin3 as tin3, part.name as partner_name, pc.last_name, pc.first_name, pc.middle_name,
								 pc2.last_name as last_name2, pc2.first_name as first_name2, pc2.middle_name as middle_name2, part.home as home,

esmeromichael

11 Comments
Sort by 
Top


Add a comment...

Joy Lapuz Jose · Skyline College
No more mr nice guys on this board!!!!
LETS GO DUBS!!!