48540298_Redbook

landyaddaInternet et le développement Web

10 nov. 2013 (il y a 7 années et 11 mois)

321 vue(s)


1



ENGINEERING PROJECT






A Development of

Tailor
-
Made Fertilizer Optimizer




BY




Mr.
Sutthilak Luengsrisagoon




ID 48540298




Submitted to




DEPARTMENT

OF COMPUTER ENGINEERING,

FACULTY OF ENGINEERING

KASETSART UNIVERSITY


Academic Year 2008







Project Advisor

Assoc. Prof. Asanee Kawtrakul
, D. Eng




Signature



.............................................................

D
ate




............................
.............................



2














Software and Knowledge Engineering

Project Approval



Title


A Development of

Tailor
-
Made Fertilizer Optimizer



By


Mr.
Sutthilak Luengsrisagoon


ID 48540298



Approved By:




Project Advisor





..........................................
............................







(
Assoc. Prof. Asanee Kawtrakul
, D.

Eng
)




Head of Department




........................................................................









(Asst. Prof. Kemathat Vibhatavanij, Ph.D.)


Date


.................
.......................


3


Sutthilak Luengsrisagoon

2008
:
A De
velopment of
Tailor
-
Made Fertilizer Optimizer
,
Software and Knowledge Engineering Project, Bachelor of Engineering (Software and
Knowledge Engineering)

Project Advisor:
Assoc. Prof. Asanee Kawtra
kul, D. Eng





ABSTRACT



The

Smart Mobilized Fertilizing Expert System
so called “123
-
Tailor
-
made
Fertilizer”
[3]
is a

plant nutrient suggestion
-
based system
via mobile phone. The
nut
rient suggestion is done from the standard fertilizer mixture and the
same
suggestion that also
has

various mixing.
A

different mixing produces

a different effect

to the farming
. For example in case of
high consumption of fertilizer

mixing
, it will
both
raise the production cost and decrease the plant quality.

The
Tailor
-
Ma
de

Fertilizer Optimizer project
attempts to

improve the
performance of 123
-
Tailor
-
made Fertilizer

b
y
aggregating

experts fertilizing
calculation.

The fertilizing

calculation in this project focuses on

the needed plant
nutrient and fertilizer market price.

The
Tailor
-
Made

Fertilizer Optimizer

will choose
the most efficiency fertilizer mixing and
then send

to
123
-
Tailor
-
made Fertilizer as

suitable

mixture
.


Keywords:

Tailor
-
Made Fertilizer, Optimizer, Expert System,
Cyber B
rain
, Nutrient
S
uggestion
, Gateway,
SMS, Fertilizer, Tailor Made.















4

CONTENT












PAGE


CHAPTER 1



Introduction


1.1

Motivation









5

1.2

Objectives









5

1.3

Scope of project








6

1.4

Development tool








6

1.5

Benefits









6












CHAPTE
R 2


Related T
echnology

&
Related
Work


2.1

Related T
echnology









2.1.1

PHP









8

2.1.2

HTML









8

2.1.3

Java









8

2.1.4

Java Script








8

2.1.5

SMS Gateway








8

2.1.6

SQL









9

2.2

Related Software










2.2.1

A
dobe Dreamweaver







9


2.2.2

Microsoft SQL Server







9


2.2.3

MySQL








9


2.2.4

Apache








10


2.2.5

phpMyAdmin








10

2.3

Related Work


2.3.1

SimRice








10


2.3.2

L
iterature review







11





CHAPTER 3


Design and Implementation







3.1

Concept and problem








12

3.2

System Architecture








12

3.3

Tailor
-
Made Fertilizer Optimizer bill.





16

3.4

System workflow









16

3.5

Implementation








17




5

CONTENT












PAGE

CHAPTER 4


System Evaluation







4.1

System Evaluation

4.2

1
-
2
-
3 Tailor
-
Made Fertilizer Program for the cooperative

e
valuation




CHAPTER 5


Conclusion and Future Work







5.1

Concl
usion

