o
    ð:øjÏb ã                   @   s,2  d Z ddlZddlZddlZddlZddlZddlZddlmZ ej	ej
dd� ej ej e¡¡Zg d¢ZG dd„ dƒZG d	d
„ d
ƒZdd„ Zdd„ Zdd„ Zdd„ Zi dd“dd“dd“dd“dd“dd“dd “d!d"“d#d$“d%d&“d'd(“d)d*“d+d&“d,d-“d.d&“d/d0“d1d2“d3d4d5d6d7d8d9œ¥i dd:“dd;“dd<“d=d“dd>“d?d“d%d&“d@dA“dd “dBdC“d)d*“dDd(“d+d&“d.d&“dEdF“ddG“dHdI“i dJdK“dLdM“dNdM“dOdP“dQdR“dSdT“dUd"“dVdW“dXdY“dZd[“d\d&“d]d^“d_d5“d`d5“d/d0“d1d2“dad3“¥d&dbdcdddedfdgdhdidjœ	¥i ddk“ddl“ddm“d=dn“ddo“dpdq“ddr“dsdt“dHdu“dJdv“dwdx“dydz“d{d|“d}d~“dd “d€dR“d�d*“d‚dƒd„d…d†d‡dfd2d3d&dˆd‰dŠœ¥i dd‹“ddŒ“dd�“d=dŽ“dd�“dd�“d‘d’“d“d “d”d•“d–d—“d˜d™“dšd›“dœd�“džd[“dŸd “d¡d¢“d£d¤“d¥d¦d§œ¥d¨d©dmdªd«d¬d­d d®d¯d^d°d±d²d³œd´dµdmd¶d«d·d d¸d°d¹dºd»d¼d½œi dd¾“dd¿“ddm“d=dÀ“dÁd¹“dÂdÃ“dÄdÅ“dÆdÇ“dÈdÉ“dÊdË“dÌdÍ“dÎdÏ“dÐdÑ“dÒdÓ“dÔd¸“dÕd­“dÖd×“dØdÙdÚd&d dÛdÜdÝœ¥i ddÞ“ddß“ddm“d=dà“dádâ“ddã“dädå“dÂdæ“dçdT“dèdÚ“dédê“dëdì“dd “dídÙ“dîd&“dïd&“dðd&“d&dñdòd[dódôdõdöd÷œ¥i ddø“ddù“ddm“d=dú“dûdü“dd�“dýdþ“dÿd~“�d �d“�d�d“dd “�d�d“dè�d“�d�d“�d	�d
“d£d¤“�dd&“d&�d�d�dœ¥i d�d“d�d“ddm“d=�d“�d�d“�d�d“�d�d“�d�d“�d�d“�d�d“�d�d“�d�d“�d �d!“�d"�d#“dè�d$“dd “�d%�d&“�d'�d(�d)�d*�d+œ¥�d,�d-dm�d.�d/d��d0dÚ�d&dò�d1�d2dô�d3�d4�d5œ�d6�d7�d8�d9�d:�d;�d<�d=�d>�d?�d@�dA�dB�dCœ�dD�dE�dF�dG�dH�dH�dH�dH�dI�dJ�dKœ
�dL�d7�dM�dN�d:�d;�d<�d=�d>�d?�d@�dO�dP�dCœ�dQ�d7�dR�dS�d:�d;�d<�d=�d>�d?�d@�dT�dU�dCœgZg i dd“dd“d�dV“d�dW“d�dX“d�dY“d�dZ“d!d"“d#�d[“d%d&“d'�d\“d)�d]“d+d&“d,�d^“d.d&“d/d0“d1d2“d3d4d5d6�d_�d`d9œ¥‘i dd:“dd;“d�da“d�db“d?�dX“d%d&“d@�dc“d�dZ“dBdC“d)�d]“dD�d\“d+d&“d.d&“dE�dd“d�de“dH�df“dJ�dg“i dL�dh“dN�dh“dO�di“dQ�dj“dSdT“dUd"“dV�dk“dX�dl“dZd[“d\d&“d]d^“d_d5“d`d5“d/d0“d1d2“dad3“�dmd&“¥�dndcdd�dodf�dp�dq�dr�dsœ¥‘i d�dt“ddl“d�da“d�du“dp�dv“d�dw“ds�dx“dH�dy“dJ�dz“dw�d{“dy�d|“d{d|“d}dì“d�dZ“�d}�dj“�d~�d1“�d�d€“dƒd„�d��d]�d‚dfd2d3d&�dƒ�d„�d…œ¥‘i d�d†“ddŒ“�d‡�dˆ“d�d‰“d�dŠ“d‘d’“d“�dZ“d”d•“d–�d‹“d˜d™“dš�dŒ“�d��dŽ“džd¸“dŸ�d�“d¡�d�“d£�d‘“d�d’“�d“�d”d§œ¥‘d¨d©�d•�d–d¬dì�dZ�d—d×d^d°�d˜�d™�dšœ‘�d›dµ�dœ�d��dZ�džd°�dŸ�d �d•�d¡�d¢�d£œ‘i d�d¤“d�d¥“d�d•“dÁ�dŸ“dÂ�d¦“�d§dÅ“�d¨�d©“dÈ�dª“dÊdË“dÌdÍ“dÎdÏ“dÐdÑ“dÒdÓ“�d«�d¬“dÕ�d­“dÖd×“�d®�d¯“dÙdÚd&�dZ�d°�d±�d²œ¥‘i d�d³“ddß“d�d•“dá�d´“dd�“dä�dµ“dÂ�d¶“dçdT“dèdÚ“dédê“dë�d1“d�dZ“dídÙ“dîd&“dïd&“dðd&“�d·d&“�d¸dòd¸dó�d¹�dº�d»�d¼œ¥‘i d�d½“ddù“d�d•“dû�d¾“d�dŠ“dý�d¿“dÿd~“�d �d“�d�dÀ“d�dZ“�d�d“dè�d“�d�d“�d	�d
“d£d¤“�dd&“�dÁd&“�dÂ�dÃd§œ¥‘i d�dÄ“d�d“d�d•“�d�dÅ“�d�dÆ“�d�d“�d�dH“�d�dH“�d�d“�d�d“�d�d“�d �d!“�d"�d#“dè�dÇ“d�dZ“�d%�d&“�dÈ�d'“�d(�dÉ�dÊ�dËœ¥‘�dÌ�d-�d•�dÍ�dŠ�dÎdÚ�d&�dÏ�d!�d2�dÐ�dÑ�dÒ�dÓœ‘�d6�d7�d:�d;�d<�d=�d>�d?�d@�dÔ�dÕ�dÖ�d×œ‘�dD�dE�dH�dH�dH�dH�dØ�dÙ�dÚ�dÛœ	‘i d�dÜ“ddl“d�dÝ“d�dÞ“dp�dß“d�dà“ds�dá“dH�dâ“dJ�dã“dw�dä“dy�då“d{d|“d}�dæ“d�dZ“�d}�dç“�d~�dè“�d�dé“�dê�dë�dì�dí�dîdfd2d3d&�dï�dð�d…œ¥‘i d�dñ“ddŒ“�d‡�dò“d�dó“d�dô“d‘�dõ“d“�dZ“d”�dö“d–�d÷“d˜d™“dš�dø“�d��d–“dž�dù“dŸ�dú“d¡�dû“d£�d‘“d�dÝ“�dü�dýd§œ¥‘�dþd©�dÝ�dÿ�d �dæ�dZ�d#�dd^d°�d�d�dšœ‘�ddµ�dÿ�d�dZ�dd°�d�d�dÝ�d�d	�d£œ‘i d�d
“d�d¥“d�dÝ“dÁ�d“dÂ�d“�d§dÅ“�d¨�d“dÈ�d“dÊdË“dÌ�d“dÎ�d“dÐ�d“dÒ�d“�d«�d“dÕ�d“dÖdì“�d®�d“dÙdÚd&�dZ�d�d�d²œ¥‘i d�d“ddß“d�dÝ“dá�d“d�d“dä�d“dÂ�d“dçdT“dèdÚ“dédê“dë�d“d�dZ“dídÙ“dîd&“dïd&“dðd&“�d·d&“�d�dd¸dó�d�d�d �d¼œ¥‘i d�d!“ddù“d�d"“dû�d#“d�d“dý�d$“dÿd~“�d �d“�d�d%“d�dZ“�d�d&“dè�d“�d�d“�d	�d
“d£d¤“�dd&“�dÁd&“�d'�d(d§œ¥‘i d�d)“d�d“d�d"“�d�d*“�d�d+“�d�d“�d�dH“�d�dH“�d�d,“�d�d-“�d�d.“�d �dç“�d"�do“dè�dÇ“d�dZ“�d%�d&“�dÈ�d/“�d(�d0�d1�dËœ¥‘�d2�d-�d3�d4dã�d5�d6�d&�d7�dj�d2�d8�d9�d:�dÓœ‘�dL�d7�d:�d;�d<�d=�d>�d?�d@�d;�d<�d=�d×œ‘�d>�dE�dH�dH�dH�dH�d?�d@�dA�dÛœ	‘i d�dB“ddl“d�dC“d�du“dp�dD“d�dE“ds�dF“dH�dG“dJ�dH“dw�då“dyd~“d{d|“d}�dæ“d�dZ“�d}�d#“�d~dR“�d�dI“dƒ�dJ�dK�dídbdfd0d3d&�dL�dM�d…œ¥‘i d�dN“ddŒ“�d‡�dO“d�dP“d�dQ“d‘�dR“d“�dZ“d”�dS“d–�dT“d˜d™“dš�dU“�d��dV“dždR“dŸ�dW“d¡�dX“d£�dY“d�dC“�dZ�d[d§œ¥‘�d\d©�d•�d]d¬dì�dZ�d—d×d^d°�d^�d_�dšœ‘�d`dµ�da�db�dZ�dcd°�dd�de�df�dg�dh�d£œ‘i d�di“d�d¥“d�dj“dÁ�dk“dÂ�dl“�d§�dm“�d¨�dn“dÈ�do“dÊdË“dÌ�dp“dÎ�dq“dÐ�dr“dÒ�ds“�d«�dt“dÕ�d“dÖdì“�d®�du“dÙdÚd&�dZ�dv�dw�d²œ¥‘i d�dx“ddß“d�dy“dá�dz“dd�“dä�d{“dÂ�d|“dçdT“dèdÚ“dédê“dëdR“d�dZ“dídÙ“dîd&“dïd&“dðd&“�d·d&“�d}�d~�d�d€�d��d‚�dƒ�d¼œ¥‘i d�d„“ddù“d�d…“dû�d†“d�dQ“dý�d‡“dÿdì“�d �dˆ“�d�d‰“d�dZ“�d�d“dè�d“�d�d“�d	�d
“d£d¤“�dd&“�dÁd&“�dŠ�d‹d§œ¥‘i d�dŒ“d�d“d�d�“�d�d“�d�dŽ“�d�d“�d�dH“�d�dH“�d�d�“�d�d�“�d�d‘“�d dR“�d"�dj“dè�dÇ“d�dZ“�d%�d&“�dÈ�d’“�d“�d”�d•�dËœ¥‘�d–�d-�d—�d˜�dQ�dÎdÚ�d&dò�dj�d2�d™�dš�d›�dÓœ‘�dQ�d7�d:�d;�d<�d=�d>�d?�d@�dœ�d��dž�d×œ‘�dŸ�dE�dH�dH�dH�dH�d �dÙ�dÚ�dÛœ	‘Zg i dd“dd“d�d¡“dd�“d�d¢“d�d£“d�d¤“d!�d¥“d#�d¦“d%d&“d'�d§“d)�d¨“d+�d©“d,�dª“d.�d«“d/�d¬“d1�d­“�d®�d¯�d°�d±�d²�d³d9œ¥‘i d�d´“dd;“d�dµ“d=�d¶“d�d‰“d?�d¢“d%d&“d@�d·“d�d¸“dB�d¹“d)�dº“dD�d»“d+�d¼“d.�d½“dE�d¾“d�d¿“dH�dÀ“i dJ�dÁ“dL�dh“dN�dÂ“dO�dÃ“dQdR“dSdT“dU�dÄ“dV�d‚“dX�d1“dZ�dÅ“d\d&“d]d^“d_�dÆ“d`�dÇ“d/�dÈ“d1d2“da�dÉ“¥�dÊ�dË�dÌ�dÍ�dæ�dÎ�dÏ�dÐ�dÑdjœ	¥‘i d�dt“ddl“d�dÒ“d=�dÓ“d�dÔ“dp�dÕ“d�dÖ“ds�d×“dH�dØ“dJ�dÙ“dw�dÚ“dy�dÛ“d{d|“d}d×“d�d¸“d€dR“d��dí“�dÜ�dÝ�dÞ�dßd[�dà�dád2�dâ�dã�dä�dådŠœ¥‘i d�d†“ddŒ“d�dæ“d=�dç“d�dè“d�dé“d‘�dê“d“�dë“d”�dì“d˜d™“dš�dí“dœ�dî“dž�dï“d–�dð“dŸ�dñ“d¡�dò“d£�dó“�dô�dõd§œ¥‘d¨d©�dö�d÷�dø�dù�d­�d¸�dú�dûd^�dü�dý�dþd³œ‘�d›dµ�dÿ�d �d�d�d¸�dd°�d�d�d�dd½œ‘i d�d¤“d�d¥“d�d“d=�d	“dÁ�d
“dÂdÃ“dÄ�d“dÆ�d“dÈ�d“dÊdË“dÌd×“dÎ�d“dÐ�d“dÒ�d“dÔ�d¨“dÕ�d“dÖ�dï“�d�d�dd&�d¸�d�ddÝœ¥‘i d�d³“ddß“d�d“d=�d“dá�d“d�d“dä�d“dÂ�d“dç�d“dè�dÇ“dé�d“dëdì“d�d¸“dí�d“dîd&“dïd&“dðd&“d&�d�d�d �d!�d"�d#�d$d÷œ¥‘i d�d½“ddù“d�d%“d=�d&“dû�d“d�d'“dý�d(“dÿ�dæ“�d �d)“�d�d*“d�d¸“�d�d+“dè�d,“�d�d-“�d	�d.“d£�dÎ“�dd&“d&�d/�d0�dœ¥‘i d�dÄ“d�d“d�d1“d=�d2“�d�d!“�d�d3“�d�d“�d�dH“�d�d4“�d�d5“�d�d6“�d�d7“�d �d8“�d"�dj“dè�dÇ“d�d¸“�d%�d9“�d:�d;�d<�d=�d+œ¥‘�dÌ�d-�d>�d?�d@�dA�dB�dÇ�dC�dD�dE�dF�dG�dH�dI�d5œ‘�d6�dJ�dK�dL�dM�dN�dO�dPœ‘�dD�dQ�dR�dS�dÐ�dT�dH�dU�dV�dWœ	‘i d�dÜ“ddl“d�dX“d=�dY“d�dZ“dp�d[“d�d\“ds�d]“dH�d^“dJ�d_“dw�d“dy�dÚ“d{d|“d}dì“d�d¸“d€dR“d��dí“�d`�dÝ�dÞ�dad[�dà�dád2�dâ�dã�db�dcdŠœ¥‘i d�dñ“ddŒ“d�dd“d=�de“d�df“d�dg“d‘�dh“d“�dë“d”�di“d–�dj“d˜d™“dš�dø“dœ�dG“džd­“dŸ�dk“d¡�dò“d£�dó“�dl�dmd§œ¥‘�dþd©�dn�do�dp�dù�d­�d¸�d—�dd^�dq�dr�dsd³œ‘�ddµ�dt�du�dv�dw�d¸�dx�dy�d�dz�d{�d|d½œ‘i d�d
“d�d¥“d�d}“d=�d~“dÁ�d
“dÂ�d“dÄ�d“dÆ�d€“dÈ�d�“dÊ�d‚“dÌd×“dÎ�dx“dÐ�dƒ“dÒ�d„“dÔ�d…“dÕ�d†“dÖ�dï“�d�d�dd&�d¸�d‡�dˆdÝœ¥‘i d�d“ddß“d�d‰“d=�dŠ“dá�d“d�d‹“dä�dŒ“dÂ�d�“dç�d“dè�dÇ“dé�d“dëd×“d�d¸“dí�d“dî�dŽ“dïd3“dð�d�“d3�d�d�d��d!�d‘�d’�d“d÷œ¥‘i d�d!“ddù“d�d”“d=�d•“dû�d“d�d–“dý�d—“dÿ�d­“�d �d)“�d�d˜“d�d¸“�d�d+“dè�d,“�d�d-“�d	�d.“d£�dÎ“�d�d™“�dš�d›�dœ�dœ¥‘i d�d)“d�d“d�d�“d=�dž“�d�d!“�d�dŸ“�d�d“�d�d“�d�d “�d�d5“�d�d¡“�d�d¢“�d �d“�d"�dj“dè�dÇ“d�d¸“�d%�d9“�d:�d;�d£�d¤�d+œ¥‘�d2�d-�d¥�d¦�d@�d§�d¨�dÇ�dC�dD�d©�dF�dª�d«�d¬�d5œ‘�dL�dJ�d­�d®�d¯�d°�d±�dPœ‘�d>�dQ�d²�d³�d´�dµ�d¶�dH�d·�d¸�dKœ
‘i d�dB“ddl“d�d¹“d=�dº“d�d»“dp�d¼“d�d½“ds�d¾“dH�d¿“dJ�dÀ“dw�dÁ“dy�d“d{d|“d}�dæ“d�d¸“d€dR“d��dÂ“�dÃ�dÄ�dÞ�dÅd†�d‚�dád2�dâ�dÆ�dÇ�dÈdŠœ¥‘i d�dN“ddŒ“d�dÉ“d=�dÊ“d�dË“d�dÌ“d‘�dÍ“d“�d¸“d”�di“d–�dÎ“d˜d™“dš�dÏ“dœ�dÐ“�dÑ�dÚ“dŸ�dÒ“d¡�dò“�d‡�dÓ“�dó�dÔ�dÕ�dËœ¥‘�d\d©�dÖ�d×�dØ�dù�d­�d¸�dÙ�dÚd^�dÛ�dÜ�dÝd³œ‘�d`dµ�dÞ�dß�dà�dá�d¸�dâ�dã�d�dä�då�dæd½œ‘i d�di“d�d¥“d�dç“d=�dè“dÁ�d
“dÂ�dé“dÄ�d“dÆ�dê“dÈ�dë“dÊ�d‚“dÌd×“dÎ�dâ“dÐ�dì“dÒ�dí“dÔ�dù“dÕd×“dÖ�dï“�d�d�dd&�d¸�dî�dïdÝœ¥‘i d�dx“ddß“d�dð“d=�dñ“dá�d“d�dò“dä�dó“dÂ�d“dç�d“dè�dÇ“dé�d“dëdì“d�d¸“dí�d“dî�dŽ“dïd3“dð�d�“d3�dô�d�d �d!�d"�dõ�död÷œ¥‘i d�d„“ddù“d�d÷“d=�dø“dû�d“d�d'“dý�dù“dÿ�dæ“�d �dú“�d�d*“d�d¸“�d�d+“dè�d,“�d�d-“�d	�d.“d£�dÎ“�d�d™“�dû�dü�dý�dœ¥‘i d�dŒ“d�d“d�dþ“d=�dÿ“�d�d!“�d�d3“�d�d“�d�d“�d�d4“�d�d5“�d�d6“�d�d7“�d �d8“�d"�dj“dè�dÇ“d�d¸“�d%�d9“�d:�d;�d �d�d+œ¥‘i d�d–“d�d-“�d�d“d�d“d=�d“�d�d@“d�d¿“dÂ�dB“dè�dÇ“�d�dC“�d�dD“�d	�dE“�d
�dF“dœ�dG“�d�d“�d�d“‘�dQ�dJ�d�d�d�d�d�dPœ‘�dŸ�dQ�d�d�d�dÐ�d�dH�d�d�dKœ
‘Zi dd“d�d“d�d“dd“d�d“dd “d!d"“d#�d“d%d&“�d�d“�d�d“d+d&“d,d[“d.d&“d/d0“d1d2“dad3“d4�d d6d�d!œ¥i dd“d�d"“d�d“dd“d�d“dd “d!d"“d#�d#“d%d&“�d�d!“�d�d“d+d&“d,�dè“d.d&“d/d0“d1d2“dad3“d4�d d6d�d!œ¥i dd“d�d$“d�d“dd“d�d“dd “d!d"“d#�d“d%d&“�d�d“�d�d“d+d&“d,d[“d.d&“d/d0“d1d2“dad3“d4�d d6d�d!œ¥i dd“d�d%“d�d“dd“d�d“dd “d!d"“d#�d“d%d&“�d�d“�d�d“d+d&“d,d[“d.d&“d/d0“d1d2“dad3“d4�d d6d�d!œ¥i dd“d�d&“d�d“dd“d�d“dd “d!d"“d#�d'“d%d&“�d�d(“�d�d)“d+d&“d,�d*“d.d&“d/d0“d1d2“dad3“d4�d d6d�d!œ¥i dd;“d�d+“d�d,“�d-�d.“�d/d&“d@�d0“dd “dB�d1“�d2�d3“�d4�d5“d+d^“d.d^“�d6�d7“d�d8“dH�d9“dJ�d:“dL�d5“i dN�d;“�d�d<“dSdT“dUd"“�d=�dà“�d>�d…“�d?d[“dZd×“d\d^“d]d^“d_�d@“d`�dA“d/d0“d1d2“dad3“�dmd&“�dBd[“¥�dC�dD�dE�dF�dG�dH�dI�dJd:�dKœ	¥i ddl“d�dL“d�d,“dp�dM“d�dN“ds�dO“dH�dP“dJ�d:“dw�dQ“dy�dº“d}d­“dd “�dR�do“�dS�dT“�d�dU“�dV�dW“�dXd^“�dGd†d‡�dFd2d3d&dk�dYœ¥i ddl“d�dZ“d�d,“dp�dM“d�dN“ds�dO“dH�dP“dJ�d:“dw�dQ“dy�dº“d}d­“dd “�dR�do“�dS�dT“�d�dU“�dV�dW“�dXd^“�dGd†d‡�dFd2d3d&dk�dYœ¥i ddl“d�d[“d�d,“dp�dM“d�dN“ds�dO“dH�dP“dJ�d:“dw�dQ“dy�dº“d}d­“dd “�dR�do“�dS�dT“�d�dU“�dV�dW“�dXd^“�dGd†d‡�dFd2d3d&dk�dYœ¥i ddl“d�d\“d�d,“dp�dM“d�dN“ds�dO“dH�dP“dJ�d:“dw�dQ“dy�dº“d}d­“dd “�dR�do“�dS�dT“�d�dU“�dV�dW“�dXd^“�dGd†d‡�dFd2d3d&dk�dYœ¥i ddl“d�d]“d�d,“dp�dM“d�d8“ds�d7“dH�d9“dJ�d:“dw�d^“dy�d_“d}d~“dd “�dR�do“�dS�dT“�d�d`“�dV�dW“�dad^“�dG�dbd‡�dFd2d3d&dk�dYœ¥i ddŒ“d�dc“�d‡�dd“d�de“dd�“d‘�df“d“d “d”�dg“d–�dh“dš�di“dœ�dj“�dk�d†“dŸd “�dl�dm“d¡�dd“d£�dF“dd‹“i ddŒ“d�dn“�d‡�dd“d�de“dd�“d‘�df“d“d “d”�dg“d–�dh“dš�di“dœ�dj“�dk�d†“dŸd “�dl�do“d¡�dd“d£�dF“dd‹“i ddŒ“d�dp“�d‡�dd“d�de“dd�“d‘�df“d“d “d”�dg“d–�dh“dš�di“dœ�dj“�dk�d†“dŸd “�dl�dq“d¡�dd“d£�dF“dd‹“i ddŒ“d�dr“�d‡�dd“d�de“dd�“d‘�df“d“d “d”�dg“d–�dh“dš�di“dœ�dj“�dk�d†“dŸd “�dl�ds“d¡�dd“d£�dF“dd‹“i ddŒ“d�dt“�d‡�dd“d�de“dd�“d‘�df“d“d “d”�dg“d–�dh“dš�du“dœ�dv“�dk�dæ“dŸ�d�“�dl�dw“d¡�dd“d£�dF“dd‹“gZdS (x  aï  
blockchain_logic.py

