blue-mouse
Member
Hi,
I have Joomla 2.5 and fabrik 3.09.
I have table1 with records that incudes production-modules of devices ordered by our customers.
This is device-production-modules table1.
Each record includes fields like: customer, order no, device-modules.
I have multiple columns with device-modules about 30.
Our modules are for example:
Pakiet_AA {ccjom_cc_kk_karta_rejestr___is_pak_xxxx}
Pakiet_AB --- {ccjom_cc_kk_karta_rejestr___is_pak_xxab}
Pakiet_AC --- {ccjom_cc_kk_karta_rejestr___is_pak_xxac}
Pakiet_AD --- {ccjom_cc_kk_karta_rejestr___is_pak_xxad}
In really, Pakiet_AA means place/area/box inside a case where i can input physical module like/with production names like:
1. 4 x (In/50I)
2. 3 x (In/50In) +Io
3. In/2In + X + 3Un + X
4. 2 x (In/2In) + 2 x 3Un
5. 4 x 2Un
6. 3 x 1.22Un + 2Un
7. 3 x (In/50In) + X
I can input in hole/place Pakiet_AA and Pakiet_AB some 1-of-7 module. I use the same productional-modules for hole/place Pakiet_AA and Pakiet_AB.
In table1 customer order no: "15009" include 21 rows/records with devices.
I need count physical productional-modules for 1 order.
I count "what i have" in hole/place Pakiet_AA and in hole/place Pakiet_AB.
On screen shoot you can see:
Pakiet_AA ---- AA:
Pakiet_AB ----AB:
for order no 15009
This counting for AA and AB is splitted itself by physical-productional-module wchich is input in hole/place AA and AB.
I would count together Pakiet_AA + Pakiet_AB
and also split this by all values that are in column (Pakiet_AA and Pakiet_AB)
I can count Pakiet_AA + Pakiet_AB ---- number of modules is : Count(AA + AB): 42 --- screenshot
But have no idea how to write in box "split php" to split by values from those 2 column (Pakiet_AA + Pakiet_AB).
Can i get any help how to write this condition - split php by values from 2 columns/fields?
I have Joomla 2.5 and fabrik 3.09.
I have table1 with records that incudes production-modules of devices ordered by our customers.
This is device-production-modules table1.
Each record includes fields like: customer, order no, device-modules.
I have multiple columns with device-modules about 30.
Our modules are for example:
Pakiet_AA {ccjom_cc_kk_karta_rejestr___is_pak_xxxx}
Pakiet_AB --- {ccjom_cc_kk_karta_rejestr___is_pak_xxab}
Pakiet_AC --- {ccjom_cc_kk_karta_rejestr___is_pak_xxac}
Pakiet_AD --- {ccjom_cc_kk_karta_rejestr___is_pak_xxad}
In really, Pakiet_AA means place/area/box inside a case where i can input physical module like/with production names like:
1. 4 x (In/50I)
2. 3 x (In/50In) +Io
3. In/2In + X + 3Un + X
4. 2 x (In/2In) + 2 x 3Un
5. 4 x 2Un
6. 3 x 1.22Un + 2Un
7. 3 x (In/50In) + X
I can input in hole/place Pakiet_AA and Pakiet_AB some 1-of-7 module. I use the same productional-modules for hole/place Pakiet_AA and Pakiet_AB.
In table1 customer order no: "15009" include 21 rows/records with devices.
I need count physical productional-modules for 1 order.
I count "what i have" in hole/place Pakiet_AA and in hole/place Pakiet_AB.
On screen shoot you can see:
Pakiet_AA ---- AA:
Pakiet_AB ----AB:
for order no 15009
This counting for AA and AB is splitted itself by physical-productional-module wchich is input in hole/place AA and AB.
I would count together Pakiet_AA + Pakiet_AB
and also split this by all values that are in column (Pakiet_AA and Pakiet_AB)
I can count Pakiet_AA + Pakiet_AB ---- number of modules is : Count(AA + AB): 42 --- screenshot
But have no idea how to write in box "split php" to split by values from those 2 column (Pakiet_AA + Pakiet_AB).
Can i get any help how to write this condition - split php by values from 2 columns/fields?
Attachments
Last edited: