Need help in writing a custom script for a third party software

pragan

Hi,

I need help in the following things:

Below are the sample lines from my report. In this report I need to replace the "First year at school" , "Third year at school" with "Freshman" ,
" Junior " respectively. Simillarly, we will have second year, foruth year also to change to sophomore and senior respectively

StudentId Firstname Lastname Class
101 || abc || def || First year at school
102 || efg || hjk || Third year at school
103 || lmn || rst || First year at school

I need to wrtie a script only using php that will change the text under the heading "Class" as below

StudentId Firstname Lastname Class
101 abc def Freshman
102 efg hjk Junior
103 lmn rst Freshman

I wrote this two lines to change the text with "Freshman" in all the places to just see how custom scripts works in the thrid party software.

$class = "Freshman";
$rows[0][3] ->val = $class; //this is the way I can call that column in this CRM software where I can define my scripts.

StudentId Firstname Lastname Class
101 abc def Freshman
102 efg hjk Freshman
103 lmn rst Freshman

I know that I need to traverse through each row then use conditions and replace the text but I am not sure how to do it.

It would be great if any one can help me in knowing the array structure in PHP..I can think of a way that I can write four if else conditions as I will have Four different values for the column " Class".

Please help me out.

Thanks in advance
Pragan

stevesweetland

Could do with seeing the script where the intial query is done..

you might just decide to have a labelled array array

$newclassvars = array();
$newclassvars["First year at school"] = "Freshman";
$newclassvars["Secoond year at school"] = "Whatever";

then where the table is constructed, presuming it says something like

echo db_result($result,$row,"Class");

replace it with

echo $newclassvars[db_result($result,$row,"Class")];

make any sense?

hope this helps?

pragan

Hi,

First, Thanks for the reply. The main thing here is I am writing a custom script for the thrid part software so it does not allow me to see the code of the program.

Some more info of what and how I am trying this :

Once I log in to this software I have place called Define Custom Scripts so here is where I am allowed to write my scripts.

This window will have four tabs as : Intialization, Headers, Process, Finish.

I wrote the following two lines to see how this cusotm scripts works under the "Process" tab.

Process tab starts already have these lines in bold

function process_row($rows)
{

//Place where we have to write our code :

foreach($rows[0][3] as $key => $value)

  {
     $rows[0][3] -> val = "Samplelines";
  }

//Our code should end here

return ($rows)
}

So the output I got is

StudentId Firstname Lastname Class
101 || abc || def || Samplelines
102 || efg || hjk || Samplelines
103 || lmn || rst || Samplelines

|| - just used here to seperate the coloumns..its not there in the records.

I obtained this with these two lines of code without database query ...so what I actually need is how to check each lines and replace accorindly (First year at school with "Freshman" , second year at shcool with "Sophomore" and so on.

Hope I am clear in explaining this. Please let me know if I can be more clear.

Thanks in advance

stevesweetland

ok try this

function process_row($rows){
  foreach($rows[0][3] as $key => $value){
    if ($value == "First year at school") $rows[0][3] -> val = "Freshman";
    if ($value == "Second year at school") $rows[0][3] -> val = "Whatever";
  }
  return ($rows)
}

pragan

Hi,

It worked!

Great help..Thanks a lot.!!!

Now I can write the conditions and make the changes.

Will be in touch if I have some more doubts!🙂

Pragan