Provides a simple educational blockchain-like data structure for traceability
of shrimp supply chains. This module includes:

- Block: lightweight block object
- Blockchain: chain manager that persists blocks to a sqlite DB
- Helper functions to query and traverse chains
- Sample lineages for P. vannamei (extended with 32 blocks), P. monodon, P. indicus
- Full KDEs and sequential Unique Blockchain / Secondary IDs.

Author: Generated for user (updated)
Date: 2025-10-22
é    N)Údequez%(levelname)s: %(message)s)ÚlevelÚformat)úBroodstock FacilityúHatchery-NurseryúGrow-out SystemÚ
Harvestingú Aggregation/Trading at Farm GateÚTransportationúProcessing (direct from farms)Ú	ExportingÚ	MarketingÚ	RetailingzShrimp on a plateúProduction of feed & inputsz!Shrimp on a plate (Customer View)c                   @   s(   e Zd Zd
dd„Zddd„Zdd„ Zd	S )ÚBlockr   c                 C   s.   || _ || _|| _|| _|| _|| _|| _d S ©N)ÚindexÚ	timestampÚtransactionsÚ	prev_hashÚstageÚdata_idÚnonce)Úselfr   r   r   r   r   r   r   © r   úblockchain_logic.pyÚ__init__*   s   zBlock.__init__Fc                 C   sV   | j t| jtjƒr| j ¡ n| j| j| j| j| j| j	dœ}|r)t
| dƒr)| j|d< |S )N)r   r   r   r   r   r   r   Úhash)r   Ú
isinstancer   ÚdatetimeÚ	isoformatr   r   r   r   r   Úhasattrr   )r   Úinclude_hashÚdr   r   r   Úto_dict-   s
    ÿzBlock.to_dictc                 C   s    t  tj|  ¡ dd� ¡ ¡ ¡ S )NT)Ú	sort_keys)ÚhashlibÚsha256ÚjsonÚdumpsr$   ÚencodeÚ	hexdigest©r   r   r   r   Úcompute_hash2   s    zBlock.compute_hashN)r   )F)Ú__name__Ú
