Help with business map

[rslemer]

my log

pquery update vtiger_contactscf set cf_1124 =? where contactid=?
pquery parameters [091.353.658-03,9555]

---

how system open a begin/commint transacion in mysql server?

I need use a select sql command first ?

[joebordes]

you only need these lines:

global $adb;
$adb->pquery("update vtiger_contactscf set $field =? where contactid=?",array($cpf,$contato_id));

[rslemer]

But seens registry is blocked or some like that

if I forced another id works, but the same ID in edition not working ...

[joebordes]

but this is inside the validation?
what are you trying to update there? That doesn't make any sense, the information hasn't even been saved yet if you are creating and it will get overwritten anyway when they save

[rslemer]

I wish put a mask in field

if number input is 99999999999 i wish write in field 999.999.999-99

---

understand

the validation event happens before the system save doesn't it?

I can substitute a value in some current field for a system update get there with a mask ?

[joebordes]

to do that you have to work with the Field Dependency map:

http://corebos.com/documentation/doku.php?id=en:adminmanual:businessmappings:field_dependency

that map has the action called "function" which calls any function you can create yourself.

we have created some of these function that you can use and see here: https://github.com/tsolucio/corebos/blob/master/include/js/FieldDepFunc.js

Exactly you are looking to construct one like these:

https://github.com/tsolucio/corebos/blob/master/include/js/FieldDepFunc.js#L44
https://github.com/tsolucio/corebos/blob/master/include/js/FieldDepFunc.js#L48

try creating a field dependency map and use those two. once you understand what they do add your own function to do what you need

let us know how it goes

[rslemer]

i'm having contact with the code now

but from what I saw it is well standardized and the functions are shared between modules

Field mask is a very common problem that directly affects database queries

Record only numbers, or record with mask, both cases have advantages and disadvantages

But the worst case scenario is having part numbers and only part mask

The ideal solution would be for the layout editor to include the mask and fields to be just number in the database, I think

[rslemer]

I means, my first idea is write in table number and mask together

But in this case, SQL command not will be working or need be informed for end user two ways, one without a mask and another with mask, and this is not good ...

[rslemer]

(10-01-2019, 09:32 PM)joebordes Wrote: to do that you have to work with the Field Dependency map:

http://corebos.com/documentation/doku.php?id=en:adminmanual:businessmappings:field_dependency

that map has the action called "function" which calls any function you can create yourself.

we have created some of these function that you can use and see here: https://github.com/tsolucio/corebos/blob/master/include/js/FieldDepFunc.js

Exactly you are looking to construct one like these:

https://github.com/tsolucio/corebos/blob/master/include/js/FieldDepFunc.js#L44
https://github.com/tsolucio/corebos/blob/master/include/js/FieldDepFunc.js#L48

try creating a field dependency map and use those two. once you understand what they do add your own function to do what you need

let us know how it goes

but this process uses a groupid .. this a kind of problem, because another profile uses a roleid ...

---

(10-04-2019, 02:52 PM)rslemer Wrote:

(10-01-2019, 09:32 PM)joebordes Wrote: to do that you have to work with the Field Dependency map:

http://corebos.com/documentation/doku.php?id=en:adminmanual:businessmappings:field_dependency

that map has the action called "function" which calls any function you can create yourself.

we have created some of these function that you can use and see here: https://github.com/tsolucio/corebos/blob/master/include/js/FieldDepFunc.js

Exactly you are looking to construct one like these:

https://github.com/tsolucio/corebos/blob/master/include/js/FieldDepFunc.js#L44
https://github.com/tsolucio/corebos/blob/master/include/js/FieldDepFunc.js#L48

try creating a field dependency map and use those two. once you understand what they do add your own function to do what you need

let us know how it goes

but this process uses a groupid .. this a kind of problem, because another profile uses a roleid ...

Explain better, profile and GV uses a roleid ... and in here I need uses a groupid .... I will need created a grooupid too, and not good for administration ...

[joebordes]

that "groupid" groups the conditions together it has nothing to do with the user groups inside the application

business maps, as global variables are both group and role based