Whats the proper way to pull query information from table?
Whats the proper way to pull query information from table?
davidjmorin
Posts: 101Questions: 31Answers: 0
I have the below php file that is pulling from myql table.
Editor::inst( $db, 'rma_submissions', 'ID' )
->fields(
Field::inst( 'rma_submissions.id' ),
Field::inst( 'rma_submissions.timestamp' )
->validator( Validate::dateFormat( 'Y-m-d H:i:s' ) )
->getFormatter( Format::datetime( 'Y-m-d H:i:s', 'Y-m-d H:i:s' ) )
->setFormatter( Format::datetime( 'Y-m-d H:i:s', 'Y-m-d H:i:s' ) ),
Field::inst( 'rma_submissions.location' ),
Field::inst( 'rma_submissions.orig_invoice' ),
Field::inst( 'rma_submissions.all_accessories' ),
Field::inst( 'rma_submissions.new_submission' ),
Field::inst( 'rma_submissions.man_sku' ),
Field::inst( 'rma_submissions.device_id' ),
Field::inst( 'rma_submissions.failure_desc' ),
Field::inst( 'rma_submissions.defective_oob' ),
Field::inst( 'rma_submissions.original_sales_date' ),
Field::inst( 'rma_submissions.vendor' ),
Field::inst( 'rma_submissions.email' ),
Field::inst( 'rma_submissions.device_man' ),
Field::inst( 'rma_submissions.district' ),
Field::inst( 'rma_submissions.rma_number' ),
Field::inst( 'rma_submissions.paid' ),
Field::inst( 'rma_submissions.paid_date' ),
Field::inst( 'rma_reasons.reason_description' ),
)
What is the proper way to get the stored value from these?
IE: If im using an onedit event and want to show just the Location, email and rma number.
I have tried $row['rma_number'] and $row['rma_submissions.rma_number'] but these dont appear to work. I am trying to fire the onedit event and send the information via email. I am desperate lol. I have also replaced $row with $values
->on( 'postEdit', function ( $editor, $id, $values, $row ) {
$message = "
<html>
<head>
<title>RMA Update Complete</title>
</head>
<body>
TESTING ONLY
<p>This is a copy of your RMA Update Request</p>
$row['rma_submissions.rma_number']
</body>
</html>
} )
My Date
{
data: [
{
DT_RowId: "row_5",
rma_submissions: {
id: "5",
timestamp: "2020-06-02 14:11:29",
location: "Salem NH",
orig_invoice: "Yes",
all_accessories: "Yes",
new_submission: "New",
man_sku: "VZ-0410-001-US",
device_id: "456",
failure_desc: "03",
defective_oob: "yes",
original_sales_date: "2020-06-01",
vendor: "Verizon",
email: "Roberth@mysite.net",
device_man: "Verizon",
district: "District Jay",
rma_number: "237004860",
paid: "Yes",
paid_date: ""
},
rma_reasons: {
reason_description: "Incomplete Wake Up"
}
},
{
DT_RowId: "row_11",
rma_submissions: {
id: "11",
timestamp: "2020-07-27 10:55:03",
location: "Andover MA",
orig_invoice: "Yes",
all_accessories: "Yes",
new_submission: "New",
man_sku: "SMG988UZKV",
device_id: "949393",
failure_desc: "18",
defective_oob: "yes",
original_sales_date: null,
vendor: "Ice Mobility",
email: "davidm@mysite.net",
device_man: "Apple",
district: "District Manny",
rma_number: "Test2354kkllkk",
paid: "No",
paid_date: ""
},
rma_reasons: {
reason_description: "Headset Jack"
}
},
{
DT_RowId: "row_10",
rma_submissions: {
id: "10",
timestamp: "2020-06-05 13:18:36",
location: "Stow MA",
orig_invoice: "Yes",
all_accessories: "Yes",
new_submission: "New",
man_sku: "525QBBK01B",
device_id: "3498237u4",
failure_desc: "41",
defective_oob: "yes",
original_sales_date: "2020-05-27",
vendor: "Verizon",
email: "davidm@mysite.net",
device_man: "Samsung",
district: "District Sanat",
rma_number: "237300401",
paid: "Yes",
paid_date: "2020-07-07"
},
rma_reasons: {
reason_description: "Activation / Programming"
}
}
],
options: [ ],
files: [ ],
searchPanes: {
options: [ ]
}
}
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
It’s option three
Allan