__module__Ú__qualname__r   r$   r-   r   r   r   r   r   )   s    

r   c                   @   sˆ   e Zd Zddd„Zdd„ Zdd„ Zdd	„ Zed
d„ ƒZdd„ Z	d dd„Z
dd„ Zdd„ Zdd„ Zdd„ Zd!dd„Zd"dd„Zdd„ ZdS )#Ú
BlockchainNc                 C   s@   t j |¡r|nt j t|¡| _|| _g | _|  ¡  |  	¡  d S r   )
ÚosÚpathÚisabsÚjoinÚBASE_DIRÚdb_nameÚsample_lineageÚchainÚ
load_chainÚcreate_genesis_block)r   r7   r8   r   r   r   r   6   s    zBlockchain.__init__c              
   C   sü   g | _ d }zpzJt | j¡}| ¡ }| d¡ | d¡ ¡ D ]1}|\}}}}}}	}
}ztj |¡}W n   |}Y t	||t
 |¡||	|
|ƒ}||_| j  |¡ qW n tyj } zt d|› �¡ W Y d }~nd }~ww W |rt| ¡  d S d S |r}| ¡  w w )Nz¤CREATE TABLE IF NOT EXISTS blocks(index_ INTEGER PRIMARY KEY,timestamp TEXT,transactions TEXT,prev_hash TEXT,nonce INTEGER,stage TEXT,data_id TEXT UNIQUE,hash TEXT)z(SELECT * FROM blocks ORDER BY index_ ASCzLoad error )r9   Úsqlite3Úconnectr7   ÚcursorÚexecuteÚfetchallr   Úfromisoformatr   r(   Úloadsr   ÚappendÚ	ExceptionÚloggingÚerrorÚclose)r   ÚconnÚcÚrÚiÚtÚtrÚphÚnÚstÚdiÚstored_hashÚtsÚbÚer   r   r   r:   :   s"   

