session_start(); mysql_connect ("localhost", "mediatec_quote", "tech1020") or die ("unable to connect"); mysql_select_db ('mediatec_pricing'); ///global variables $type = $_POST['type']; $quantity = $_POST['quantity']; $packaging = $_POST['styles']; $printing = $_POST['printing']; $wrap = $_POST['wrap']; $inserts = $_POST['inserts']; $transfer = $_POST['transfer']; //////////replication if (isset ($quantity)) { $qty_value = $quantity; $qty_desc = $quantity; } else { $qty_value = NULL; $qty_desc = "Select"; } ////////////////////// $result = mysql_query ("SELECT * FROM replicationpricing WHERE quantity = '$quantity'"); $row = mysql_fetch_array($result); switch ($type) { case "dvd5": $typ = $row['dvd5']; $type_value = "dvd5"; $type_desc = "DVD 5"; break; case "dvd9": $typ = $row['dvd9']; $type_value = "dvd9"; $type_desc = "DVD 9"; break; case "dvd10": $typ = $row['dvd10']; $type_value = "dvd10"; $type_desc = "DVD 10"; break; default: //$typ = $row['dvd5']; $type_value = 'NULL'; $type_desc = "Select"; break; } $unitcost = ($typ*$quantity); ////////////////////film $result = mysql_query ("SELECT fo FROM replicationextras"); $row = mysql_fetch_array($result); switch ($printing) { case "None": $prn_value = "None"; $prn_desc = "No Printing"; break; case "c1": $prn = $row['fo']; $prn_value = "c1"; $prn_val = 1; $prn_desc = "1 Color"; break; case "c2": $prn = $row['fo']; $prn_value = "c2"; $prn_val = 2; $prn_desc = "2 Color"; break; case "c3": $prn = $row['fo']; $prn_value = "c3"; $prn_val = 3; $prn_desc = "3 Color"; break; case "c4": $prn = $row['fo']; $prn_value = "c4"; $prn_val = 4; $prn_desc = "4 Color"; break; case "c5": $prn = $row['fo']; $prn_value = "c5"; $prn_val = 5; $prn_desc = "5 Color"; break; default: $prn_value = "None"; $prn_desc = "No Printing"; break; } $filmcost = ($prn*$prn_val); //////////packaging $result = mysql_query ("SELECT * FROM replicationpackaging WHERE quantity LIKE '$quantity'"); $row = mysql_fetch_array($result); switch ($packaging) { case "None": $pkg_value = "None"; $pkg_desc = "No Packaging"; break; case "ac": $pkg = $row['ac']; $pkg_value = "ac"; $pkg_desc = "Amaray Case "; break; case "da": $pkg = $row['da']; $pkg_value = "da"; $pkg_desc = "Dual Amaray Case"; break; case "jc": $pkg = $row['jc']; $pkg_value = "jc"; $pkg_desc = "Standard JC "; break; case "sc": $pkg = $row['jc']; $pkg_value = "jc"; $pkg_desc = "Slim JC "; break; case "ps": $pkg = $row['ps']; $pkg_value = "ps"; $pkg_desc = "Paper Sleeve"; break; case "tp": $pkg = $row['tp']; $pkg_value = "tp"; $pkg_desc = "Trimpack "; break; case "cs": $pkg = $row['cs']; $pkg_value = "cs"; $pkg_desc = "C-Shell "; break; case "scdm": $pkg = $row['scdm']; $pkg_value = "scdm"; $pkg_desc = "Single CD Mailer 5/0 (2 pnl)"; break; case "scds": $pkg = $row['scds']; $pkg_value = "scds"; $pkg_desc = " Single CD Sleeve 5/0 (2 pnl)"; break; case "scdw": $pkg = $row['scdw']; $pkg_value = "scdw"; $pkg_desc = "Single CD Wallet 5/0 (4 pnl)"; break; case "dcdw": $pkg = $row['dcdw']; $pkg_value = "dcdw"; $pkg_desc = "Double CD Wallet 5/0 (4 pnl)"; break; default: $pkg_value = "None"; $pkg_desc = "No Packaging"; break; } $packagingcost = ($pkg *$quantity) ; ///////Insertion if ($pkg_value == 'None' || $pkg_value == 'tp' || $pkg_value == 'cs' || $pkg_value == 'jc' ) { $insertion = 'None' ; } elseif ($pkg_value == "ps" || $pkg_value == 'scdm' || $pkg_value == "scds" || $pkg_value == 'scdw' || $pkg_value == "dcdw" ) { $insertion = 'iip' ; } switch ($insertion) { case "None": $isertion_value = "None"; break; case "iip": $isertion = $row['sert']; $isertion_value = "iip"; break; default: $isertion_value = "None"; break; } $insertioncost = ($isertion * $quantity); //////////wrap switch ($wrap) { case "None": $wrp_value = "None"; $wrp_desc = "No Wrap"; break; case "cw": $wrp = $row['cw']; $wrp_value = "cw"; $wrp_desc = "4/0 Case Wrap w/no Shrink Wrap"; break; case "cww": $wwwrp = $row['cw']; $wwrp = $row['sw']; $wrp = ($wwwrp + $wwrp) ; $wrp_value = "cww"; $wrp_desc = "4/0 Case Wrap w/Shrink Wrap"; break; case "cw1": $wwwrp = $row['cw1']; $wwrp = $row['sw']; $wrp = $wwwrp ; $wrp_value = "cw1"; $wrp_desc = "4/1 Case Wrap w/no Shrink Wrap"; break; case "cww1": $wwwrp = $row['cw1']; $wwrp = $row['sw']; $wrp = ($wwwrp + $wwrp) ; $wrp_value = "cww1"; $wrp_desc = "4/1 Case Wrap w/ Shrink Wrap"; break; case "cw4": $wwwrp = $row['cw2']; $wwrp = $row['sw']; $wrp = $wwwrp ; $wrp_value = "cw4"; $wrp_desc = "4/4 Case Wrap w/no Shrink Wrap"; break; case "cww4": $wwwrp = $row['cw2']; $wwrp = $row['sw']; $wrp = ($wwwrp + $wwrp) ; $wrp_value = "cww4"; $wrp_desc = "4/4 Case Wrap w/Shrink Wrap"; break; case "sw": $wrp = $row['sw']; $wrp_value = "sw"; $wrp_desc = "Shrink Wrap"; break; case "wf": $wrp = $row['wf']; $wrp_value = "wf"; $wrp_desc = "Wafer Seal (Printed Packaging)"; break; default: $wrp_value = "None"; $wrp_desc = "No Wrap"; break; } $wrappingcost = ($wrp*$quantity); ////////inserts switch ($inserts) { case "None": $ins_value = "None"; $ins_desc = "No Inserts"; break; case "b2b1": $ins = $row['b2b1']; $ins_value = "b2b1"; $ins_desc = "Booklet 2 Panel (4/1) w/tray"; break; case "b2b4": $ins = $row['b2b4']; $ins_value = "b2b4"; $ins_desc = "Booklet 2 Panel (4/4) w/tray"; break; case "b4b1": $ins = $row['b4b1']; $ins_value = "b4b1"; $ins_desc = "Booklet 4 Panel (4/1) w/tray"; break; case "b4b4": $ins = $row['b4b4']; $ins_value = "b4b4"; $ins_desc = "Booklet 4 Panel (4/4) w/tray"; break; case "i2p1": $ins = $row['i2p1']; $ins_value = "i2p1"; $ins_desc = "Insert 2 Panel (4/1 or 4/0)"; break; case "i2p4": $ins = $row['i2p4']; $ins_value = "i2p4"; $ins_desc = "Insert 2 Panel (4/4)"; break; case "i4p1": $ins = $row['i4p1']; $ins_value = "i4p1"; $ins_desc = "Insert 4 Panel (4/1)"; break; case "i4p4": $ins = $row['i4p4']; $ins_value = "i4p4"; $ins_desc = "Insert 4 Panel (4/4)"; break; case "i6p1": $ins = $row['i6p1']; $ins_value = "i6p1"; $ins_desc = "Insert 6 Panel (4/1)"; break; case "i6p4": $ins = $row['i6p4']; $ins_value = "i6p4"; $ins_desc = "Insert 6 Panel (4/4)"; break; case "i8p1": $ins = $row['i8p1']; $ins_value = "i8p1"; $ins_desc = "Insert 8 Panel (4/1)"; break; case "i8p4": $ins = $row['i8p4']; $ins_value = "i8p4"; $ins_desc = "Insert 8 Panel (4/4)"; break; default: $ins_value = "None"; $ins_desc = "No Inserts"; break; } $insert = r_ound($ins * $quantity) ; //////////////////proofs $result2 = mysql_query ("SELECT * FROM replicationextras"); $row2 = mysql_fetch_array($result2); /////////////////tape transfer switch ($transfer) { case "None": $tt_value = "None"; $tt_desc = "No Transfer"; break; case "tt1": $tt = $row2['tt1']; $tt_value = "tt1"; $tt_desc = " Up to 1 Hour Tape Transfer"; break; case "tt2": $tt = $row2['tt2']; $tt_value = "tt2"; $tt_desc = " 1 to 2 Hour Tape Transfer"; break; default: $tt_value = "None"; $tt_desc = "No Transfer"; break; } $tape = r_ound($tt); ///////////////Global Math Area $placeholder = .001; $insertcost = $insertprice; $unitvalue = ($quantity * 1) + $placeholder; $total = $unitcost + $filmcost+ $packagingcost + $insert + $input + $tape + $insertioncost + $wrappingcost; $perdisc = ($total / $unitvalue ); ////////////lets round stuff off function r_ound ($rnd){ $r = round($rnd,4); return $r; } $film = r_ound($filmcost); $wrapper = r_ound($wrappingcost); $unit = r_ound($unitcost); $package = r_ound($packagingcost)+ $insertioncost; $disc = r_ound($perdisc); $grandtotal = ($disc*$quantity); //$grandtotal = r_ound($unitcost + $film + $packagingcost + $wrappingcost + $insert + $tape + $insertioncost); $_SESSION['quantity'] = $quantity; //////////////register values to pass to confirmation page session_register ( "quantity"); session_register ( "film"); session_register ( "wrapper"); session_register ( "unit"); session_register ( "package"); session_register ( "insert"); session_register ( "input"); session_register ( "disc"); session_register ( "additional"); session_register ( "grandtotal"); session_register ( "tt_desc"); session_register ( "transfer"); session_register ( "isertion_desc"); session_register ( "insertion"); session_register ( "ins_desc"); session_register ( "inserts"); session_register ( "wrap"); session_register ( "wrp_desc"); session_register ( "packaging"); session_register ( "pkg_desc"); session_register ( "printing"); session_register ( "prn_desc"); session_register ( "insertioncost"); session_register ( "tape"); session_register ( "isertion_desc"); session_register ( "tt_desc"); session_register ( "type_desc"); ?>
|
|||||||||||||||||||||||||