5.2

Future Work














Appendix
1
.
User Manual.

Appendix
2
. References
.



6

LIST OF FIGURES












PAGE

Fig1.

SMS
gateway
.

Fig2.

SimRice Program User Interface.

Fig3.

System Architecture of Tailor
-
Made Fertilizer Optimize
r.

Fig4.

System Workflow

Fig5.

Tailor
-
Made Program conclusion

Fig6.

Profile Registration User Interface.

Fig7.

Fertilizer Ordering User Interface.

Fig8.

Program provide suggestion choices.

Fig9.

Program provide suggestion choices.

Fig10.

The suggest
ion.

Fig11.

Fertilizer Order

bill.

Fig12.

Farmer Profile Database.

Fig13.

Price update.

Fig14.

Tailor
-
Made Fertilizer order

bill.

Fig15.

Soil selection

Fig16.

Soil select by soil properties

Fig17.

Fertilizer suggestion

Fig18.

The evaluation point of

view.

Fig19.

I
ndividual and cooperative save cost comparison

Fig20. Tailor made fertilizer solutions comparison

Fig2
1
.

The Fertilizer Order Bill.

Fig
2
2.


System Architecture of Tailor
-
Made Fertilizer Optimizer

aggregates with Plant Price Tracker.

Fig2
3
.

Program first page

Fig2
4
.

Registration form

Fig2
5
.

Ordering form

Fig2
6
.

Price change form





















7

Chapter

1


Introduction



1.1

Motivation



Site
-
Specific Nutrient Management

[1]

is the specific nutrient management
that concerns about plant
nutrient.
It has been well recognized that plant nutrient
management is significant key to increases plant productivity, improves economic
return, and reduces negative environment impact.

1
-
2
-
3 Tailor
-
Made Fertilizer via
mobile phone, a smart mobilized fer
tilizing expert system

[2]

, is one of the
applications based on
ALRO
-
CyberBrain Project
[3]

that supported by Kasetsart
University, NECTEC (National

Electronics and Computer Technology Center) and
Agricultural Land Reform Office.



Thailand
has
enormous

p
roblem about agricultural fertilizer that is high
consumption of fertilizing. The
sufficient

fertilizing can reduce 47 percent

[4]

of
production cost

or 241 baht per Rai

[13]
.
123

Tailor
-
Made Fertilizer via mobile phone
is the expert system that suggests t
he sufficient fertilizing to the agriculturists via
mobile phone by short message service (SMS). But 1
-
2
-
3 Tailor
-
Made Fertilizer is the
nutrient suggestion that

is done from the standard fertilizer mixture and the same
suggestion that also
has

various mix
ing.
A

different mixing produces

a different effect

to the farming
. For example in case of
high consumption of fertilizer

mixing
, it will
both
raise the production cost and decrease the plant quality.

This project,
Tailor
-
Made

Fertilizer Optimizer,
attempt
s to

improve the performance of 123
-
Tailor
-
made
Fertilizer via mobile phone

b
y
automatically calculate

from various standard
fe
rtilizers by focuses on

the needed plant nutrient and fertilizer market price.

The
optimizer

will choose the most efficiency fert
ilizer mixing and
then send

to
123
-
Tailor
-
made Fertilizer as

suitable

mixture and also help farmer to use the fertilizer
sufficiently.




1.2

Objectives


The purposes of Tailor
-
Made Fertilizer Optimizer are following:

1.

To develop algorithm for optimizing the

most suitable fertilizer suggestion
automatically.

2.

To integrate Tailor
-
Made Fertilizer and the Optimizer in order to provide
Tailor
-
Made software.

3.

To develop
User

Interface for update price by the knowledge broker
(government service people).

4.

To

develop U
ser

Interface for
cooperative Tailor
-
Made fertilizer
suggestion
by the
officer

(government service people)

and deliver by using
SMS
.


8


1.3

Scope of project


The scope of project is limited by the available time for senior project. The
Tailor
-
Made Fertilizer Op
timizer scope includes:

1.

The Optimizer is a part of 123 Tailor
-
Made Fertilizer Expert System.

2.

The Optimizer will optimize from the mostly use of fertilizers.

3.

The
Tailor
-
Made Fertilizer
suggests

only sensitive day length rice, non
sensitive day length rice a
nd corn.

4.

The Ta
ilor
-
Made will provides order

bill and SMS

for the suggestion
.


1.4

Development tools



Hardware



Intell® Dual Core™ CPU T2300 @ 1.66 GHz



RAM 1.00 GB


Software



Windows XP



Microsoft Office 2007



NetBeans IDE 6.1



Adobe Dreamweaver CS3



MySQL5.0



1.5 Benefits



Thailand is agriculture country that has various kinds of plants such as rice
and corn. The Tailor
-
Made Fertilizer will hand on the variety of plant by design the
system
the server the user need by suggest all verities of rice and corn.

The benefits
will show for 2
fields
.

Tailor
-
Made Fertilizer via mobile phone Benefits and Tailor
-
Made Fertilizer for the cooperative Benefits.


1.5.1

Tailor
-
Made Fertilizer via mobile phone Benefit
s




The usi
ng of the Tailor
-
Made Fertilizer suggestion vi
a mobile phone use
s

SMS (Short Message Service) to serve
s

the convenient
for

the end
-
user (agriculturist)
.

Fast and Easy for the
agriculturists
to

get

the Tailor
-
Made Fertilizer suggestion

automatically

and

optimized fertilizer mixing
via

Short Message Ser
vice (SMS).


9

1.5.2

Ta
ilor
-
Made Fertilizer for the cooperative Benefit
s



For the cooperative Tailor
-
Made Fertilizer suggestion provide the interface for
the cooperative to service officer user (
cooperative officer
) fast and easy.


Economy:

The individual
Tailor
-
Made Fertilizer mixing saves the production
cost but in every time of the mixing remain the fertilizer that not
use. E.g. buy the fertilizer
1 sack (25 kgs.) use only 17 kgs.
Remains 8 kgs. That may increase the production so the group of
agricultur
ists may the Tailor
-
Made fertilizing more effectiveness.

Technology:

The cooperative officers can service much more faster because the
system provide functions to help the officer service (registration,
ordering, billing, etc)










10

CHAPTER 2


Related
T
echnology

&
Related
Work


2.1 Related T
echnology


2.1.1 PHP


PHP (Personal Home Page Tool) is a programming language which was
designed for creating dynamic web pages by keeping code in server. The pattern of
PHP command line is similar to C languag
e or Perl. PHP can work together with
HTML for increasing efficiently of webpage.


2.1.
2

HTML



HTML (Hypertext Markup Language) provides a means to describe the
structure of text
-
based information in a document. HTML is written in the form of
labels, su
rrounded by angle brackets, and it also includes scripting language code
which can be accessed or viewed by web browsers.


2.1.3 Java



Java is a programming language was developed by Sun Microsystems. Java syntax is
derived from C and C++. The strongest

point of Java is Object
-
oriented programming
style. Java applications are compiled and run on Java virtual machine, without the
need for any specific computer architecture.


2.1.4 JavaScript



JavaScript is a programming language which has structure sim
ilar to C
language. Java Script will compile and run command one by one. At first it was
called LiveScript, and then developed by the Netscape Company for helping
programmer use Java Script to support HTML. Java Script is used for client
-
side
WebPages.




2.
1.
5

SMS G
ateway


SMS gateway

is a term used to describe various methods of sending and
receiving
SMS

messages without using a mobile phone.



11


Fig
1
.

SMS GATEWAY.
[4]



2.1.6

SQL

SQL (Structured Query Language)
is a
computer language

that is designe
d for
retrieving and managing data in database system.
.

The core of SQL is allowing user

to retrieve, insert, update, and delete data
.
SQL is both an ANSI and an ISO standard
.


2.2 Related
Software


2.2.1 Adobe Dreamweaver



