Topic: need help with coding an array

[sso]

Hey guys,
I need help with coding an array, I just cannot wrap my head around it. I got the following array

$info =
Array (

• => Array ( [AOCODE] => 3123121209-1 [OPTID] => 2 [EMPID] => 00675 [PCS] => 1060 [AMT] => 7.95 [PRICE] => 0.15 )
[1] => Array (

[AOCODE] => 3123121209-1 [OPTID] => 3 [EMPID] => 00696 [PCS] => 980 [AMT] => 4.90 [PRICE] => 0.10 )
[2] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 5 [EMPID] => 00696 [PCS] => 1000 [AMT] => 5.00 [PRICE] => 0.10 )
[3] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 6 [EMPID] => 00675 [PCS] => 1060 [AMT] => 5.30 [PRICE] => 0.10 )
[4] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 7 [EMPID] => 00690 [PCS] => 1220 [AMT] => 4.88 [PRICE] => 0.08 )
[5] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 8 [EMPID] => 00069 [PCS] => 300 [AMT] => 8.25 [PRICE] => 0.55 )
[6] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 8 [EMPID] => 00336 [PCS] => 220 [AMT] => 6.05 [PRICE] => 0.55 )
[7] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 8 [EMPID] => 00569 [PCS] => 240 [AMT] => 6.60 [PRICE] => 0.55 )
[8] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 8 [EMPID] => 00727 [PCS] => 300 [AMT] => 8.25 [PRICE] => 0.55 )
[9] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 9 [EMPID] => 00029 [PCS] => 1200 [AMT] => 8.40 [PRICE] => 0.14 )
[10] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 10 [EMPID] => 00092 [PCS] => 980 [AMT] => 6.86 [PRICE] => 0.14 )
[11] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 11 [EMPID] => 00059 [PCS] => 600 [AMT] => 6.00 [PRICE] => 0.20 )
[12] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 11 [EMPID] => 00704 [PCS] => 600 [AMT] => 6.00 [PRICE] => 0.20 )
[13] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 12 [EMPID] => 00356 [PCS] => 460 [AMT] => 2.76 [PRICE] => 0.12 )
[14] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 12 [EMPID] => 00716 [PCS] => 460 [AMT] => 2.76 [PRICE] => 0.12 )
[15] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00098 [PCS] => 360 [AMT] => 5.40 [PRICE] => 0.30 )
[16] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00341 [PCS] => 200 [AMT] => 3.00 [PRICE] => 0.30 )
17] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00465 [PCS] => 160 [AMT] => 2.40 [PRICE] => 0.30 )
[18] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00474 [PCS] => 80 [AMT] => 1.20 [PRICE] => 0.30 )
[19] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00473 [PCS] => 1080 [AMT] => 1.20 [PRICE] => 0.30 )
)

and I would like to use it to output the below array

$output =
Array (

• => Array ([OPTID] => 2 [EMPID1] => 00675 [PCS1] => 1060 [EMPID2] => [PCS2] =>)
[1] => Array (

[OPTID] => 3 [EMPID1] => 00696 [PCS1] => 980 [EMPID2] => [PCS2] =>)
[2] => Array ([OPTID] => 5 [EMPID1] => 00696 [PCS1] => 1000 [EMPID2] => [PCS2] =>)
[3] => Array ([OPTID] => 6 [EMPID1] => 00675 [PCS1] => 1060 [EMPID2] => [PCS2] =>)
[4] => Array ([OPTID] => 7 [EMPID1] => 00690 [PCS1] => 1220 [EMPID2] => [PCS2] =>)
[5] => Array ([OPTID] => 8 [EMPID1] => 00069 [PCS1] => 300 [EMPID2] => 00336 [PCS2] => 220)
[6] => Array ([OPTID] => 8 [EMPID1] => 00569 [PCS1] => 240 [EMPID2] => 00727 [PCS2] =>300)
[7] => Array ([OPTID] => 9 [EMPID1] => 00029 [PCS1] => 1200 [EMPID2] => [PCS2] =>)
[8] => Array ([OPTID] => 10 [EMPID1] => 00092 [PCS1] => 980 [EMPID2] => [PCS2] =>)
[9] => Array ([OPTID] => 11 [EMPID1] => 00704 [PCS1] => 600 [EMPID2] => 00704 [PCS2] => 600)
[10] => Array ([OPTID] => 12 [EMPID1] => 00356 [PCS1] => 460 [EMPID2] => 00716 [PCS2] => 460)
[11] => Array ([OPTID] => 16 [EMPID1] => 00098 [PCS1] => 360 [EMPID2] => 00341 [PCS2] => 200)
[12] => Array ([OPTID] => 16 [EMPID1] => 00465 [PCS1] => 160 [EMPID2] => 00474 [PCS2] => 80)
[13] => Array ([OPTID] => 16 [EMPID1] => 00473 [PCS1] => 1080 [EMPID2] => [PCS2] =>)

)

I have been trying for the last couple of days to figure this out. Appreciate it if anyone could help to look at it.


Thanks

[teamatomic]

Code: [Select]

$output=array();
  $i=0;
foreach ($info as $input)
{
  $output[$i]['OPTID']=$input['OPTID'];
  $output[$i]['EMPID1']=$input['EMPID'];
  $output[$i]['PCS1']=$input['PCS'];
  $output[$i]['EMPID']='';
  $output[$i]['PCS2']='';

 $i++;
}
 print_r($output);


HTH
Teamatomic

[sso]

Thanks Teamomatic for the quick reply.

My problem is that with the first array there are some OPTIDs that have 1 or 2 or even 5 EMPIDs and I need to put them into sets of 2s into the new array. Do you think I need to run through the first array counting the number of EMPIDs first then somehow create the new array using the counted EMPIDs?

Code: [Select]

$output=array();
  $i=0;
foreach ($info as $input)
{
  $output[$i]['OPTID']=$input['OPTID'];
  $output[$i]['EMPID1']=$input['EMPID'];
  $output[$i]['PCS1']=$input['PCS'];
  $output[$i]['EMPID']='';
  $output[$i]['PCS2']='';

 $i++;
}
 print_r($output);


HTH
Teamatomic

[teamatomic]

Show me one of the inside arrays with multiple EMPIS. You did not show that in your original post, it would help if you were more explicit.


HTH
Teamatomic

[sso]

you see with the $output array
..
[2] => Array ([OPTID] => 5 [EMPID1] => 00696 [PCS1] => 1000 [EMPID2] => [PCS2] =>)
is different from
..
[11] => Array ([OPTID] => 16 [EMPID1] => 00098 [PCS1] => 360 [EMPID2] => 00341 [PCS2] => 200)
[12] => Array ([OPTID] => 16 [EMPID1] => 00465 [PCS1] => 160 [EMPID2] => 00474 [PCS2] => 80)
[13] => Array ([OPTID] => 16 [EMPID1] => 00473 [PCS1] => 1080 [EMPID2] => [PCS2] =>)
..

This depends on the $info because the number of times EMPID appears is not fixed so I need $output to be repeated depending on how many times EMPID appears? I am sorry if I am not clear.. I suspect there is a modulo in there somewhere.. what I got so far is counting the number of times EMPID corresponds with an OPTID and then hardcoding it in.. I am not sure if that is the most elegant way to do it..

Thanks for any further help you can give