如何为订单中的每个框创建唯一编号

Question

The issue is not how I am generating the number, that is working fine for a different app I have. The issue is counting the total number of boxes and iterating through a forloop that many times. Right now I am multiplying box_ct * qty_ord to get the total boxes. BTW, I am still trying to understand everything I can do with foreach and for loops, so if anyone has a better idea, Great. CLARIFICATION: I am searching the database by order number and pulling back qty_ord, box_ct, and item_no for each. On some orders there is more than one item. So for each item I need to multiply qty_ord by box_ct = count and for that specific item I need to iterate through the loop based on what my count is.Right now if I remove the foreach and hardcode the for loop count variable it works fine. Any ideas on what is wrong with my foreach?

qty_ord | box_ct | item_no
------------------------
1          2        10001
3          3        10002
2          1        10003
2          3        10004
2          6        10005

Below is my code.

$sql ="SELECT imitmidx_sql.box_ct, oeordlin_sql.item_no, oeordlin_sql.qty_ord
                    FROM imitmidx_sql 
                    JOIN oeordlin_sql ON oeordlin_sql.item_no = imitmidx_sql.item_no WHERE ord_no ='$orderNum'";

            $query = odbc_exec($conn, $sql);

            $row7 = odbc_fetch_array($query);

            foreach($row7['item_no'] as $item){
                $count = $row7['qty_ord'] * $row7['box_ct'];

                    for($counter = 0; $counter <= $count; $counter++){
                        //GRAB NUMBER FROM FILE 
                        $sscc = file_get_contents("ucc128.txt");
                        //INCREMENT NUMBER
                        $sscc++;
                        //PUT THE NUMBER BACK IN FILE
                        $sscc = file_put_contents("ucc128.txt", $sscc);
                        //COMBINE STATIC NUMBER AND NUMBER FROM FILE 
                        $ssccnumber = "00950000".$sscc;
                        //CREATE CHECK DIGIT MATH
                        $ssccnumArray = str_split((string)$ssccnumber);
                        $ssccstep1 = array_combine(range(1, count($ssccnumArray)), $ssccnumArray);

                        $ssccstep2 = 0;
                        $ssccstep4 = 0;
                        foreach($ssccnumArray as $k => $v){
                            if($k%2){
                                $ssccstep2 += (int)$v;
                            }else{
                                $ssccstep4 += (int)$v;
                            }
                        }

                        $ssccstep3 = (int)$ssccstep2 * 3;
                        $ssccstep5 = (int)$ssccstep3 + (int)$step4;
                        $ssccCheckDigit = (ceil($ssccstep5 / 10) * 10) - $ssccstep5;
                        //END CREATE CHECK DIGIT
                        //CONCATENATE FULL NUMBER    
                        $sscc1 = $ssccnumber.$ssccCheckDigit;

                        $sql = "INSERT INTO ucc128 (sscc, ord_no) VALUES ('$sscc1' ,'$orderNum')";
                        #echo $sql.'<br />';
                        odbc_exec($connPRONUMBER, $sql);
                }
            }

Answer 1

My foreach was not working, so what I did instead was get the sum using my SQL query.

SELECT SUM(imitmidx_sql.box_ct * oeordlin_sql.qty_ord) AS total
                    FROM imitmidx_sql 
                    JOIN oeordlin_sql ON oeordlin_sql.item_no = imitmidx_sql.item_no WHERE ord_no ='$orderNum'

I was then able to ouput it and save $row7['total'] to the variable $count.