Adobe Dreamweaver is a web
development application which owned by
Adobe company. The new version of Dreamweaver can support new technologies
such as CSS, JavaScript, and various server
-
side scripting languages and frameworks
including ASP.NET, ColdFusion, Java Server Pages, and PHP
. [6]



2.
2.2

Microsoft SQL Server



Microsoft

SQL

Server is
desired as follows “
a relational database management
system (RDBMS) produced by Microsoft. Its primary query language is Transact
-
SQL, an implementation of the ANSI/ISO standard Structured

Query Language
(SQL) used by both Microsoft and Sybase

.

[7]




12

2.2.3 MySQL




MySQL is desired as follows “a multithreaded, multi
-
user SQL database
management system (DBMS) which has, according to MySQL AB, more than 10
million installations. The

basic program runs as a server providing multi
-
user access
to a number of databases. In a similar fashion to the JBoss model, MySQL is owned
and sponsored by a single for
-
profit firm, the Swedish company MySQL AB, which
holds the copyright to most of the

codebase. The project's source code is available
under terms of the GNU General Public License, as well as under a variety of
proprietary agreements”. [8]


2.2.4 Apache




Apache is desired as follows “a web server notable for playing a key role in
th
e initial growth of the World Wide Web. Apache was the first viable alternative to
the Netscape Communications Corporation web server (currently known as Sun Java
System Web Server), and has since evolved to rival other Unix
-
based web servers in
terms of f
unctionality and performance”. [9]


2.2.5 phpMyAdmin




phpMyAdmin is desired as follows “an open source tool written in PHP
intended to handle the administration of MySQL over the Internet. Currently it can
create and drop databases, create/drop/alter tab
les, delete /edit/add fields, execute any
SQL statement, and manage keys on fields”. [10]



2.3
Related
Work


2.3
.1
SimRice

[11]

and SimCorn

[14
]


SimRice

and SimCorn are

the expert
-
like system for rice

and corn

nutrient
suggestio
n for each soil s
eries (
Fi
g
ure
2
.). It could work on Microsoft Access 2000,
and compatible or higher versions.

SimRice Program has been implemented as stand
alone, the users who want to use have to download the program and install into the
computer. The way to update the informatio
n in the program is to download the new
version of
program.


13


Fig
2
. SimRice Program User Interface.



2.3.2
Literature review


Table 1 SimRice

& SimCorn

and Tailor
-
Made Fertilizer Optimizer Comparison.

Details

SimRice

SimCorn

Tailor
-
Made
Fertilizer Optimiz
er

Automatically



N



Y


Install



Y



N

F
ertilizer price



N



Y

Fertilizer Price update



N





Y

O
nline user.



N



Y


SMS

(Short Message Service)


N



Y


14

Chapter 3


Design and implement
at
ion


3.1
Conc
ept and Problem


High consumption of fertilizer is the main production problem in Thailand.

The precision fertilizing

[12]

can reduce production cost

buy manage the fertilizing.
Tailor
-
Made Fertilizer Optimizer
tries

to optimizer and
suggests

the most suit
able
fertilizer for each agriculturist by applying the precision fertilizing.


3.2

Problem statement


Tailor
-
Made Fertilizer program is not flexible for every need. E.g. the
cooperative need the different style of program from the individual user. So program
w
ill also be the personalized program that supports different kind of user.

SMS (Short Message Service) provides message length for each message

70
letters for Thai and 160 letters for English so the suggestion supposes to be a short
message that may cause
the suggestion concept mistake.




3.
3

System Architecture



User (
Agriculturists
) registers for profile and land information. Fertilizer
Optimizing will optimize fertilizer from the fertilizer price and the land information
.
After the optimization farme
r will get Fertilizer order bill

as figure 3.




Fig
3
.

System Architecture of Tailor
-
Made Fertilizer Optimizer.


15

3.3.1

Profile

Registration


Farmer registers for name, surname, gender, ID number, phone number, e
-
mail, address, plant type, planting area, planti
ng province and soil series to farmer’s
profile information. The registration will also show member on the right side as list.