ú*€ €$zBlockchain.load_chainc                 C   sð   zrz0t  | j¡}| ¡ }| ¡ }| d|j|d t |d ¡|j	|j
|j|j| ¡ f¡ | ¡  W n, t jyD   t d|j› �¡ Y n! ty] } zt d|› �¡ W Y d }~nd }~ww W | ¡  d S W | ¡  d S W | ¡  d S | ¡  w )Nz*INSERT INTO blocks VALUES(?,?,?,?,?,?,?,?)r   r   zDuplicate block zSave error )r<   r=   r7   r>   r$   r?   r   r(   r)   r   r   r   r   r-   ÚcommitÚIntegrityErrorrE   ÚwarningrD   rF   rG   )r   rT   rH   rI   r#   rU   r   r   r   Ú
save_blockI   s   D$*€ þýþzBlockchain.save_blockc                 C   sv   | j s-tdtj ¡ dddddidœgdddƒ}| ¡ |_| j  |¡ |  |¡ |  ¡  d S t	 
dt| j ƒ› d	�¡ d S )
Nr   ÚSystemÚGenesisÚIDúGENESIS-BLOCK©ÚsenderÚ	recipientÚamountÚdataÚ0zLoaded ú blocks)r9   r   r   Únowr-   r   rC   rY   Úadd_sample_datarE   ÚinfoÚlen)r   Úgr   r   r   r;   Q   s   (,zBlockchain.create_genesis_blockc                 C   s
   | j d S )Néÿÿÿÿ)r9   r,   r   r   r   Ú
last_blockV   s   
zBlockchain.last_blockc                 C   s    ||_ | j |¡ |  |¡ dS )NT)r   r9   rC   rY   )r   rT   Úpr   r   r   Ú	add_blockX   s     zBlockchain.add_blockÚ0000c                 C   s<   d|_ | ¡ }| |¡s| j d7  _ | ¡ }| |¡r|S )Nr   é   )r   r-   Ú
startswith)r   rT   ÚdiffÚhr   r   r   Úproof_of_workY   s   *zBlockchain.proof_of_workc                 C   s"   t |dd ƒ}|s| ¡ }||_|S )Nr   )Úgetattrr-   r   )r   rT   rr   r   r   r   Ú
block_hash]   s   zBlockchain.block_hashc                 C   sh   |sd S t |ƒ ¡ }| jD ]}t |jƒ|kr|  S q| ¡ }| jD ]}t |jƒ ¡ |kr1|  S q"d S r   )ÚstrÚstripr9   r   Úlower)r   r   ÚtargetrT   Útarget_lowerr   r   r   Úget_block_by_data_idb   s   

zBlockchain.get_block_by_data_idc                 C   s:   |sd S t |ƒ ¡ }| jD ]}|  |¡|kr|  S qd S r   )rv   rw   r9   ru   )r   ru   ry   rT   r   r   r   Úget_block_by_hashk   s
   
zBlockchain.get_block_by_hashc                    s,   ˆ d u rg S |   ˆ ¡‰‡ ‡fdd„| jD ƒS )Nc                    s"   g | ]}|ˆ ur|j ˆkr|‘qS r   )r   ©Ú.0rT   ©ÚblockÚparent_hashr   r   Ú
<listcomp>t   s   " z*Blockchain.children_of.<locals>.<listcomp>)ru   r9   )r   r€   r   r   r   Úchildren_ofq   s   
zBlockchain.children_ofc                 C   sž   |pi }d }|r|   |¡}|d u r0|}|s)| d¡p(| d¡p(| d¡p(| d¡}|r0|  |¡}|d u rJ| d¡pB| d¡pB| d¡}|rJ|   |¡}|pN| jS )NÚparent_batch_idzParent Batch IDÚ	parent_idz	Parent IDr   Úprevious_hashzPrevious Hash)r|   Úgetr{   rk   )r   r�   r…   rb   ÚparentÚpidrN   r   r   r   Úresolve_parentu   s*   
ÿÿ
ÿ

zBlockchain.resolve_parentc           	         sÒ   |  d¡p|  d¡p|  d¡p|  d¡pdtj ¡  ¡ › �‰ t‡ fdd„| jD ƒƒr.d ˆ fS | j|||d�}td	d„ | jD ƒd
d�d }t|tj ¡ d|d|dœg|  	|¡|ˆ ƒ}|  
|¡}|  ||¡ |jˆ fS )Nr\   ú	Unique IDz
Unique ID úBatch NoÚNO_ID_c                 3   s   � | ]}|j ˆ kV  qd S r   )r   )r~   Úx©Údidr   r   Ú	<genexpr>‰   s   € z"Blockchain.mine.<locals>.<genexpr>)r�   r…   rb   c                 s   s   � | ]}|j V  qd S r   )r   r}   r   r   r   r‘   ‹   s   € rj   )Údefaultro   rZ   r^   )r‡   r   re   r    Úanyr9   rŠ   Úmaxr   ru   rs   rm   r   )	r   r   rb   r�   r…   rˆ   Ú	new_indexÚnbÚpfr   r�   r   Úmine‡   s   < * zBlockchain.minec                 C   sÂ   t | jƒdkr]| jr_t d| j› dt | jƒ› d�¡ | jD ].}t|ƒ}| dd ¡}z|  ||¡ W q t	yK } zt 
d|› �¡ W Y d }~qd }~ww t | j› dt | jƒ› d�¡ d S d S d S )	Nro   zPopulating z with z stagesr   zMine error z	 now has rd   )rh   r9   r8   rE   rg   r7   ÚdictÚpopr˜   rD   rF   )r   r#   ÚddrP   rU   r   r   r   rf   Ž   s    
*€ "úzBlockchain.add_sample_datar   )rn   )NNN)NN)r.   r/   r0   r   r:   rY   r;   Úpropertyrk   rm   rs   ru   r{   r|   rƒ   rŠ   r˜   rf   r   r   r   r   r1   5   s     


	

r1   c                 C   s:   z|   d¡p|   di g¡d   di ¡  d¡W S    Y d S )Nr   r   r   rb   r\   )r‡   )rT   r   r   r   Úget_batch_id_from_block—   s   .r�   c                 C   s*   |D ]}t | ¡ ƒ| kr| ¡   S qd S r   ©r�   r$   )rK   rI   rT   r   r   r   Úfind_block_by_data_idš   s   rŸ   c                 C   sˆ   dd„ |D ƒ}t | |ƒ}|sg S g }| }|rB|dkrB| |¡}|s#|S | d|¡ z|d d d d }W n   Y |S |rB|dks|S )Nc                 S   s   i | ]}t | ¡ ƒ| ¡ “qS r   rž   r}   r   r   r   Ú
<dictcomp>Ÿ   s    z-get_product_lineage_trace.<locals>.<dictcomp>r]   r   r   rb   r„   )rŸ   r‡   Úinsert)ÚsrI   Úid_mapÚblkÚresÚcidrT   r   r   r   Úget_product_lineage_tracež   s   

ýúr§   c                 C   sÎ   i }i }|D ]*}|  ¡ }t|ƒ}|||< z|d d d d }|r*| |g ¡ |¡ W q   Y qg }| g}	| h}
|	re|	 d¡}| |¡}|rL| |¡ | |g ¡D ]}||
vrb|
 |¡ |	 |¡ qR|	s;|S )Nr   r   rb   r„   )r$   r�   Ú