Fig6. Profile Registration User Interface.


3.3.2

Fertilizer

Requirement


The
requirement

has provided for the registered use
r and non registered user
(as Figure. 6) When chooser for the fertilizer ordering program will provides you the
choices for sensitive length rice, non sensitive length rice and corn.



16


Fig7. Fertilizer Ordering User Interface.




Fig8. Program provide su
ggestion choices.


17


Fig9. Program provide
s

suggestion choices.



After suggestion choice choosing, program will let you choose the province,
soil series, Nutrient Nitrogen, Nutrient Phosphorus and Nutrient Potassium (as Figure.
9) after that system will s
how you the suggestion (as Figure. 10) and let you to print
out the fertilizer order bill (as Figure. 11) and automatically sent short message to
your mobile phone.




Fig10. The
Fertilizer
suggestion.



18


Fig11. Fertilizer Order bill.


3.3.3
Agriculturis
t

Profile


Agriculturist

profile information is user profile database (name, surname,
gender, ID number, phone number, e
-
mail, address, plant type, planting area, planting
province and soil series) from the registration that use for the fertilizer suggesti
on and
billing.



3.3.4 Fertilizer Price


Three main fertilizers price
(nitrogen, phosphorus and potassium)
that use for

the billing
.

And fertilizer price can update (as figure. 13)


19


Fig13. Price update

interface
.

20


3.4

System
Workflow

From
System Architectur
e of Tailor
-
Made Fertilizer Optimizer

can
conclude as the end user (agriculturist) workflow below

(Figure. 4)



Fig
4.

System Workflow


21

3.
5

Implementation



This
program has developed on Adobe Dreamweaver as PHP files.



F
ig
15.

Soil selection


Example

code
: Soil selection query.



<select name="soilseries" id="soilseries" ">


<option value="" selected>
เลือกชุดดิน
</option>


<?


$sqlcolor="select SoilID,SoilName from thso
ildb ";


$rcolor=mysql_query($sqlcolor);


while ($rowcolor=mysql_fetch_array($rcolor)):


if($rowcolor[1]==$color) $chk="selected";



else $chk="";



echo "<option value='$rowcolor[1]' $chk
>$rowcolor[1]</option>";


endwhile;


?>


</select>




22


Fig
16.

Soil select by soil properties


Example

code
:
Soi
l selection by properties query
.


<?


$FindText="";


if($color!=""){


$colorstr=preg_split("/[
\
/
\
s
\
-
]/",$color,
-
1,PREG_SPLIT_NO_EMPTY);


$FindText=" and (";


for($i=0;$i<count($col
orstr);$i++){


if($i==0) $FindText.="";


if($i>0 ) $FindText.=" or ";


$FindText .=" SoilDesc like '%".trim($colorstr[$i])."%' ";




}


$FindText .
=" )";


}




if($surface!=""){


$surfacestr=preg_split("/[
\
/
\
s
\
-
]/",$surface,
-
1,PREG_SPLIT_NO_EMPTY);


$FindText .=" and (";


for($i=0;$i<count($surfacestr);$i++){



if($i==0) $FindText.="";


if($i>0 ) $FindText.=" or ";


$FindText .=" SoilDesc like '%".trim($surfacestr[$i])."%' ";




}


$FindText .=" )";


}



if($Solid!=""){


$Solidstr=preg_split("/[
\
/
\
s
\
-
]/",$Solid,
-
1,PREG_SPLIT_NO_EMPTY);


$FindText .=" and (";


for($i=0;$i<count($Solidstr);$i++){


if($i==0) $FindText.="";


if($i>0 ) $FindText.=" or ";


23


$FindText .=" SoilDesc like '%".trim($Solidstr[$i])."%' ";




}


$FindText .=" )";


}


if($pH!=""){


$pHstr=preg_spli
t("/[
\
/
\
s
\
-
]/",$pH,
-
1,PREG_SPLIT_NO_EMPTY);