setdefaultrC   rš   r‡   Úadd)r¢   rI   ÚpmapÚimaprT   ÚbdÚbidr‰   ÚoutÚqÚvr¦   ÚcbÚchr   r   r   Úget_product_lineage_forwardª   s"   €
€ür³   r   r   úStakeholder/CustodianzNBC/BMC/Brood Bank operatorr‹   Ú301123100001010125zNFDP Reg NoÚNFDP1001zFacility NamezM/s. KonabayÚAddressz^Sunrise Capital, Inc. dba Kona Bay Marine
Resources, P.O. Box No.1282, Kekaha,Kauai, Hi 96752 ÚSpecieszP. vannameizGenetic selectionÚSPFzDate of receiptz2025-04-15 00:00:00zDoF approvedÚYeszQuantity of broodsÚ130zSize of broods (g)Ú40ÚImportúSurvival rate (%)z88.8Ú
QuarantinezHealth certificatezWOAH listed diseases freeúDisease outbreakÚNoneÚ	AvailableÚDomesticatedÚStandardÚVerifiedÚ251021010128025504Ú251021010199984591)úDisease mitigation protocolÚSourceúFeeding regimeú
SPF statusúUnique Blockchain IDúUnique Secondary IDr   zHatchery/Nursery operatorÚAP5690961001010125r„   ÚNFDP2001zBroodstock supplierzMPEDA enrolmentÚ	MPEDA5001z
Life stageÚ
BroodstockzQuantity of broods (No.)zHatchery detailsz%M/s. Sree Vyjayanthee Hatcheries LLP.zJBatti somaiahpalem, Karedu, Ulavapadu Mandal, SPSR Nellore, Andhra PradeshzLocation (GPS coordinates)z15.150090, 80.060336zCAA approvalz56-9(96)/2019zCapacity (PLs No.)Ú	100000000z!Seed production details (PLs No.)ÚDatez2025-01-20 00:00:00zPL age (days)Ú12ÚGenderÚMixedzGenetic strainz$Survival rate of nauplii and PLs (%)z89.7 and 58zLarval tank size (MT)Ú1000zLarval density (per L)Ú100zUse of probioticszUse of antibioticsÚNoz
Light logszAeration logsrÈ   Ú95zStarter feedzBio-supplementsÚ140zICAR-CIBA verifiedu.   Temp 28Â°C, pH 7.8, DO 6 mg/L, Salinity 23 pptÚ251021010264928514Ú251021010245186359)	úBiosecurity measuresúHatchery success rate (%)úFeed detailsÚInputsúEffluent treatment system (MT)ÚCertificationúWater qualityrÌ   rÍ   r   zFarmer/Farm ownerÚAP5690960101010125zVAN1-GROW-001ÚNFDP3001z	Farm NamezGreekay farmzHPudiparthi village, Venkatachalam, SPSR Nellore, Andhra Pradesh - 524321ÚOwnerz>Mrs. Kanupuru Jayalakshmi, W/o. Mr. Kanupuru Sunil Kumar Reddyz14.225910, 80.001002zAP-II 2022(20690)zFarm size (ha)z0.72zWater spread area (ha)z0.43zType of culture systemz7Traditional, Semi-intensive, Intensive, Super-IntensivezPonds (No.)Ú2zSpecies farmedzPLs age (days)zStocking density (per sq. mt.)z2025-02-01 00:00:00zPellet feedÚ
Probioticsu   Temp 29Â°C, pH 7.5, DO 5.5 mg/LÚ110Ú92Ú251022010300001001Ú251022010300002001)úDate of stockingÚFeedrá   rä   úCulture duration (days)r¾   rã   rÀ   rÈ   ÚBiosecurityrÌ   rÍ   r   z+Feed manufacturer/feed supplier/distributorzVAN1-FEED-001zVAN1-PROW-001ÚNFDP4001ÚChennaiz	Feed NamezLarval, starter, growerzSpecies targetedÚIngredientszFish meal, Soy proteinzNutritional profilez:Crude protein 36%; Fat 5%; Fibre 5%; Ash 15%; Moisture 11%ÚFCRz
1.1 to 1.5zManufacture Datez2025-01-30 00:00:00úExpiry datez2025-04-29 00:00:00z#Quantity of feed available (Tonnes)rŒ   ÚB101ÚSupplierzAquaFeed Pvt Ltdrã   ÚHACCPÚ251022010300001002Ú251022010300002002)rÌ   rÍ   zHarvesting-1zFarmer/Farm owner/AggregatorzVAN1-HARV-001z2025-05-21 00:00:00zDrag netÚ1z25.1z4.1z
Yes & goodÚ251022010300001003Ú251022010300002003)r   r´   r‹   r„   úHarvesting DateÚMethodúDuration (h)r¸   úAvg Body Weight (g)úTotal production (Tonnes)úPartial harvestingúIced used & qualityrÌ   rÍ   r	   zAggregator/TraderzVAN1-AGG-001zNellore Shrimp TradersÚ50zCold Chain LtdzA - 30; B - 20Ú251022010300001004Ú251022010300002004)r   r´   r‹   r„   ú
Trade DateÚ
Aggregatorr¸   úQuantity (Tonnes)úIce used & qualityúNext custodianúGrade wise quantity (Tonnes)rÌ   rÍ   r
   zCold chain operatorzVAN1-TRANS-001ÚTransporterÚContactÚ
9876543210z
Truck typezRefrigerated TruckzTransport licenseÚTRK123z
Vehicle IDzVH001; VH002zVehicle sanitation logÚOKzVehicle capacity (Tonnes)z20-30zWeight transported (Tonnes)z20; 30zName of the driverzMr. KandasamyzContact detailÚ
8056006399zDistance (km)r  zLoading and unloading time (h)Ú3z14.468515, 80.039072ÚIcedu   4Â°CÚ251022010300001005Ú251022010300002005)úGPS logÚ	ConditionúTemperature at packingúTemperature data loggerr¸   rÌ   rÍ   r   zDistributor/WholesalerzVAN1-MARK-001ÚNamezNellore Fish MarketÚNellorezGPS coordinatez14.464770, 80.008052Ú
9299808577ÚSellerÚTemperaturez
Stall typeÚPlatformzNo. of stallsÚ4r  ÚHygienezDrainage facilityzWaste disposalz2; 5 tonnesÚAquaMartÚ	Retailersz2025-06-01 00:00:00Ú251022010300001006Ú251022010300002006)úPotable water facilityúIce plant (No. & capacity)ú
e-CommerceúQuantity sold (kg)ÚBuyerúExpiry/use-by daterÌ   rÍ   r   Ú	ProcessorzVAN1-PROC-001zProcessing PlantzSeaFresh LtdzApproval NoÚPL1234zCapacity (Tonnes/day)zProcessor credentialsÚ	CertifiedzDate and Time of receiptz2025-05-22 10:00:00zProduct typeÚIQFu   0-4Â°CÚ	EquipmentÚFreezersÚ	PackagingÚBulkzWater availabilityÚ251022010300001007Ú251022010300002007)úWaste managementrÌ   rÍ   r   ÚExporterzVAN1-EXP-001zOceanic ExportszIEC CodeÚIEC5001zExport modeÚSeaÚAirlinezN/Az#Place of embarkation/disembarkationzShipping liner nameÚCOSCOz Country of loading and unloadingzIndia and ChinazDate and timez2025-05-30 06:00:00zTransport duration (days)Ú15zContainer size (Tonnes)Ú25u   18Â°CÚCategoryzReady-to-cookÚ30617z�ICAR-CIBA, EIC, Phytosanitary, BIS, SHAPHARI, FSSAI, HACCP, CATCH IT, ASC, BAP, Global GAP, GAA, GDST, ICCAT, DS 2031, CoO, Non-radioactivityÚ251022010300001008Ú251022010300002008)úITC-HS Coderã   rÌ   rÍ   r   zRetailer/E-commerce vendorzVAN1-RET-001Ú
AquaRetailÚ
9876501234Ú10Ú	ConsumersÚ251022010300001009Ú251022010300002009)r   r´   r‹   r„   úRetailer Namer·   r  r!  úProduct categoryr+  r,  r-  rö   rÌ   rÍ   zShrimp on a plate-1ÚConsumerÚAP5690960101010189zVAN1-PLATE-001zFresh/spoiledzFresh/fishy/ammoniaz	Good/PoorzLeathery/SmoothzYes/NozIntact & UniformzCorrect/IncorrectÚ251022010300001010Ú251022010300002010)r   r´   r‹   r„   ÚFreshessÚSmellÚ
AppearanceÚTextureúBlack spotsúShape and sizeÚWeightrÌ   rÍ   z#Shrimp on a plate (Customer View)-1ÚCustomerÚAP5690860101010165zVAN1-Cus PLATE-001Ú Ú251022010300001011Ú251022010300002011)
r   r´   r‹   r„   úCustomer NameúPurchase DateúFeedback LinkúTemperature at DeliveryrÌ   rÍ   zShrimp on a plate-2ÚAP5690960106350189zVAN2-PLATE-002Ú251022010300002109Ú251022010300011109zShrimp on a plate-3ÚAP5690960101010721zVAN3-PLATE-003Ú251022010300002119Ú251022010300011119Ú301123200001010125ÚNFDP1002z$M/s CP SPF Foods Public Company Ltd.z'Amphoe Laem Sing, Chanthaburi, Thailandz
P. monodonz2025-04-16 00:00:00Ú380Ú125z88.7Ú251021020148959336Ú251021020183824383ÚTN5692382001010125ÚNFDP2002Ú	MPEDA5002zM/s. Vishal Aqua GLV PrawnzQBharathidasan street, Kanathur Reddikuppam, Thirupporur, Chengalpattu, Tamil Naduz12.853136, 80.248843z56-9(238)/2024Ú2000000z2025-01-22 00:00:00Ú20z	89 and 45Ú200rÞ   Ú94Ú28u0   Temp 27.5Â°C, pH 7.7, DO 6 mg/L, Salinity 24 pptÚ251021020202900191Ú251021020238879790)rß   rà   rá   râ   rã   rä   rÌ   rÍ   zGrow-out System-1ÚNFDP3002zSelvaraj farmzfOld No:4/268, New No:8/268, Veerankudikadu, South Poigainallur (PO), Nagapattinam, Tamil Nadu - 611111zSelvaraj. Kz10.703866, 79.826911zTN-II 2022(2153)z1.93z1.15zPLs agezStocking densityrî   z2025-02-03 00:00:00u!   Temp 29.5Â°C, pH 7.6, DO 5.8 mg/LÚ87Ú251021020370335984Ú251021020366811498)rï   rá   rä   rð   r¾   rã   rÀ   rÈ   rñ   rÌ   rÍ   zProduction of feed & inputs-1zManufacturer NamezOceanFeed LtdÚNFDP4002ÚKochiz;Crude protein 35%; Fat 10%; Fibre 5%; Ash 15%; Moisture 11%z2025-02-05 00:00:00ÚExpiryz2025-05-04 00:00:00ÚB102ÚMarineBroodzISO, GMP, HACCPÚ251021020453033150Ú251021020440332255Ú251021020484133556ÚTN5692380101010125z2025-06-05 00:00:00Ú30Ú251021020586623019Ú251021020502497964)r   r´   r‹   rÿ   r   r  r¸   r  r  r  r  rÌ   rÍ   z"Aggregation/Trading at Farm Gate-1z2025-06-06 00:00:00zChennai Shrimp TradersÚ24zFresh Transport Pvt LtdzA - 20; B - 4Ú251021020649541092Ú251021020695817214)r   r´   r	  r
  r¸   r  r  r  r  r‹   rÌ   rÍ   zTransportation-1zTransporter/Cold chain operatorÚ