$FindText .=" and (";


for($i=0;$i<count($pHstr);$i++){


if($i==0) $FindText.="";


if($i>0 ) $FindText.=" or ";


$FindText

.=" SoilDesc like '%".trim($pHstr[$i])."%' ";




}


$FindText .=" )";


}


if($Deep!=""){


$Deepstr=preg_split("/[
\
/
\
s
\
-
]/",$Deep,
-
1,PREG_SPLIT_NO_EMPTY);


$
FindText .=" and (";


for($i=0;$i<count($Deepstr);$i++){


if($i==0) $FindText.="";


if($i>0 ) $FindText.=" or ";


$FindText .=" SoilDesc like '%".trim($Deepstr[$i])."%' ";





}


$FindText .=" )";


}


if($Mottle!=""){


$Mottlestr=preg_split("/[
\
/
\
s
\
-
]/",$Mottle,
-
1,PREG_SPLIT_NO_EMPTY);


$FindText .=" and (";


for($i=0;$i<co
unt($Mottlestr);$i++){


if($i==0) $FindText.="";


if($i>0 ) $FindText.=" or ";


$FindText .=" SoilDesc like '%".trim($Mottlestr[$i])."%' ";




}


$
FindText .=" )";


}


$sql="SELECT ThSoilDB.SoilID, ThSoilDB.SoilName, ThSoilDB.SoilNameE,
ThSoilDB.SoilDesc FROM ThSoilDB where ThSoilDB.SoilDesc <>'' ".$FindText." ORDER
BY ThSoilDB.SoilID ";


$r=mysql_query($sql
) or die ("error<br>$sql");


$num=mysql_num_rows($r);


echo "<tr><td colspan=2 align='center'>ªØ´´Ô¹∙Õ辺 : $num</td></tr>";


while($row=mysql_fetch_array($r)):


echo"<tr><td>$row[1]</td><td><
input type='button' name='selectx'
value='àÅ×Í¡' onclick='selectsoil(
\
"".$row[1]."
\
");'></td></tr>";


endwhile;




?>



24


Fig
17.

Fertilizer suggestion


Example

code
:
Soi
l suggestion query
.


<?php


if($provinceid != "" and

$sltsoiltypeid != "" and $sltn != "" and $sltp != "" and $sltk != ""){




$sql = "SELECT Province_Index, Soil_ID, Plant_ID, N_VL, N_L, N_M, P_L,
P_M, P_H, K_L, K_M,






K_H, Product, Product1, Product2, DatePlant, DatePlant_e,
UpdateData, FerNote





FROM tFerCal





WHERE Province_Index = '".$provinceid."'AND Plant_ID
like 201 AND Soil_ID= '".$sltsoiltypeid."'" ;



$sql = strtolower($sql);



$result = mysql_query($sql) or die("Can not get data <br> $sql <BR>");



$noofrec = mysql_num_rows($result);



if($noofrec >0 ){



$data = mysql_fetch_array($result);




Str(Me.txt_K * 2): Me.txtSec = "46
-

0
-

0"


if($sltn== '1') $n = $data["n_vl"] ;


if($sltn== '2') $n = $data["n_l"];


if($sltn== '3') $n = $data["n_m"] ;




if($sltp== '1') $p = $data["p_l"];


if($sltp=='2') $p = $data["p_m"];


if($sltp== '3') $p = $data["p_h"];



if($sltk== '1') $k = $data["k_l"];


if($sltk== '2') $k = $data["k_m"];


if($slt
k== '3') $k = $data["k_h"];




$dateplant = $data['dateplant'];





$product = ($data['product'] + $data['product1'] +
$data['product2'])/3;




$no1 = $n."
-
".($p*2)."
-
".($k*2) ;

$rate1 = "50";




$no2 = "46
-
0
-
0";






$rate2 = (
-
1)*($n/2*100/46)*(
-
1);






$product = number_format($product, 2, '.', '');




$rate2 = number_format($rate2, 2, '.', '');



}


?>



25

Chapter

4


System Evaluation



4.1

System Evaluation




The effectiveness demonstration and evaluation of “A Development of Tailor
-
Made Fertilize
r Optimizer” concern 2 evaluation factors

1) Quality:

The program suggestion correctness.

2) Quantity:

The different of using and non
-
using program services.



Fig
18
. The evaluation point of view.


In every project case studies will also evaluate inca
se of Society, Economy
and Technology. The
demonstration and evaluation will base
attended project case
study,

1
-
2
-
3 Tailor
-
Made Fertilizer Program for the cooperative.





4
.
2

1
-
2
-
3 Tailor
-
Made Fertilizer Program for the cooperative

evaluation
.


The Fe
rtilizer suggestion program for the cooperative is program using for the
cooperative fertilizer suggestion
that service the agriculturist in form of cooperative
.



Society

Methods

Measurement of the Tailor
-
Made Fertilizer knowledge
distribution

and test f
or

the agriculturist satisfaction.


Result

1
-
2
-
3 Tailor
-
Made Fertilizer program for cooperative presented
to Sam Roi Yod cooperative (pineapple cooperative) and
this
project has
planned

to develop program for the pineapple
fertilizer tailor made suggestion
.



26

Economy


Method

Measurement of the reducing production cost of using and
non
-
using of the 1
-
2
-
3 Tailor
-
Made Fertilizer
for cooperative
program.


Results

Group of agriculturists (cooperative) can r
educe production
cost more than i
ndividual
. The result s
how as fig.19




Fig
19.

Individual and cooperative save cost comparison


Technology


Methods



Compare the step of program usage in the same case with
related

program and original (manual) use.


Results

Tailor
-
Made Fertilizer program for cooperative is fa
ster than
others.
The result show as fig.20



27


Fig20. Tailor made fertilizer solutions comparison









28


Chapter

5


Conclusion and Future Work



5.1

Conclusion




A Development of Tailor
-
Made Fertilizer Optimizer has developed into SMS
(Short Message Servic
e) service, web interface and stand alone program for the rice
and corn cooperative. This project provides 3 steps of the program usage.

1.

Registra
tion
. Register for the user profile that is the basic for the
Tailor
-
Made fertilizer suggestion.

2.

Order
ing
. Order for the Tailor
-
Made Fertilizer. In different interface
also have different ordering. E.g. Tailor
-
Made & SMS service the
ordering is the short message sending for the N
-
P
-
K soil test value.
Web interface the ordering is the N
-
P
-
K requirement fill
. Program for
the cooperative the ordering is sending of the soil example to the
cooperative for the N
-
P
-
K soil testing.

3.

Suggestion
. Suggest for the fertilizing. For the Tailor
-
Made & SMS
service program suggest by using SMS technology. For the web
i
nterface program suggest on the website. And for the Program in the
cooperative suggest by using the fertilizer ordering bill as shown in
figure

2
1
.



Fig
2
1
.

The
Fertilizer Order

Bill.







29


5.2

Future Work


1
-
2
-
3 Tailor
-
Made Fertilizer project has planned t
o
aggregate with Plant Price
Tracker, plant price delivery via mobile phone,

(as Figure 2
2
)

for

the high
effect
iveness fertilizer suggestion and price delivery
.
End user uses tailor made
fertilizer and get the production price automatically.




Fig
2
2
.

Sys
tem Architecture of Tailor
-
Made Fertilizer Optimizer

aggregate
s

with Plant Price Tracker.







30

Appendices


Appendix 1. User Manual.


Officer Login



Fig
2
3
.

Program first page


Steps






1.

Fill Username and Password


2.

Click


Register



Fig
2
4
.

Registrat
ion form



31

Steps



1.

Click


2.

Fill the information in
Figure
.
2
4


3.

Click


Ordering



Fig
2
5
.

O
rdering

form


Steps



1.

Click


2.

Click

or

for non
profile


3.

Click

to choose
varieties suggestion.



32

4.

Choose


5.

Click


6.

Click