9444117051ÚTypeÚLicenseÚTRK124ÚVH003zDiatance (km)Ú325Ú6r  z12.9716, 80.2337Ú251021020738606447Ú251021020799837186)r  r  r  r¸   rÌ   rÍ   zMarketing-1zPattinapakkam Fish Marketz13.030356, 80.279230Ú
9003142798r)  z2; 10 tonnesz2025-06-20 00:00:00Ú251021020882849624Ú251021020838877904)r*  r+  r,  r-  r.  rÌ   rÍ   z Processing (direct from farms)-1zOceanic ProcessorsÚPL1235z2025-06-10 10:00:00r9  Ú251021020951193064Ú251021020968428447zExporting-1zGlobal Shrimp TradersÚIEC5002u   -18Â°CrE  Ú251021021011479375Ú251021021063138583)rã   rÌ   rÍ   zRetailing-1Ú
BlueRetailÚ
9876523450ÚSeaMartz2025-07-05 00:00:00Ú251021021141838943Ú251021021121329566)r   r´   r‹   rL  r·   r  r!  rM  r+  r,  r-  rö   rÌ   rÍ   Ú251021021270024594Ú251021021238105860Ú251021021280253139)r   r´   rR  rS  rT  rU  rV  rW  rX  r‹   rÌ   rÍ   Ú251021021351147728Ú251021021348555183Ú251021021308086841)	r   r´   r^  r_  r`  ra  r‹   rÌ   rÍ   zGrow-out System-2ÚAP2301020101012025ÚNFDP7001zGreenHarvest Aqua Farmz+Thotapalli Village, Nellore, Andhra Pradeshz	K. Rameshz14.4031, 79.9914zAP-III/2025(1572)z2.8z2.1Ú5Ú18Ú80z2025-03-10 00:00:00zCommercial pellet feedzProbiotics, molassesu   Temp 30Â°C, pH 7.6, DO 5.9 mg/LÚ120Ú86Ú251021020370335970Ú251021020366811471zProduction of feed & inputs-2zAquaNutra Feed MillsÚNFDP8001zGudur, Nellore DistrictzVannamei grower feedz$Fish meal, soya protein, wheat flourz1Crude Protein 38%; Fat 7%; Fibre 5%; Moisture 10%z2025-03-05 00:00:00Ú70ÚBW3025zAquaSupply Pvt. Ltd.Ú251021020440332273Ú251021020484133574zHarvesting-2z2025-07-10 00:00:00zCast netz3.5Ú251021020586623075Ú251021020502497976z"Aggregation/Trading at Farm Gate-2zCoastal Aqua TraderszBlueOcean Logisticsz
A-2.5; B-1Ú251021020649541077Ú251021020695817278zTransportation-2Ú
9445899632ÚTRK240ÚVH008z10-20z10; 20Ú
NarasimuluÚ
8056116399Ú300Ú7z13.0827, 80.2707Ú251021020738606479Ú251021020799837180zMarketing-2zNellore Coastal Fish MarketzNellore, Andhra Pradeshz14.4286, 80.1025Ú8z2; 8 tonnesÚAquaFreshMartz2025-07-26 00:00:00Ú251021020882849681Ú251021020838877982z Processing (direct from farms)-2ÚAP7894560202020256zCoastal Aqua ExportsÚNL4589z2025-06-15 11:30:00zIQF (Individually Quick Frozen)Ú251021020951193083Ú251021020968428484zExporting-2zNellore Aqua ExportsÚIEC6025zMaersk LinezIndia and Japanz2025-06-05 07:30:00Ú50982Ú251021021011479385Ú251021021063138586zRetailing-2ÚAP230102010202025zCoastal Fresh MartÚ
9012345678u   5Â°CÚAquaDelightz2025-07-15 00:00:00Ú251021021141838987Ú251021021121329588Ú251021021270024593Ú251021021238105889Ú251021021280253190z#Shrimp on a plate (Customer View)-2Ú251021021351147794Ú251021021348555191Ú251021021308086892zGrow-out System-3ÚTN5692382001010456zM/s BlueWave Aqua HatcheryuP   No. 12, Kattukuppam Road, Chidambaram, Cuddalore District, Tamil Nadu â€“ 608001zRamesh Kz11.420123, 79.695432zTN-II 2023(1245)z2025-03-12 00:00:00zProbiotics, Bio-supplementsu4   Temp 28Â°C, pH 7.8, DO 6.2â€¯mg/L, Salinity 23â€¯pptÚ251021020370335955Ú251021020366811456zProduction of feed & inputs-3zAquaNutri Pvt. Ltd.ÚNFDP4005zChennai, Tamil NaduzLarval, starterz#Fish meal, Wheat flour, Soy proteinz1Crude Protein: 38%, Fat: 9%, Fibre: 4%, Ash: 12%,z2025-10-03 00:00:00z05-05-2025 00:00:00ÚLN101ÚCoastalBroodz
ISO, HACCPÚ251021020440332292Ú251021020484133593zHarvesting-3z2025-05-06 00:00:00Ú251021020586623025Ú251021020502497926z"Aggregation/Trading at Farm Gate-3z2025-06-08 00:00:00zCooum Shrimp TradersÚ35z!Southern Marine Transport Pvt LtdzA - 20; B - 15ÚTN5692380101010131Ú251021020649541035Ú251021020695817236zTransportation-3ÚTN5692380101010134zBayline Transport Pvt LtdÚ
9444223344zRefrigerated VanÚTRK256ÚVH007z25-35z25; 35z
Mr. RameshÚ
8056123456Ú350z12.9876, 80.2456Ú251021020738606489Ú251021020799837190zMarketing-3ÚTN5692380101010137zMarina Fish Marketz13.045678, 80.285432Ú
9003123456z3; 12 tonnesÚSeaFreshÚ55zRetailers & Wholesalersz2025-06-21 00:00:00Ú251021020882849623Ú251021020838877903z Processing (direct from farms)-3ÚTN5692380101010142zCoastal Shrimp ProcessorsÚPL1265zCertified, HACCPz2025-06-13 08:45:00Ú251021020951193072Ú251021020968428473zExporting-3ÚTN5692380101010143ÚIEC5005ÚMAERSKzIndia, Singaporez2025-05-31 07:00:00Ú30625zFICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP, Global GAPÚ251021021011479329Ú251021021063138530zRetailing-3ÚTN5692380101010146zMarina Shrimp Retailz2025-05-08 00:00:00Ú251021021141838945Ú251021021121329546Ú251021021270024573Ú251021021238105878Ú251021021280253179z#Shrimp on a plate (Customer View)-3Ú251021021351147763Ú301125300001010125zOceanGene Broodstock Centerz2Survey No. 47/2, Krishnapatnam, SPSR Nellore, A.P.zPenaeus indicuszThird generation SPF linez2025-01-10 00:00:00Ú180Ú45zKuwait Broodstock Pvt. Ltd.Ú93z10 days, freshwater treatmentzMPEDA/HC/IND/2025/014zNone observedzRegular PCR screeningzSPF Institute, KuwaitzPolychaete + formulated feedzVerified SPF lineÚ251021030100101001Ú251021030200202001zHatchery/NurseryÚAP5693054001010125zINDI1-HAT-001zMPEDA-HAT-AP-209z
P. indicusÚPL12z0.05Ú180000zLocal from Nellorez48 hrs pre-stockingz10 tanks of 10 MT eachzMuthukur, Nellorez14.410300N,80.124500EzHATCH-AP-3021zBatch IND-HAT-25z2025-02-02 00:00:00zSPF 3rd generationÚ90z16/8 photoperiodzContinuous blowerzMPEDA/HC/IND/2025/021zChlorination + UV sterilizationzFootbath + net disinfectionÚ88zArtemia + commercial micro dietzSeawater filtered + ozonezMPEDA certifiedu   29Â°C,28 ppt salinityÚ251021030100101002Ú251021030200202002ÚTN5693054002010125zINDI1-GROW-001ÚNFDP4003zAquaCare Grow-out FarmzVenkatachalam, Nellorez	K. Sureshz14.417500N,80.034200EzFARM-AP-3012z1.2z1.0z2025-02-15 00:00:00zAvanti Feeds CP 38%zLime, probiotics, molassesu   28-30Â°C,25 pptÚ85zCAA CertifiedzBiofloc & EM applicationzPerimeter fencing, bird netsÚ251021030100101003Ú251021030200202003ÚTN5693054112010125zINDI1-PROW-001ÚNFDP4004zAPIIC Industrial Park, NellorezAvanti Marine Gold 38%zP. indicus,P. monodonzFishmeal,soybean,wheat,binderz2025-02-12 00:00:00z2026-02-12 00:00:00z0.5zCP 38%, Fat 7%, Fiber 4%ÚFEED_IND_NL25zCoastal Aqua DistributorszMPEDA Feed CertifiedÚ251021030100101004Ú251021030200202004ÚTN5693054004010125zINDI1-HARV-001z2025-05-25 00:00:00zCast net & drain harvestingÚ26z1.42z250 kg flake ice, potable waterÚ251021030100101005Ú251021030200202005ÚTN5693054005010125zINDI1-AGG-001z2025-05-26 00:00:00zSri Aqua Tradersz1.38zSeaHarvest Processing Unitz 60-70 count:0.9,71-90 count:0.48Ú251021030100101006Ú251021030200202006ÚTN5693054006010125zINDI1-TRANS-001zAquaTrans LogisticszRefrigerated (3T)z
AP-TL-2209zAP27 AQ 4502zR. VenkateshÚ
9998855544z1.5ÚEnabledÚ	Excellentu   -2Â°CÚ251021030100101007Ú251021030200202007ÚTN5693054007010125zINDI1-MARK-001zCoastal Marketing AgencyzKavali, Nellorez14.9112N,79.9941EÚ
9003114455zEnclosed cold roomÚFrozenz1 unit,3T/dayzLinked to FreshWave portalÚ1240zBlueOcean Exports Pvt. Ltd.z2026-05-25 00:00:00Ú251021030100101008Ú251021030200202008ÚTN5693054008010125zINDI1-PROC-001zSPSR Nellore Industrial ZonezMPEDA-AP-122zHACCP,BRC certifiedz2025-06-03 10:00:00zIQF P&D tail-onu   -20Â°Cz
IQF TunnelzVacuum sealedÚ251021030100101009Ú251021030200202009ÚTN5693054009010125zINDI1-EXP-001Ú
1002093388zKrishnapatnam / TokyozEvergreen MarinezIndia / Japanz2025-06-12 19:00:00Ú11zFrozen seafoodÚ03061710zEIC, MPEDA export certifiedÚ251021030100101010Ú251021030200202010ÚTN5693054010010125zINDI1-RET-001zFreshWave SeafoodszVenkatagiri,NelloreÚ
9944112233zReady-to-cook frozen shrimpzAvailable on FreshWave AppÚ800zBayView Seafood Grillz2026-06-12 00:00:00Ú251021030100101011Ú251021030200202011zConsumer / RestaurantÚTN5693054011010125zINDI1-PLATE-001z>Excellent taste and texture, clearly marked as Nellore origin.Ú251021030100101012Ú251021030200202012)r   r´   r‹   r„   ÚFeedbackrÌ   rÍ   zEnd CustomerÚAP5643054012010125z
A. Pradeepz)https://freshwave.example/feedback/IND001Ú251021030100101013Ú251021030200202013)	r   r´   r‹   r^  r_  r`  ra  rÌ   rÍ   ÚAP5697054002010125zINDI2-GROW-002ÚNFDP4403zNellore Grow-out FarmzNaidupeta,Nellorez	S. Rameshz10.760000N,79.850000EzFARM-TN-4002z2025-05-22 00:00:00u   28-30Â°C, 28 pptÚ251021070100101003Ú251021070200202003ÚAP5690960251010256zINDI2-PROW-002ÚNFDP4404zPodili,NellorezAvanti Marine Premium 40%z Fishmeal, soybean, wheat, binderzCP 40%, Fat 7%, Fiber 3%ÚFEED_TN_NP25Ú251021070100101004Ú251021070200202004ÚTN5697054004010125zINDI2-HARV-002z2025-06-28 00:00:00z280 kg flake ice, potable waterÚ251021070100101005Ú251021070200202005ÚTN5697054005010125zINDI2-AGG-002z2025-06-29 00:00:00zTamil Aqua Tradersz1.35z220 kg flake icez60-70 count:0.8,71-90 count:0.5Ú251021070100101006Ú251021070200202006ÚTN5697054006010125zINDI2-TRANS-002Ú
9876543322z
TN-TL-3301zTN27 AQ 4601zUpdated before loadingz
R. VigneshÚ
9998877442Ú60z2.5Ú251021070100101007Ú251021070200202007ÚAP5697054007010125zINDI2-MARK-002zKondapuram,Nellorez8.7650N,78.1340EÚ
9003114499z9/10zMPEDA-approvedÚ1300z2026-06-28 00:00:00Ú251021070100101008Ú251021070200202008ÚAP5697054008010125zINDI2-PROC-002zTekkali,NellorezMPEDA-TN-142z2025-07-05 10:00:00zBore + RO treatedzEffluent treatment 6 KL/dayÚ251021070100101009Ú251021070200202009ÚTN5697054009010125zINDI2-EXP-002Ú
1002093400zThoothukudi / SingaporezIndia / Singaporez2025-07-12 19:00:00Ú251021070100101010Ú251021070200202010ÚAP5697054010010125zINDI2-RET-002zVenkatapalam, NelloreÚ
9944112266Ú850z2026-07-10 00:00:00Ú251021070100101011Ú251021070200202011ÚAP5697054011010125zINDI2-PLATE-002ÚSatisfactoryÚ251021070100101012Ú251021070200202012ÚAP5697054012010125zINDI2-Cus PLATE-002z
K. Aravindz2025-07-18 00:00:00z(https://freshwave.example/feedback/TN001Ú251021070100101013Ú251021070200202013ÚAP5698054002010125zINDI3-GROW-003ÚNFDP4203zVidavalur Grow-out FarmzVidavalur, NellorezS. Murugan Reddyz9.380000N, 78.800000EzFARM-TN-5002z1.8Ú115z2025-04-20 00:00:00zAvanti Feeds CP 40%u   28-31Â°C, 27 pptz(Perimeter fencing, bird nets, net coversÚ251021050100101003Ú251021050200202003ÚAP5698054003010125zINDI3-PROW-003ÚNFDP4204zAtmakur, NellorezAvanti Marine Supreme 42%zCP 42%, Fat 8%, Fiber 3%z2025-04-25 00:00:00z2026-07-12 00:00:00z"Quantity of feed available(Tonnes)ÚFEED_TN_NP30zAvanti Feeds Pvt. Ltd.Ú251021050100101004Ú251021050200202004ÚAP5698054004010125zINDI3-HARV-003z2025-05-30 00:00:00Ú32z1.6z300 kg flake ice, potable waterÚ251021050100101005Ú251021050200202005ÚAP5698054005010125zINDI3-AGG-003z2025-05-31 00:00:00zAqua Exportsz1.4z250 kg flake icez!60-70 count:0.85,71-90 count:0.55Ú251021050100101006Ú251021050200202006ÚAP5698054006010125zINDI3-TRANS-003Ú
9876544455z
AP-TL-3401zAP28 AQ 4702zR. Senju Sai PraveenÚ
9998877555Ú251021050100101007Ú251021050200202007ÚAP5698054007010125zINDI3-MARK-003zAlluru, Nellorez8.764200,78.134500z1 unit, 3T/dayÚ251021050100101008Ú251021050200202008ÚAP5698054008010125zINDI3-PROC-003zMPEDA-AP-122-APzHACCP, BRC certifiedzEffluent treatment 5 KL/dayÚ251021050100101009Ú251021050200202009ÚAP5698054009010125zINDI3-EXP-003Ú251021050100101010Ú251021050200202010rÌ   Ú251021050100101011ÚAP5698054010010125z	INDI3-EXPrL  rM  r+  r,  r-  rÍ   Ú251021050200202011ÚAP5698054011010125zINDI3-PLATE-003zAExcellent taste and texture, clearly marked as Tamil Nadu origin.Ú251021050100101012Ú251021050200202012ÚAP5698054012010125zINDI3-Cus PLATE-003zK. Arjun Narasimha Reddyz(https://freshwave.example/feedback/AP001Ú251021050100101013Ú251022010311002011Ú3011231150A7010125zNFDP1001-XXzbSunrise Capital, Inc. dba Kona Bay Marine
Resources, P.O. Box No.1282, Kekaha,Kauai, Hi 96752, USAz2025-12-25 00:00:00zQuantity of broods (in pairs)Ú150z#Size of broods (Male & female in g)z35 & 40zAStandard (Imported SPF polychaete, squid, krill, artemia biomass))rÉ   rÊ   rË   r   Ú3011231015A2010125z2025-11-28 00:00:00Ú3011231150A5010125Ú3011231150A4010125Ú301123100720010225z2025-12-03 00:00:00Ú720z41 & 43z98.9ÚTNII15981720010127zNFDP2026-XXzBroodstock/PL supplierz9M/s. Vaisakhi Biomarine Pvt. Ltd., Marakkanam, Tamil NaduzDoF approvalzMPEDA2026-XXzPost larvae (PLs)zSize of broods/PLs (g)z0.015zQuantity of broods/PLs (No.)Ú300000zHatchery/Nursery detailsÚRGCAuŒ   Rajiv Gandhi Centre for Aquaculture (RGCA),Â MoozhiyarÂ road, Thoduvai, Thirumullaivasal Sirkali Taluk,, Thirumullaivasal, Tamil Nadu 609113z11.265341, 79.840522zTNII/2012/1598ÚNAz2026-02-02 00:00:00z(Survival rate of nauplii in hatchery (%)z$Survival rate of PLs in hatchery (%)zLarval/Nursery tank size (MT)ÚNaturalz)As per smart panel (ICAR-CIBA technology)z!Hatchery/Nursery success rate (%)zCIBA Vannamei plus (CP-38%)zNo supplementsz*Discharged water treatment plant availablezICAR-CIBA certifiedzTemp 28-31 oCz	7.2 - 8.1z4 - 7z15 - 19)	rà   úOther inputsz&Discharged water treatment system (MT)rã   rä   ÚpHz	DO (mg/L)zSalinity (ppt)r   ÚTNII1598115001A726z9Super Intensive Precision Natural Shrimp Farming (SIPNSF)z^Muttukadu Experimental Station (MES), Muttukadu, Kovalam Post, ECR, Chennai, Tamil Nadu 603112zMES of ICAR-CIBAz12.805964, 80.247878z0.4zPLs/Juvenile age (days)z!Stocking density (per cubic. mt.)Ú250z2026-02-01 00:00:00rï   zCIBA Vannamei plus (CP-34%)r§  )rä   rð   r¾   rã   rÀ   rÈ   rñ   r   ÚTNII1598101501A226ÚTNII1598115001A526ÚTNII1598115001A426ÚTNII15981720010126z0.2z0.1z2026-03-02 00:00:00rá   Ú105zB101-4az	ICAR-CIBAzNFDP4001-XXzCIBA Vannamei pluszRFish meal, Fish oil, Soy lecithin, Soy protein, Wheat, Rice, Vitamins and Mineralsz=Crude protein 34-36%; Fat 6%; Fibre 5%; Ash 15%; Moisture 10%z03-01-2026 & 31-01-2026z03-04-2026 & 31-04-2026r  zSupplied to Farmz&TNII1598115001A726 (SIPNSF MES Pond 1)zB101-4bz&TNII1598101501A226 (SIPNSF MES Pond 2)zB101-4cz&TNII1598115001A526 (SIPNSF MES Pond 3)zB101-4dz&TNII1598115001A426 (SIPNSF MES Pond 4)zB102-4ez01-02-2026 & 01-03-2026z01-05-2026 & 01-06-2026z%TNII15981720010126 (SIPNSF RGCA Farm))Ú__doc__r&   r(   r   r2   r<   rE   Úcollectionsr   ÚbasicConfigÚINFOr3   ÚdirnameÚabspathÚ__file__r6   ÚSTAGESr   r1   r�   rŸ   r§   r³   ÚLINEAGE_P_VANNAMEIÚLINEAGE_P_MONODONÚLINEAGE_P_INDICUSÚLINEAGE_XLSX_2025r   r   r   r   Ú<module>   s0   bÿþýüûúùø	÷
öõôóòñðïéÿþýüûúùø	÷
öõôóòñðïîíìëêéèçæåäãâá à!ß"Þ#Õ-ÿþýüûúùø	÷
öõôóòñðïãÿþýüûúùø	÷
öõôóòñðïíòóÿþýüûúùø	÷
öõôóòñðïèÿþýüûúùø	÷
öõôóòñðïçÿþýüûúùø	÷
öõôóòñðïìÿþýüûúùø	÷
öõôóòñðïëñóöóó � �Ç  Iÿþýüûúùø	÷
öõôóòñðïéÿÿþýüûúùø	÷
öõôóòñðïîíìëêéèçæåäãâá à!ß"Þ#ÖæFÿþýüûúùø	÷
öõôóòñðïäºdÿþýüûúùø	÷
öõôóòñðïíœzó‡ 
ô �÷ ÿþýüûúùø	÷
öõôóòñðïé �é 0ÿþýüûúùø	÷
öõôóòñðïè �Ð Jÿþýüûúùø	÷
öõôóòñðïí �¶ _ÿþýüûúùø	÷
öõôóòñðïì �¡ vò �‹  ó � �ú  ÷ � �ë   ÿþýüûúùø	÷
öõôóòñðïä � �à  >ÿþýüûúùø	÷
öõôóòñðïí � �Â  Tó � �­  cô � �ž  pÿþýüûúùø	÷
öõôóòñðïé � ��   
ÿþýüûúùø	÷
öõôóòñðïè � � �ö   $ÿþýüûúùø	÷
öõôóòñðïí � � �Ü   9ÿþýüûúùø	÷
öõôóòñðïì � � �Ç   Pò � � �±   `ó � � �¡   o÷ � � �’   yÿþýüûúùø	÷
öõôóòñðïä � � �‡    ÿþýüûúùø	÷
öõôóòñðïí � � � �è    .ó � � � �Ó    =ô � � � �Ä    Jÿþýüûúùø	÷
öõôóòñðïé � � � �¶    cÿþýüûúùø	÷
öõôóòñðïè � � � ��    }ÿþýüûúùø	÷
öõôóòñðïí � � � �ƒ     ÿþýüûúùø	÷
öõôóòñðïì � � � � �í     *ò � � � � �×     :ó � � � � �Ç     I÷ � � � � �¸     Wÿþýüûúùø	÷
öõôóòñðïéÿÿþýüûúùø	÷
öõôóòñðïîíìëêéèçæåäãâá à!ß"Þ#ÕæGÿþýüûúùø	÷
öõôóòñðïã¹fÿþýüûúùø	÷
öõôóòñðïíš|ò… ó �ô ÿþýüûúùø	÷
öõôóòñðïè �å 5ÿþýüûúùø	÷
öõôóòñðïç �Ë Pÿþýüûúùø	÷
öõôóòñðïì �° fÿþýüûúùø	÷
öõôóòñðïë �š ~ñ �ƒ  ù � �ñ  ÷ � �è  #ÿþýüûúùø	÷
öõôóòñðïã � �Ý  Bÿþýüûúùø	÷
öõôóòñðïí � �¾  Xò � �©  hó � �™  vÿþýüûúùø	÷
öõôóòñðïè � �Š   ÿþýüûúùø	÷
öõôóòñðïç � � �ï   ,ÿþýüûúùø	÷
öõôóòñðïì � � �Ô   Bÿþýüûúùø	÷
öõôóòñðïë � � �¾   Zñ � � �§   kù � � �–   tö � � ��   ÿþýüûúùø	÷
öõôóòñðïã � � ��    ÿþýüûúùø	÷
öõôóòñðïì � � � �á    6ò � � � �Ë    Fó � � � �»    Tÿþýüûúùø	÷
öõôóòñðïè � � � �¬    nÿþýüûúùø	÷
öõôóòñðïç � � � �’     
ÿþýüûúùø	÷
öõôóòñðïì � � � � �ö      ÿþýüûúùø	÷
öõôóòñðïë � � � � �à     7ÿþýüûúùø	÷
öõôóòñð � � � � �É     Jù � � � � �·     Sö � � � � �®     eÿþýüûúùø	÷
öõôóòñðïëÿþýüûúùø	÷
öõôóòñðïëÿþýüûúùø	÷
öõôóòñðïëÿþýüûúùø	÷
öõôóòñðïëÿþýüûúùø	÷
öõôóòñðïëÿþýüûúùø	÷
öõôóòñðïîíìëêéèçæåäãâá à!ß"Þ#Õ-ÿþýüûúùø	÷
öõôóòñðïçÿþýüûúùø	÷
öõôóòñðïçÿþýüûúùø	÷
öõôóòñðïçÿþýüûúùø	÷
öõôóòñðïçÿþýüûúùø	÷
öõôóòñðïçþýüûúùø	÷
öõôóòñðïîþýüûúùø	÷
öõôóòñðïîþýüûúùø	÷
öõôóòñðïîþýüûúùø	÷
öõôóòñðïîþýüûúùø	÷
öõôóòñðïî � �†