Price update



Fig
2
6
.

Price
change

form


Steps



1.

Click


2.

Fill the new price


3.

Click


33

Appendix 2
. References.


[1]

Attanandana T., Verapattananirund P. (2004), The Nature of soils and fertilizer,
Site
-
specific nutrient management. In Proceedings of Soil Department of Faculty
of Ag
riculture, Kasetsart University, Thailand.


[2]

Kawtrakul A., Sriswasdi W., Wuttilerdcharoenwong S., Luengsrisagoon S.,
Lorsuwansiri N., Andres F. (2008) A CyberBrain: Towards the Next Generation
Social Intelligence, In Proceedings of World Conference on A
gricultural
Information and IT IAALD AFITA WCCA 2008. Tokyo, Japan.


[3]

Sriswasdi W., Luengsrisagoon S.
,
Lorsuwansiri

N.
,

Wuttilerdcharoenwong

S.
,
Khunthong

V.,
Suksaengsri

T. and
Kawtrakul

A.


(2008)
A Smart Mobilized
Fertilizing Expert System:1
-
2
-
3 Pers
onalized Fertilizer,
In Proceedings of World
Conference on Agricultural Information and IT IAALD AFITA WCCA 2008.
Tokyo, Japan.


[4]

OKNation NEWS [Online]. Available at
http://www.oknation.net/blog/print.php?id=262638

main/Download.htm (verified
July 22,
2008). OKNation, Thailand.


[4]

Xpert Solutions

[Online]. Available at http://www.smsxpert.com/Overview.aspx
(verified
October 15
, 2008).
Xpert Solutions
, India
.


[5
]
Tongpradith

R.

(2007
)
The Fresh News Delivery System
,
Department of
Computer Engineerin
g, Kasetsart University Bangkok, Thailand.


[6]

Wikipedia[Online]. Available at
h
ttp://en.wikipedia.org/wiki/Adobe_Dreamweaver (verified October 15, 2008).
In
Wikipedia, The Free Encyclopedia.


[7]

Wikipedia[Online]. Available at
http://en.wikipedia.org/wi
ki/Microsoft_SQL_Server

(verified October 15, 2008).
In Wikipedia, The Free Encyclopedia.


[8]

Wikipedia[Online]. Available at http://en.wikipedia.org/wiki/MySQL (verified
October 15, 2008).
In Wikipedia, The Free Encyclopedia.


[9]

Wikipedia[Online]. Avai
lable at http://en.wikipedia.org/wiki/Apache_server
(verified October 15, 2008).
In Wikipedia, The Free Encyclopedia.


[10]

Wikipedia[Online]. Available at http://en.wikipedia.org/wiki/MySQL (verified
October 15, 2008).
In Wikipedia, The Free Encyclopedia.


[11]
SimRice is a specific nutrient program (2007), Tasnee Attanandana(2005),
Department of Soil, Faculty of Agriculture, Kasetsart University, Thailand.


[12]Attanandana T., Verapattananirund P. (2004), The Nature of soils and
fertilizer,Site
-
specific nu
trient management. In Proceedings of Soil Department
of Faculty ofAgriculture, Kasetsart University, Thailand.


34



[12]Attanandana T., Verapattananirund P. (2004), The Nature of soils and
fertilizer,Site
-
specific nutrient management. In Proceedings of Soil D
epartment
of Faculty ofAgriculture, Kasetsart University, Thailand.


[13
]

สปก.พลิกโฉมนาข้าว
1
ล้านไร่ ปรับลด
4
ความสิ้นเปลือง
[Online]. Available at
http://www.alro.go.th/alro/alro_prov/template/picnews_2.jsp?provCode=69&acti
vityNo=41
(verified October 21
,
2008).
In
Agricultural Land Reform Office
,
Ministry of Agriculture and Cooperatives
.


[1
4
]
Sim
Corn

is a specific nutrient program (2007), Tasnee Attanandana(2005),
Department of Soil, Faculty of Agriculture, Kasetsart University, Thailand.